Hey guys, I've got a summer project with a couple of friends that we are working on and I need some help with how to design some of what we're doing. I can't elaborate too much, but the basic concept is that you can sign up to our site and it lets you keep a daily entry (kind of like a journal) of your daily activities. You can also search a global database for items to add to your entry, as well as have access to your own database of items to quickly add them whenever needed. (Think web calendar/agenda, but it's not).
We're pretty much done with the designing of the main database, user interface, and subscription service... but I am having trouble figuring out what is the best way to implement users in this setup. More precisely, I have no idea if each user should get a database of their own when they signup, a table in a global user database, etc. etc. (Btw, in case it makes a difference, we are working with PHP/MySQL).
I would just like some help in figuring out where/who to go to for help and information on this sort of setup. I haven't been able to find the information I want online and I was wondering if maybe anyone here knows a good place to research this. Cheers.
We're pretty much done with the designing of the main database, user interface, and subscription service... but I am having trouble figuring out what is the best way to implement users in this setup. More precisely, I have no idea if each user should get a database of their own when they signup, a table in a global user database, etc. etc. (Btw, in case it makes a difference, we are working with PHP/MySQL).
I would just like some help in figuring out where/who to go to for help and information on this sort of setup. I haven't been able to find the information I want online and I was wondering if maybe anyone here knows a good place to research this. Cheers.