SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Addict
    Join Date
    May 2008
    Missouri, USA
    0 Post(s)
    0 Thread(s)

    Database Organization

    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.

  2. #2
    SitePoint Mentor bronze trophy
    John_Betong's Avatar
    Join Date
    Aug 2005
    City of Angels
    74 Post(s)
    7 Thread(s)
    Try a couple of tutorials on database normalization .

    I believe a single database is adequate and preferable to duplicating data in your second approach.
    Learn how to be ready for The New Move to Discourse

    How to make Make Money Now with a *NEW* look

    Be sure to congratulate Wolfshade on earning Member of the Month for August 2014


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts