Re: Using Table prefixes

Julian Wanke <jswprog@gmx.at> wrote: > A database for each client? Isn't that over-powered? If you have 1000 > clients, you would loose the overview over your databases... I believe what is being talked about is one DB per application install -- 'client' can be a way-overloaded term. > > Am 08.06.2013, 21:46 Uhr, schrieb Tedd Sperling <tedd.sperling@gmail.com>: > > > On Jun 8, 2013, at 3:00 PM, Ashley Sheridan > > <ash@ashleysheridan.co.uk> wrote: > > dealTek <dealtek@gmail.com> wrote: > >> > >>> I can see the basic need for a table prefix in a case where you may use > >>> one mysql database for several projects at once so as to distinguish > >>> tables per project like... > >>> > >>> -snip- > >>> however I was told a long time ago to use a prefix "tbl_" like > >>> tbl_Mytable but I don't really see much need for this by itself ... Am > >>> I missing something? > >> > >> I think that's a pattern that people use to distinguish their > >> tables from views, etc, but personally I find it a little > >> pointless. It doesn't really help in any way, and just means more > >> typing. > >> > >> Using a prefix for a set of tables in one db where you might have > >> several things using the db (i.e. some hosting limits the databases > >> you can have) makes sense, and especially so if you name it > >> sensibly as in your first example. > >> Thanks, > >> Ash > > > > I agree, but more than that I also set up databases specifically for > > clients such that all the tables in them are related to the client > > and not each other, such as: > > > > client1_db > > > > contacts > > invoices > > etc > > > > and > > > > client2_db > > > > contacts > > invoices > > etc > > > > As such, the "tbl_" prefix is not needed. > > > > Cheers, > > > > tedd > > > > _____________________ > > tedd.sperling@gmail.com > > http://sperling.com > > -- > > PHP General Mailing List (http://www.php.net/) > > To unsubscribe, visit: http://www.php.net/unsub.php > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php >