Try XTDB Core2
Boot Core2 in seconds.
Use any Postgres-compatible client.
Instant Schemaless Writes
XTDB does not require any pre-defined schema or tables. Every insert, update, and delete is immutable.
First-Class Arrays and Objects
Nested data is natural. Objects are not opaque. Instead, they are seamlessly integrated with SQL.
XTDB defaults to the SQL:2011 standard. It also offers optional defaults for a more intuitive experience.
Time in XTDB is optional – but universal. Advanced applications can even query time itself.
INSERT INTO posts (id, user_id, text, application_time_start)
VALUES (9012, 5678, 'Happy 2025!', DATE '2025-01-01');
SELECT posts.text FROM posts
FOR APPLICATION_TIME AS OF DATE '2025-01-02';
SELECT posts.text FROM posts;
Native Apache Arrow
XTDB speaks Apache Arrow as readily as it speaks SQL.
To comply with privacy laws, erasure is necessary when handling Immutable Records.
Separated Storage and Compute
XTDB Core2's compute nodes can scale independently of its object storage layer. This separation allows immutable records to be retained indefinitely and queries to scale horizontally.
You can find more information at core2docs.xtdb.com, Core2's preliminary documentation.
Core2 is the product of many years' research. If you are a developer or researcher interested in Core2's background, you can read and download our Core2 bibliography on Zotero .
Core2 is not currently stable or intended for real-world evaluation. Please see the rest of the xtdb.com website for information on XTDB 1.x, our commercially-supported software for production use.
XTDB vs. XTDB Core2
Core2's objective is to take the key principles embodied in XTDB 1.x – immutability, schemaless records, and temporal querying – to a mainstream SQL audience.
|XTDB 1.x||Core2 Research Concept|
|Initial Stable Release||2019||TBD|
|Interface||Java + edn Datalog||SQL — PostgreSQL native drivers, JDBC |
NewSQL — HTTP (planned), Arrow FlightSQL (planned)
|Secondary Interface||OpenAPI, Calcite SQL (read-only)||Many secondary languages (Datalog, SPARQL, Gremlin, etc.) are possible|
|Execution Model||Tuple-at-a-Time Sort-Merge Joins||Vectorized Relational Algebra|
|Storage & Compute||Coupled (nodes are full replicas)||Separated (cost-effective scale out)|
|Storage Format||Custom Key-Value encodings||Columnar Apache Arrow|
|Bitemporal Querying||Timeslice only ('as-of')||SQL:2011 and beyond|
|Index Upgrades||Full log replay||Online|
|Transaction Log||Infinite Retention||Ephemeral WAL|
|Persistence Layer||Transaction Log + Document Store||Object Store|
Ethos: Fully Open Source
JUXT holds a fundamental belief that any product we create must be fully open source and XTDB is no exception. We say "fully" because we do not consider "open core" products to be open source. Quality software speaks for itself and does not need to hide behind restrictive licenses.
All software has a lifespan. When closed-source software breathes its last, customers are left stranded. We consider this unethical. Your business should not be forced to accept the risk of closed-source software.
XTDB Core2 is licensed under the GNU Affero General Public License, v3. Commercial and Warranty licenses are available, where required.