Just to add my 2p/2c.. I use multiple databases as I find this better suits my needs. It is easier to 'plug-in' various components to a client's application if each component is contained in an individual database. For example if your application was to be offered to clients as modules, then dropping in the relevant database would probably be simpler than adding/removing tables from one big database. Also I find it helps me to keep individual client data separate rather than lump it all together and add extra keys to the tables to differentiate between clients. This is of course MY preference for MY application, just airing my thoughts.... Graham > -----Original Message----- > From: Norland, Martin [mailto:Martin.Norland@xxxxxxxxxx] > Sent: 18 October 2004 22:12 > To: php-db@xxxxxxxxxxxxx > Subject: RE: how many databases should I create > > > You're talking two different users here - in my instance, I was talking > application users, not database users. Yes - realistically - you can > use just the one database and have the user permissions for it, it's > just a case of making sure you track everything right and don't access > the database through the wrong connection - not much different from > making sure you access the right database. > > Realistically - a previous comment hits the nail on the head. All a > different database is, in essence, is a different folder - a different > place where you can store the same stuff. It's all about how you want > to deal with things, how you visualize them and best interact with them. > Any database should have sufficient user privs to handle these things, > postgresql - mysql - or other. It's all about who the users who can > actually access the database are, and how the application will need to > map its users to databaes users. > > Come to think, however - I don't know that you can assign privledges > per-table in mysql. So, if your 'user levels' aren't strictly > hierarchical - you probably need to break things up (e.g. if payroll > shouldn't be able to access inventory). > > > - Martin Norland, Database / Web Developer, International Outreach x3257 > The opinion(s) contained within this email do not necessarily represent > those of St. Jude Children's Research Hospital. > > > -----Original Message----- > >From: Antoine [mailto:melser.anton@xxxxxxxxx] > >Sent: Monday, October 18, 2004 4:02 PM > >To: php-db@xxxxxxxxxxxxx > >Subject: Re: how many databases should I create > .. <chop> .. > >shouldn't a good rdbms take care of that though (with reasonable > security measures)? can't you >get fine grained user privs, at least > with a proper db? postgres? Cheers Antoine > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
