The database for our time
To simplify development, reporting and compliance for immutable systems.
SQL that remembers everything,
with corrections and flexible schema,
for fine-grained reporting and time travel:
Installation
Run XTDB using Docker and connect via a PostgreSQL wire-compatible connection.
# latest release, 100% open source (MPL-2.0 license)
docker run -p 5432:5432 ghcr.io/xtdb/xtdb# connect via Postgres tooling and drivers, e.g.
psql -h localhost xtdb -c "SELECT 42"
“Why did we make that decision?”
Effective auditability drives trust and learning, supported by:
- Immutable records and observations
- Handling of errors and delays
- Decisions aligned with full context
- Easy reflection on past states
Business data as evolving time series.
XTDB records a full 'bitemporal' history of data, observable across time:
- Some data is always 'on time'
- Other data often arrives late
- Mistakes must be corrected
- Data evolves and 'versions' are retained
An architecture for decision intelligence.
Transactional data with perfect memory:
- History without headaches - avoid custom versioning, 'soft deletes', and brittle data pipelines
- Object store LSM-Tree design with bitemporal historical partitioning for durability, scalability, and cost-effective retention
- Postgres-compatible SERIALIZABLE SQL transactions with optimistic concurrency
- Fine-grained versioning with Apache Arrow for temporal analytics using scale-out compute
History Simplified
Request a demo
Schedule a free demo with our solution engineers to learn how XTDB can help address your complex domain and architecture requirements.