Feature | Firebird | MySQL |
---|---|---|
Version | 1.5.2 | 4.1.0 |
Referential integrity(1) | Yes | Yes(*) |
Constraints(2) | Yes | No |
Stored Procedures | Yes | No |
Triggers | Yes | No |
External Functions | Yes | ? |
Replication(3) | No | Yes |
ODBC Driver | Yes | Yes |
ADO/.NET Driver | Yes | Yes |
JDBC Driver | Yes | Yes |
PHP Driver | Yes | Yes |
dbExpress | Yes | Yes |
Online backups | Yes | Yes(*) |
Character set handling(4) | Yes | Yes |
Embedded version(5) | Yes | Yes |
Transactions | Yes | Yes(*) |
Views | Yes | No |
Query caching | ? | Yes |
SQL-99 Standard Compliance | Not full | Not full |
Lock table | No | Yes |
Author: Abel F. Laborda.
Please, report any bug or comment.
You can distribute this document freely.