Firebird has "compound indexes", "unique indexes" and "functional indexes"
(usually called "Expression Indexes").
Firebird does not have "user defined types" the same way as PgSQL has,
but it does have "domains" which are subsets of standard datatypes. Does
PgSQL have these? btw, "user defined operators" make sense if you have
true user defined types, like PgSQL. Else, they don't.
Do note that MS SQL has Domains but calls them "user defined types"
(before SQL 2005).
I also suggest you rename "Compiled UDF support" to "External Function
Support" as MS SQL calles Stored Functions "User Defined Functions".
Firebird does not have Stored Functions, that might be something to add
to the list.
I'm not sure if "Write Ahead Logging" is actually a feature. I also see that
PgSQL uses this for incremental backups, Firebird has two backup tools:
a "dump" tool and a tool for very fast file system level backups, including
Yes, Firebird has Savepoints.
From the link to the PgSQL documentation, I cannot see it has built-in
replication. Either way, Firebird has several 3rd party add-on products
that provide replication.
Firebird does have "database shadows", which are exact copies of your
database that can be useful for drive failures.
I also disagree with you saying "No, Firebird does not have a "true text/
memo" datatype". It does, it's called "blob subtype text", I thought it
"clob", but it doesn't. Nevertheless, this is a good as it gets.
Yes, Firebird has "fully relational system catalogs".
Yes, there are add-on products for Firebird to create a usuable full text
With regard to version updates, what exactly is the point? The Firebird
is active, but releases less often than, for example, MySQL. True. But have
you noticed why MySQL releases that often?
Also, a few of your "no" answers will be solved in Firebird 2.1 :-)
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Database development questions? Check the forum!