[fpc-other] Firebird vs PostgreSQL

[Santiago A.]

El 27/10/2017 a las 11:17, Mark Morgan Lloyd escribió:
>
> Provided that you're not getting into things like creating new users
> on the fly, the SQL dialects are sufficiently similar that a client
> program can talk to either without substantial modification. I think
> that a reasonable approach is to select Postgres for departmental or
> larger storage, or Firebird for something that's strictly local.
>
Why Postgres is better for "departmental or larger storage"? What has
Postgres that Firebird hasn't?

I have some complains about firebird.

i.e. Can't alter views, they must be deleted an recreated.

I had made backups that couldn't be restored  because wrong data.  I
don't know it happened, maybe a change in constraints that didn't check
former valid data, but with new constraint invalid. But the overall is
that It allowed in some point invalid data, to  backup it, but not to
restore it.

But that was versions ago, I've heard it those problems where solved.

So, again, what has Postgres that Firebird hasn't? I have worked with
firebird a lot, but not with Postgres, it will be interesting a review
of someone who has worked with both.

PS: Sorry Mark, I replied to you, not to the group. ;-)


-- 
Saludos

Santiago A.