eXtremeDB vs Firebird

eXtremeDB is an in-memory database system designed for embedded devices and applications. It can combine in-memory and persistent storage within one database system. Interfaces include native APIs, REST, SQL, ODBC, and JDBC, with language APIs for C/C++, Java, Python, C#, Go, and Rust. For time-series data, a sequence type provides columnar storage. Distributed options include High Availability, Cluster, and Active Replication Fabric for replication across IoT tiers. Network communications can use TLS/SSL with OpenSSL or wolfSSL. Technical specifications list maximum database sizes of 4 GB on 32-bit architectures and 18.4 exabytes on 64-bit architectures. eXtremeDB supports Android, iOS, Linux, macOS, and Windows, and can be self-hosted. Evaluation downloads are listed for Linux, macOS, and Windows; custom trial packages can be requested for other platforms. McObject offers annual engineering support contracts that include software updates and a 50 percent discount on major upgrades. Commercial licensing is paid, with pricing available on request, and a 60-day trial is listed.

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.