Loading...
Answers
MenuWhat's the Best way to Set Up a Relational Database?
Answers
I'm a developer of over 20 years experience and I've been building relational databases the whole time with varying degrees of normalization. I like it best when the problem is given to me as you stated above.
From your statement, it seems like you are trying to design the database. Instead, you hired a developer, and that is what they do. Have him or her design the database. Give them all the information you have and answer all their questions in a timely manner and you'll get what you need.
I'm not sure of your area of expertise or the relationship with and faith you have in your developer, but I would provide him the information from your question above. From that he/she should fire back a bunch of questions to you such as:
1. does every product require every choice?
2. Can a product have multiple options for a given choice?
3. Are the options for choices different dependent on the product?
4. Is there a higher level to consider of product categories?
... I think you get the idea.
Using this dialog can help you both think of concepts or situations you both have missed and provide you with a more robust solution.
I'd be happy to get on a call with you to discuss this further but it sounds like you have everything you need except maybe confidence in your developer(s). Best of luck.
Hello,
My name is Erik and i'm a Senior Database Architect with more than 15 years of experience and I also have 10 years of experience managing programmers.
The best way to ensure data relations between your objects (Product selected, type of coating, etc) is the following: you should explain to the developer that you want a 100% dynamic parent/child associations between objects without any limits on associations between objects.
If you need more details and/or want to schedule a call, we can go over your business requirements and I can help you build the technical specs for your programmer. I am also available to develop the data structure that you need.
Regards,
Erik Hanley
Start with a LAMP Stack - Linux + Apache + MariaDB + PHP.
Be sure to use latest Ubuntu (Linux) as your OS.
Be sure to use latest MariaDB rather than MySQL for your database.
Hire someone who's written a truckload of SQL over decades.
Have them design your database, based on how products will be accessed + searched for, as this will determine speed of your system.
Can't tell you the number of clients I've taken on in my private hosting company, where years worth of code + database design has to be scrapped because it was done incorrectly.
Hire an expert to do this right... the first time + you'll save yourself a huge amount of time + money + you'll be able to sleep well at night.
Related Questions
-
Does the 30% apple transaction fee apply to physical goods purchased on an app? Really need help Struggling Startup!
Apple specifically precludes anything that can't be delivered via the app from using in-app purchases. So you're free to tie a credit-card to services and real-world fees (think Uber) without paying Apple any transaction fees. Here's Apple's documentation on what they support (and don't allow) for in-app purchases. https://developer.apple.com/in-app-purchase/In-App-Purchase-Guidelines.pdf Happy to help in any way I can. I run a mobile-based startup myself.TW
-
How do you setup a network of suppliers and what sort of infrastructure do you need to setup replicable dropshipping partnerships.
Heard good things about GoodsCloud (www.goodscloud.com)BW
-
I'm thinking of starting a Cigar Of The Month Club. Is the monthly subscription club space too saturated?
Hi, I specialise in eCommerce strategy and marketing, helping eCommerce people make better decisions, and run more efficiently and effectively. The short answer is 'no'. Your target market isn't "subscription buyers" it's "cigar lovers". So unless there's a lot of subscription programs targeting the cigar lover, you're fine. However, if your market strategy is to go after people who like subscriptions - then I think you're not going to do so well! A cigar is a tough first sell! If you're coming at this from the "I love cigars" point of view first consider if Subscription is the best way to serve that customer base. If you're coming at this from the "I want a subscription business" point of view - then make sure you've researched cigars thoroughly before going down that road. Not least the legal restrictions on advertising - these differ from country to country, but it can be pretty hard to market tobacco online. Hope that helps. ChloeCT
-
How do I go about finding a mentor for my new drop-shipping venture?
If you'd like a Forbes-listed, Marketer of the Year as your mentor... feel free to set up a 10 minute call with me. If you look at my reviews and do some research on me, you'll quickly see why, if you want an empire, you should get my advice. My average client grows by approximately 1,400%. That's insanity.AM
-
How important is it for a marketplace startup to drive enough demand (customers) for your supply (sellers) to make a full time living off of it?
It's very important. (first, read this article by Josh Breinlinger - http://acrowdedspace.com/post/47647912203/a-critical-but-ignored-metric-for-marketplaces) The way you achieve success in a marketplace is by driving liquidity for both your supply & demand. Demand-side Liquidity = When users come to your marketplace, they can achieve their goals. Supply-side Liquidity = When supply comes to your marketplace they can achieve their goals... which are almost always to make money. If you're making a large amount of your supply-side users a full-time income, then you're helping them achieve liquidity. Now it's not so black and white and it doesn't always have to be a "full-time income." It depends what their goals are. E.g., 1) At Airbnb, renters aren't looking to quit their day jobs and become landlords full-time... they're just look to earn a substantial amount of income to offset their rent, mortgage, etc. So in this case, I would probably goal on # of renters that earn >$500 / month... and (in the first 1-5 years) try to grow this number by 10-20% MoM... and maybe by just 5% once you're in the mid-high tens of millions in yearly revenue. 2) At Kickstarter, the goal of the supply-side is to get their project successfully funded. They don't care if the project creator is "full-time"... they just want to make sure they meet their funding goal. This is why they talk about their 44% project success rate all the time - http://www.kickstarter.com/help/stats 3) At Udemy, our instructors want a substantial amount of their income to be driven from their Udemy course earnings... so we look at how many instructors are earning >$2k / month.DT
the startups.com platform
Copyright © 2025 Startups.com. All rights reserved.