Hey all,
Hope you don’t mind me asking here. I’ve been working in PHP for about a year and a half now and have finally decided that I’m at the end of my development possibilities without the use of a true db. With that in mind, I’ve just recently started playing around with mysql. However, I had two main questions that I have been able to find concrete answers for as of yet in my reading.
First, databases. At work, I develop large and small programs. They are all used daily but some may only have 6 or 7 fields, and don’t coincide with any other programs that I make, they’re standalone for all intents and purposes. If I wanted to change something like this over to mysql instead of using text files as it does now, should I create a new database just for it or should I create one larger database and have the smaller programs feed off of different tables in it?
Second is administration. I’ve started out creating dbs, tables and columns through a console window, but I would assume there is a much friendlier way, especially considering the character limitations per line. I had installed apache, mysql and php as a firepages bundle. Should I use the existing phpmyadmin that’s included or should I use something else that is otherwise preferred?
Thanks for your help