XTDB 2.x early access
published on 2023/04/29
Cloud native: modern columnar architecture built around Apache Arrow and commodity object storage. Bitemporal: all data is accurately versioned as updates are made (system time), and all data exists within a universal domain timeline for representing 'validity'/'effectivity' (valid time). Dynamic: no upfront schema needs to be specified before records can be inserted. Complex and nested data is automatically represented using Apache Arrow types. Relational: the full spectrum of traditional SQL database capabilities is available - including joins, transactions, bag/multiset semantics, three-valued logic, multiple N-ary relations etc. SQL: unrestricted accessibility for a mainstream audience and an eye to the future with preliminary Flight SQL driver support. Datalog: programmer-friendly API for complex relational querying that overcomes many of SQL’s compositional challenges.