Page 1 of 1
database choice
Posted: Mon Jun 29, 2009 7:08 am
by o12357
Hi there,
I'm building a website that allows users to create a profile which is then available for other users to view and search.
The profile is mainly informatory rather than social.
I am wondering whether the best way to go about it is to crate a mysql database to store all the information and use php to then generate the user page when it is called.
Any thoughts on the matter and any suggestions would be much appreciated.
Thanks!
Re: database choice
Posted: Fri Jul 03, 2009 2:03 am
by jaoudestudios
o12357 wrote:mysql database to store all the information and use php to then generate the user page when it is called.
Yes Definitely
Re: database choice
Posted: Fri Jul 03, 2009 2:30 am
by johnbrayn
which one is the best database for php?
Re: database choice
Posted: Fri Jul 03, 2009 3:19 am
by jayshields
johnbrayn wrote:which one is the best database for php?
It depends on lots of things. Generally, I would go for either MySQL or PostgeSQL because they're open-source and free. Choosing between those two is largley a matter of taste and/or previous experience.
Re: database choice
Posted: Fri Jul 03, 2009 5:24 am
by onion2k
Without wishing to go all technical, actually MySQL (or any RDBMS) is not the ideal solution for a website as the original poster described. MySQL is good at storing data that relates to other bits of data. In a site where you're storing records that aren't related you're better off with a key value data store like MemCache, Map, C-Tree, or even just a flat file storage like SQLite3. Use the database for recording things that will need to be updated, and for searching, but 'bake' the profile information into static HTML files or templates for display. It'd be considerably faster and more resource friendly.
But.. it'd also be much more complicated to write. If you're not an experienced developer you're better off just sticking with MySQL.
Re: database choice
Posted: Sat Jul 11, 2009 3:33 pm
by o12357
thanks all for your replies. sorry took so long to thank you. been away.
onion 2k, i would appreciate if you could elaborate on your suggestion. i thought of using mysql for login info only and writing a php script that would generate a seperate static html page for each user profile from the form used to generate the profile. is that a good idea? and is it anywhere near what you suggested?
thanks!