An observation: the one recent study that pumped up Firebird seemed to come out of nowhere, and its findings have yet
tobe corroborated elsewhere. While as others have noted, Firebird is a fine product (and has a longer history on the
Windowsplatform), I think a little skepticism as to its market penetration and community size is warranted. Could be
thatthe study was oversampling legacy Interbase users, for example.
Benjamin Smith wrote:
> As a long-time user of Postgres, (First started using it at 7.0) I'm reading
> recently that Firebird has been taking off as a database.
>
> Perhaps this is not the best place to ask this, but is there any compelling
> advantage to using Firebird over Postgres? We have a large database (almost
> 100 tables of highly normalized data) heavily loaded with foreign keys and
> other constraints, and our application makes heavy use of transactions.
>
> I say this as my company's growth has been exponential, showing no sign of
> letting up soon, and I'm reviewing clustering and replication technologies so
> that we can continue to scale as nicely as we have to date with our single
> server. (now with a load avg around .30 typically)
>
> -Ben