I am working on a new project. I am trying something new and so wanted some input so that i dont make it tough on myself in the future. I am creating a statistic web application.
The users will be able to create an account and keep there own separate statistics. There are 6 tables which will be interconnected for each stat account.
Right now I have two different approaches in mind.
1.) Use one database and ensure that each entry in each table properly points to one specific user account.
2.)Create a new database and tables for each user account.
Is it good practice to layer on multiple users data into a single database? Will that cause any problems in the long run? Or am i just fretting over nothing?.
I appreciate your help. I am just a hobbyist so my knowledge on web application development is a little flawed.