Go Green wrote:

> I have never used firebird and therefore wanted to know how it fits when compared to MySQL in terms of:

If you use MyISAM, then the answers are:

> ANSI SQL compliance

Firebird is much better.

> Triggers

Firebird is much better.

> Foreign Keys

Firebird is much better.

> Stored Procedures

Firebird is much better.

> High Availability

Firebird is much better, for example, you can do hot-backup while system
is running.

I can't tell about InnoDB, as I never used it myself. The only two
reasons I still use MySQL on some projects are:

1. speed

2. availability of transaction-less storage (MyISAM) which saves you
from having to backup/restore periodically to reset transaction counters

Note that 1. and 2. are related, MyISAM is much faster than Firebird
just because it has no transaction overhead.

--
Milan Babuskov

==================================
The easiest way to import XML, CSV
and textual files into Firebird:
http://www.guacosoft.com/xmlwizard
==================================