Datomic vs XTDB
Datomic: Immutable Datalog database from Nubank where every fact is timestamped and queries run in the app process. XTDB: Bitemporal SQL database on object storage that keeps every version of every row.
key differences
- Licensing: Datomic is open source (permissive) (Apache-2.0 (binaries only; source not published)); XTDB is open source (copyleft) (Mozilla Public License 2.0).
- Horizontal scaling is none in Datomic and manual in XTDB.
- Only Datomic has secondary indexes, full-text search, change data capture.
- Only XTDB has json, columnar storage, compression.
- Datomic can run embedded in your application process.
choose datomic for
- +Financial and banking domain models needing auditability
- +Systems that must answer what was known at a given time
- +Complex domain graphs in Clojure services
best at · OLTP, Event sourcing, Ledger
choose xtdb for
- +Financial and insurance systems needing as-of reporting
- +Audit trails with retroactive corrections
- +Event-sourced systems wanting SQL over history
best at · OLTP, Event sourcing, Ledger
Datomic vs XTDB: FAQ
What is the difference between Datomic and XTDB?
Datomic: Immutable Datalog database from Nubank where every fact is timestamped and queries run in the app process. XTDB: Bitemporal SQL database on object storage that keeps every version of every row. Licensing: Datomic is open source (permissive) (Apache-2.0 (binaries only; source not published)); XTDB is open source (copyleft) (Mozilla Public License 2.0). Horizontal scaling is none in Datomic and manual in XTDB. Only Datomic has secondary indexes, full-text search, change data capture.
When should I choose Datomic over XTDB?
Choose Datomic for financial and banking domain models needing auditability; systems that must answer what was known at a given time; and complex domain graphs in Clojure services. Choose XTDB for financial and insurance systems needing as-of reporting; audit trails with retroactive corrections; and event-sourced systems wanting SQL over history.
Is Datomic or XTDB more popular?
Datomic ranks #225 on the WhichDB Score (14.9/100) and XTDB ranks #328 (8.3/100). Popularity is not fit: check the requirements that matter for your project.
Are Datomic and XTDB open source?
Yes. Datomic is open source. License: Apache-2.0 (binaries only; source not published). Yes. XTDB is open source. License: Mozilla Public License 2.0.