The database for our time

XTDB is a bitemporal and dynamic relational database for SQL and Datalog

Get started for free >Book a live demo >

Using XTDB

Use SQL and Datalog to time-travel and analyze relationships across your entire history of records.

;; using query param validTime="1927-09-05T10:13:30Z" ...
{:find [?relative]
 :where [[?person :first-name "John"]
         [?person :last-name ?last-name]
         [?relative :last-name ?last-name]}

VALIDTIME ('2016-12-01T10:13:30Z')
SELECT p2.id FROM person AS p1, person AS p2
WHERE p1.first_name = 'John' AND p2.last_name = p1.last_name;

Datalog SQL

Record-based operations for working with dynamic, nested data effortlessly: Put, Delete, Match, Evict

[:xtdb.api/put
 {:xt/id      "john-mccarthy"
  :first-name "John"
  :last-name  "McCarthy"
  :birth-date #inst "1927-09-04"}
 #inst "1927-09-04"] ;; retroactive insertion

Datalog

Using XTDB

Temporal Query Transactions Eviction

Use SQL and Datalog to time-travel and analyze relationships across your entire history of records.

;; using query param validTime="1927-09-05T10:13:30Z" ...
{:find [?relative]
 :where [[?person :first-name "John"]
         [?person :last-name ?last-name]
         [?relative :last-name ?last-name]}

VALIDTIME ('2016-12-01T10:13:30Z')
SELECT p2.id FROM person AS p1, person AS p2
WHERE p1.first_name = 'John' AND p2.last_name = p1.last_name;

Datalog SQL

Record-based operations for working with dynamic, nested data effortlessly: Put, Delete, Match, Evict

[:xtdb.api/put
 {:xt/id      "john-mccarthy"
  :first-name "John"
  :last-name  "McCarthy"
  :birth-date #inst "1927-09-04"}
 #inst "1927-09-04"] ;; retroactive insertion

Datalog

Features

Bitemporal Records

Accurate and automatic history of immutable data

Dynamic Processing

Query without schema across complex, dynamic types

SQL & Datalog APIs

Relational languages for dynamic & temporal software

Cloud Native

Read-scalable ACID compute for commodity storage

View All >

These amazing companies trust XTDB:

Oskar Boëthius Lissheim

Multiply.co

“Choosing XTDB accelerated our roadmap and allows us to develop with confidence”

more... More >

Success Stories

Risk Systems

End-of-Day

Risk Systems benefit directly from bitemporal modeling. Valid Time can be used to correlate out-of-order trade data whilst making compliance easy.

Data Products

Analytical APIs

Exposing data across an organization is a challenge when things are changing all the time. XTDB simplifies data exchange and can power advanced temporal analysis.

Price Management

Scheduled Updates

Modeling future pricing, tax and discount changes requires extensive temporal queries. An accurate representation of discount rule changes is key for projecting offer prices and net margin.

View All >

Technology Integrations

Request a demo

Discover how you can transform your dynamic and temporal applications with XTDB.

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

Learn more

What is XTDB?

Philosophy > Features

We believe that businesses more generally—not just developer communities—are being significantly underserved by the current crop of technologies. This can be seen wherever immutability or time is concerned…

Key Concepts

Temporal Records

Why is immutability important and how is it hard? In what ways can SQL be complemented by Datalog? What is the relationship between documents, graphs, and the relational model? Read on…

Intro to Datalog

Try XTDB now!

XTDB is very easy to get started with via HTTP, Java or Clojure. All you need is a client driver or Curl! Discover how you can effortlessly insert data immutably, query it back again across time, and write complex joins…