Skip to content

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.

Get Started

# 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?”

Data Reports Decisions Audit

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
When it happened When it was recorded in the system Price = 15 08:00 AM 08:00 AM Price = 12 10:00 AM 03:30 PM Price = 10 12:00 PM 02:00 PM

An architecture for decision intelligence.

Log-Structured Merge (LSM) Diagram

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

Request a demo

Schedule a free demo with our solution engineers to learn how XTDB can help address your complex domain and architecture requirements.