Should an entire website have one database, assuming there are only a few tables? When is it appropriate to have more than one database? Thanks
Generally you would use a single database for a single application. You can add as many tables as you need, but for the sake of making only a single database connection at a time, and to keep everything transportable, one is best IMO. It really depends on the specific situation, but I don't think making a bunch of separate databases is a good thing in most cases.
yes its all application based,seperate application should have seperate db unless or untill those applications are related. Regards Alex