By using our site, you acknowledge that you have read and understand our Cookie Policy , Privacy Policy , and our Terms of Service. Stack Overflow for Teams is a private, secure spot for you and your coworkers to find and share information. Assume a dating-site-like web application wherein each profile can have one or more users. Each user, say, has the following columns: name, age, gender. Learn more. Database Design: dating-site-like application?
mysql - Database Design: dating-site-like application? - Stack Overflow
Comment 0. We came up with an idea for a dating site and an initial model in Part One. Is this Agile or am I just being an idiot? First obvious thing is, we need a schema. The only real schema we need to worry about are Constraints and Indexes. We also want our users to pick Attributes they have and Attributes they want in a potential mate. To keep things keep clean and help the matching, we will seed the database with some Attributes and not let the users create them dynamically.
Even more so, niche dating is heavily unsaturated. You can quickly put together some of your ideas, discuss and test to see if you have a market for that. NOTE: If in case you are planning to develop a clone, you should understand that your market validation has already been done.