On Sat, 27 Dec 2003, Chris Travers wrote: > Date: Sat, 27 Dec 2003 18:44:48 +0700 > From: Chris Travers <[EMAIL PROTECTED]> > To: Marc G. Fournier <[EMAIL PROTECTED]> > Cc: [EMAIL PROTECTED], [EMAIL PROTECTED], > [EMAIL PROTECTED] > Subject: Re: [GENERAL] Is my MySQL Gaining ? > >
<snip> > In short, I do not see MySQL as any sort of threat to PostgreSQL, near or > long-term. PostgreSQL will continue when MySQL no longer exists. Firebird > is a more serious competitor long-term, though I found it to be hard to > learn when compared to PostgreSQL. It has a long way to go before being as > easy to use as PostgreSQL. > > I suggest that it is a bit premature, to suggest that MySQL will disappear, and that PostgreSQL will still exist. Each does have its advantages, and, people develop things in parallel in the two different systems. For example, on the perl-gedcom list, people have developed, in parallel, genealogy database systems that they use, some using MySQL, some using PostgreSQL. People have their preferences, as some still use (or require to be used) MS Access, or Foxpro, or SQL-Server, or Informix, etc. Does PostgreSQL yet allow the user or programmer, to determine where the database will be stored? From memory, that has (or had) been a shortcoming of PodtgreSQL; there was no control as to where the database was stored, so that, for example, from my understanding, where an ISP allowed PostgreSQL usage for web sites, all of the PostgreSQL databases of all the ISP account holders, were stored in the same location, which was not under the account-holder's home directory; similarly, if I, on a LAN, create a database InventoryThing, as user frednerk, and, create a database AccountsThing, as user joebloggs, my understanding is that both databases will be stored in a central PostgreSQL repository, rather than under each user home directory. Thus, if the frednerk home directory and everything under it, is backed up by frednerk, it appears that InventoryThing is not backed up, and, similarly, with joebloggs and AccountsThing. Likewise with separate ISP accounts and any PostgreSQL databases that they have and use on their web sites. Clarification of whether my understanding is correct, would be appreciated. -- Bret Busby Armadale West Australia .............. "So once you do know what the question actually is, you'll know what the answer means." - Deep Thought, Chapter 28 of "The Hitchhiker's Guide to the Galaxy: A Trilogy In Four Parts", written by Douglas Adams, published by Pan Books, 1992 .................................................... ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
