Is it unreasonable to assign a MySQL database to each user on my site?

by

Use one database.

Use one table to hold users and one table to hold quotes.

In between those two tables you have a table that contains information to match users to quotes, this table will hold the rating that a user has given a quote.

This simple design will allow you to store a practically unlimited number of quotes, unlimited users, and you will be able to match up each quote to zero or more users and vice versa.

The table in the middle will contain foreign keys to the user and quote tables.

You might find it helpful to review some database design basics, there are plenty of related questions here on stackoverflow.

Start with these…

What is normalisation?

What is important to keep in mind when designing a database

How many fields is ‘too many’?

More tables or more columns?

More Related Contents:

  1. Authentication plugin ‘caching_sha2_password’ cannot be loaded
  2. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  3. Is there a MySQL option/feature to track history of changes to records?
  4. Binary Data in MySQL [closed]
  5. Using an Alias in SQL Calculations
  6. Can a table field contain a hyphen?
  7. Adding a leading zero to some values in column in MySQL
  8. Auto Generate Database Diagram MySQL [closed]
  9. MySQL : Multiple row as comma separated single row
  10. Check for x consecutive days – given timestamps in database
  11. MySQL Insert Into from one Database in another
  12. How do I get the ID of multiple inserted rows in MySQL?
  13. Case statement in MySQL
  14. Export a MySQL Database to SQLite Database
  15. How do I show the schema of a table in a MySQL database?
  16. How to find out the MySQL root password
  17. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  18. MySQL concatenating all columns
  19. Remove special characters from a database field
  20. Proper database model for a user feedback system (an interesting case)
  21. How big can a MySQL database get before performance starts to degrade
  22. Easiest way to copy a table from one database to another?
  23. MySQL – Replace Character in Columns
  24. FIND_IN_SET with multiple value [duplicate]
  25. WooCommerce: Finding the products in database
  26. Put MySQL database under version control?
  27. Are there any functions in MySQL like dense_rank() and row_number() like Oracle?
  28. Create a new database with MySQL Workbench
  29. Optimistic locking in MySQL
  30. How to search and replace all instances of a string within a database?

Leave a Comment