- 1) It's really free without hidden conditions and fully Open Source (MySQL isn't like that although I believe MariaDB is).
2)Each database is located in one independent file (I particularly don't feel confortable with MySQL / DBF because of those many files)
3) The instalation is very easy and works on most operating systems
4) Backup and replication is easy and powerful even with the database in use
5) Active community - very hospitable like HMG
6) Fully supports referencial integrity (Seems that MariaDB supports is partially) (Source: http://en.wikipedia.org/wiki/Comparison ... ems#feat_3)
7) Data domain (I like this one to help standarize the fields through the whole application)
8) You can create and use an embedded database (serveless kind of like SQLite)
9) Multi-generation architeture (readers don't lock writers)
See also: http://www.firebirdsql.org/en/features/" onclick="window.open(this.href);return false;" onclick="window.open(this.href);return false;" onclick="window.open(this.href);return false;" onclick="window.open(this.href);return false;" onclick="window.open(this.href);return false;
Disadvantages:
- 1) No encryption (I mean something like SQLCipher for SQLite but for Firebird)
2) It's pretty easy to open and see the data if you have physical access to the database (encryption would help here)
3) Doesn't automatically clean garbage/shadow left from unswept deletions. The only way is by a full backup/restore. It may affect the performance
4) Documentation is pretty confusing and spreaded in different files although I don't really need complex features and for the basic things it's pretty cool.
Probably there are other disadvanges that I didn't find yet...
Could you please explain more about that? I would appreciate it.IMHO, MariaDB is better than FireBird in simplicity.