RPK wrote:
How is FireBird rated when compared with PostgreSQL?
Firebird is a good db. But it has its spaces. Its is the little brother of PG.
It has two modes: classic (spawn per connection, small caching) and superServer (one program w/threads and lots of caching). superserver does not run well on SMP. If you need SMP run classic.
The best part is the maintenance. Its very simple to setup and run and requires no maintenance. I'd say for medium size its great, but for huge, go PG.
Firebird does not span disks well (you can have multiple files, but cannot tell what's in each file), no clustering, and poor replication (3rd party only).
So, really, it depends on your needs. -Andy
