[Seaside] PostgreSQL v. SQLite (was: GOODS speed)

[Jimmie Houchin]

Brian Brown wrote:
[snip]
>> Postgresql.org announced native server for nt-based systems (although 
>> I didn't try it)
>> They even provide installer :), see: 
>> http://www.postgresql.org/docs/faqs/FAQ.html#1.4
>> So I wonder - what advantages have SQLite  against postgres right now?
> 
> The main advantage is only if you need to distribute your app lot's of 
> places... SQLite has no server process; you basically need one shared 
> library and your database file. You have all the capabilities of Squeak 
> with file systems to manage your data infrastructure, and don't need any 
> kind of admin access to get your database running. It also makes it very 
> easy to prototype things for the same reasons.

Yes. I think the above makes SQLite very attractive for Squeak for many 
situations. I would love to see SQLite3 for Squeak.

> I would usually prefer the PostgreSQL option for performance and name 
> recognition if given the choice.

Does PostgreSQL really outperform SQLite?
 From reading on the SQLite site, it seems depending on how you use 
SQLite (sync or nosync) SQLite is quite competitive. Even on the slower 
sync way it often bettered PostgreSQL and wasn't quite a total victory 
either direction.

However none of these trivial tests are even between PostgreSQL 8 and 
SQLite 3. That would be interesting.

If SQLite 3 was reasonably competitive with PostgreSQL 8, it would be 
attractive for many things. There would still be many times PostgreSQL 
would be the better option. Kinda depends on what you are doing.

Thanks.

Jimmie Houchin