Firebird vs LMDB
Firebird
firebirdsql.orgLMDB
symas.comSide by side
| Figure | Firebird | LMDB |
|---|---|---|
| Price from | €199/mo | — |
| Free plan | Yes | — |
| Free trial | — | — |
| Open source | — | — |
| Web | — | Yes |
| Windows | Yes | Yes |
| macOS | Yes | Yes |
| Linux | Yes | Yes |
| Self-hosted | Yes | Yes |
| Plans published | 2 | 2 |
| Spec score · Embedded Databases | 8.5 (#5) | 7.5 (#22) |
| Concurrency | Its multi-generation architecture lets readers access data without blocking writers under most conditions. | Readers do not block writers, writers do not block readers, and multiple processes can open the same environment on one host. |
| Support | Free community support is available through Firebird support mailing lists, with commercial and special support also offered. | Symas offers fixed-price Gold or Enterprise source-level support and porting or professional services for LMDB users. |
Plans
In their own words
Firebird
Firebird is a free, open-source relational database management system with ANSI SQL features. It runs on Linux, macOS, and Windows, and supports self-hosted deployment. Its multi-generation architecture generally allows readers to access data without blocking writers. SQL features include stored procedures, triggers, common table expressions, cross-database queries, and flexible transaction management. A Trace API and monitoring tables support real-time monitoring, SQL debugging, and auditing. Security controls include users and roles, GRANT and REVOKE permissions, and a database owner concept; Windows Trusted Authentication can integrate with Windows domain or Active Directory security. Deployment choices include embedded, SuperServer, SuperClassic, and Classic architectures. Backup options include online backups and dumps, as well as incremental backup with partly supported point-in-time recovery. Drivers include Java JDBC,.NET, Python, ODBC, PHP, Delphi, and C++ Builder. Free community support is available through mailing lists, alongside commercial and special support. Firebird lists versions 5.0.4, 4.0.7, and 3.0.14 as latest in their series; versions 2.5 and earlier are discontinued and no longer maintained. The enterprise subscription is €199 a month, billed from €199/month/1 servers.