Subject | Re: [ib-support] Comparison between Firebird and Postgres |
---|---|
Author | Paul Schmidt |
Post date | 2003-01-25T12:34:51Z |
On January 24, 2003 07:00 am, you wrote:
1) PSQL is not Windows friendly at the server, it depends on having a running
MinGW (at least) environment, and uses a lot of command line tools to perform
maintenance.
2) PSQL maintains a seperate file for each table, and like MySQL this is case
sensitive in some environments and not in others, for example if you do your
development in Windows (case insensitive) and the program is run on Linux
(case sensitive) it breaks.
3) They are much further from SQL-92 compliance, at least they were last time
I checked. They are still very much pre-SQL based and use non-standard ways
of doing many things.
4) They don't have our group of fine folks looking after it, this is why I am
currently trying to figure out how to build FB 1.5 on my Linux machine rather
then using the PSQL that came with it.
5) They have far fewer third party libraries and tools to interface with the
engine.
> I need comparison between firebird and postgres. I work with Firebird,FB has several advantages over PSQL:
> but i need prove with my colleague, the excellence of the Firebird.
>
1) PSQL is not Windows friendly at the server, it depends on having a running
MinGW (at least) environment, and uses a lot of command line tools to perform
maintenance.
2) PSQL maintains a seperate file for each table, and like MySQL this is case
sensitive in some environments and not in others, for example if you do your
development in Windows (case insensitive) and the program is run on Linux
(case sensitive) it breaks.
3) They are much further from SQL-92 compliance, at least they were last time
I checked. They are still very much pre-SQL based and use non-standard ways
of doing many things.
4) They don't have our group of fine folks looking after it, this is why I am
currently trying to figure out how to build FB 1.5 on my Linux machine rather
then using the PSQL that came with it.
5) They have far fewer third party libraries and tools to interface with the
engine.