πŸ“£ XTDB v2 is now Generally Available! Read more
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.