Re: Is my MySQL Gaining ?

On Dec 29, 2003, at 6:40, Ericson Smith wrote:

> In terms of using MySQL or Postgresql, lets all face it, most data 
> storage work could be easily and efficiently handled by text files, 
> since there needs to be just infrequent inserts and updates, and 
> mostly reads. The majority of interfaces exposed on the web follow 
> this paradigm, and include:
> * Content management
> * Catalogs
> * Shopping cart stuff
> * User management
>
> Yes, our powerful and easy to use PG can do all of that too, but 
> SQLite, Sleepycat DBM files

	In case of SQLite, BDB, plain files, etc... that all requires there to 
be only a single system running your app and DB through the lifetime of 
the application.

	Transactions are definitely required for most of those things to work 
correctly (how do you turn a shopping cart into an order correctly 
without a transaction?).  SQLite and BDB will get you there given the 
previous caveat.

	Neither really gives you an easy way to look at your data directly.  
SQLite's tools are no psql, and I've had problems trying to read data 
from apps that use sqlite while it's got the thing open (file locking 
problems).

--
SPY                      My girlfriend asked me which one I like better.
pub  1024/3CAE01D5 1994/11/03 Dustin Sallings <dustin@spy.net>
|    Key fingerprint =  87 02 57 08 02 D0 DA D6  C8 0F 3E 65 51 98 D8 BE
L_______________________ I hope the answer won't upset her. ____________