Thomas Steinmaurer wrote:

> From a current evaluation project, some requirements missing in
> Firebird 1.5.2 come up. ;-)
>
> - Fine-granular multi-threading and SMP support
> - Support for different authentication protocols like Kerberos, ...
> - Full-Text search capabilities (I know, there are third-party
> solutions available, but usually people I know are asking for
> a built-in solution)
> - Clustering (Load Balancing, Hot-Standby)
> - Incremental Backup, Point-In-Time Recovery
> - Cross-Database-Queries
> - Gateways to other data sources (e.g. connecting to another
> DBMS within a stored procedure)
> - NUMERICs/DECIMALs with a precision up to 38
> - Monitoring and Profiling capabilities (to see what's going
> on in the database; running statements, transactions, ...)
> - and some more ...
>
> Don't know whether Ingres supports some of the features
> mentioned above. Firebird 2 will have e.g. Incremental
> Backup. A pitty that the monitoring stuff won't go into
> v2.

That is the heavy weight stuff, and it would be nice to see what other
engines currently support ( and the cost ;) )

What also needs adding to this list is the missing SQL functions. Silly
things like ENUM, which the MySQL people quote as a 'plus' for them, but
I see as a major minus because of the way its implemented ( fixed text
in the DML ). We can handle ENUM a lot better, but it needs work
'outside the box', I am sure there are other things like this that we
should be aware of and provide work rounds or alternatives.

It strikes me that it would be useful to have this set up on a 'wiki'
type site, so we can add items, update information, and provide
comparison data.
http://www.dbtuning.org
might be a 'home' for that type of data and comparisons. It would at
least get information from other systems as well :)

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services