Re: PostgreSQL/FireBird - Mailing list pgsql-general

FireBird has a different target audience than PostgreSQL, which is why
it's not compared to PostgreSQL as often as MySQL is.

FireBird is a direct descendant of Borland InterBase 6.  Consequently,
much like Postgres inherited a lot of Ingres's weirdness (most of which
has since been weeded out or superceeded with standard SQL compliance),
FireBird is still very much InterBase dialect-compliant.  This is also
why it still uses a modified Mozilla Public License.  I know they've
achieved ANSI SQL-92 compliance, but I don't know how fully compliant
beyond that they are.  PostgreSQL is mostly working on SQL-03 compliance
AFAICT.  Both use MVCC.

Interbase was also primarily used for single instance and embedded
applications, so it's not intended to scale the same way PostgreSQL is.


Firebird's design foci are very small memory footprint, ANSI SQL-92
complaince, multiple dialects that support aging systems, and very low
administrative requirements.  It lack features and scalability compares
to PG, but does what it does very well.

PostgreSQL's design foci are features and robustness.  It's designed to
compete with Oracle, DB2, MS SQL, and other top-end enterprise
databases.  It has a much larger memory footprint and is much more
complicated to administer compared to FB, but is much more configurable
and customizable.

Bottom line:  PostgreSQL is more mature because it's several years
older.  Firebird is intended for different applications.

--
Brandon Aiken
CS/IT Systems Engineer

-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org] On Behalf Of RPK
Sent: Thursday, February 01, 2007 10:32 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] PostgreSQL/FireBird


How is FireBird rated when compared with PostgreSQL?
--
View this message in context:
http://www.nabble.com/PostgreSQL-FireBird-tf3158857.html#a8761237
Sent from the PostgreSQL - general mailing list archive at Nabble.com.


---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faq


--------------------------------------------------------------------
** LEGAL DISCLAIMER **
Statements made in this e-mail may or may not reflect the views and
opinions of Wineman Technology, Inc. or its employees.

This e-mail message and any attachments may contain legally privileged,
confidential or proprietary information. If you are not the intended
recipient(s), or the employee or agent responsible for delivery of
this message to the intended recipient(s), you are hereby notified
that any dissemination, distribution or copying of this e-mail
message is strictly prohibited. If you have received this message in
error, please immediately notify the sender and delete this e-mail
message from your computer.