Re: PostgreSQL vs Firebird SQL

On Tue, Feb 9, 2016 at 10:10 PM, ioan ghip <ioan(at)pangea-comm(dot)com> wrote:
> I have a Firebird SQL database running on one of my servers which has about
> 50k inserts, about 100k updates and about 30k deletes every day. There are
> about 4 million records in 24 tables. I have a bunch of stored procedures,
> triggers, events and views that I'm using.
> Firebird works fairly well, but from time to time the database gets
> corrupted and I couldn't figure out yet (after many years of running) what's
> the reason. When this happens I run "gfix -mend -full -ignore", backup and
> restore the db and everything is fine until next problem in a week, or a
> month.
>
> I never used PostgreSQL. Yesterday I installed it on my development machine
> and after few tests I saw that it's fairly easy to use.

> Does anyone have experience with both, Firebird and PostgreSQL?
yes

> Is PostgreSQL way better performing than Firebird?
yes

> Is it worth the effort moving away from Firebird?
yes

> Would I gain stability and increased performance?
yes

Firebird was and is a pretty neat database. I still remember when I
first fired up Delphi and whipped out an application in about 10
minutes. Well, it's time to move on...you're with us now.

merlin