Re: [SQLObject] Recommended backend.

[David W. <da...@su...>]

Jonathan,

>  > - zero management needed (essentially fit and forget)
> 
> Management requirements aren't a significant factor with MySQL or 
> PostgreSQL, either.  Oracle, maybe. :)

PostgreSQL has typically needed more than Firebird with Vaccuum etc. But 
I agree with you.

>  > - uses a record versioning engine (postgres does too but is a much later
>  > implementation, Firebird has always worked that way).
> 
> I don't know about firebird, but postgresql's MVCC (multi-versioning 
> concurrency control) system has been in place at least since version 6.5 
> circa 1996.  Maybe firebird's is older still, but arguing that 9 years 
> isn't enough to achieve stability doesn't hold water with me.

I was not questioning PostgreSQL's stability. I have used it a lot with 
no problems. One could argue that a more recent implementation of MVCC 
is better. But Firebird (ex Interbase, ex something else) has had it a 
lot longer than 1996.

Until recently Postgres did not have very good windows support and Mysql 
did not have any tranbsaction options therefore Firebird had a place 
nothing else could fill. Now ...

Regards

Dave