xtdb
An immutable SQL database for application development, time-travel reporting and data compliance. Developed by @juxt
What is xtdb?
An immutable SQL database for application development, time-travel reporting and data compliance. Developed by @juxt
Overview of xtdb
What it is
XTDB is an open-source immutable SQL database with comprehensive time-travel capabilities. It is developed by JUXT and is designed to simplify application development and address complex data compliance requirements. The database is built on Apache Arrow and is cloud-native, with an ACID columnar engine designed for object storage.
Key features
- Immutable: XTDB is optimized for current-time queries, but allows auditing the full history of the database at any point without needing snapshots or accessing backups.
- Bitemporal: All data is accurately versioned as updates are made (system time), and it also allows separately recording and querying when data is, was, or will become valid in the business domain (valid time).
- Dynamic: No need to specify schema up-front before documents (rows with arbitrarily nested data) can be inserted.
- Speaks both SQL and XTQL: A full SQL dialect that implements bitemporal functionality as specified in the SQL:2011 standard, available over the Postgres wire protocol.
- Cloud native: The ACID, columnar engine is built on Apache Arrow and designed for object storage.
Use cases
XTDB is suitable for application development, time-travel reporting, and data compliance. Its immutable and bitemporal features make it useful for auditing, historical analysis, and managing data validity in business domains.
Getting started
See the repository README for installation and quick-start instructions.
License and pricing
XTDB is licensed under the Mozilla Public License, version 2.0 or (at your option) any later version. It is open-source.
這是什麼
XTDB 是一個開源的不可變 SQL 資料庫,具備全面的時間旅行功能。它由 JUXT 開發,旨在簡化應用程式開發並處理複雜的資料合規需求。該資料庫基於 Apache Arrow 構建,是雲端原生的,具有專為物件儲存設計的 ACID 欄位引擎。
主要功能
- 不可變:XTDB 針對當前時間查詢進行了最佳化,但允許在不需快照或存取備份的情況下,隨時審核資料庫的完整歷史。
- 雙時間:所有資料在更新時會準確記錄版本(系統時間),同時也允許分別記錄和查詢資料在業務領域中何時有效、曾經有效或將有效(有效時間)。
- 動態:在插入文件(具有任意巢狀資料的列)之前,無需預先指定結構。
- 支援 SQL 和 XTQL:完整的 SQL 方言,實作了 SQL:2011 標準中指定的雙時間功能,可透過 Postgres 有線協定使用。
- 雲端原生:ACID 欄位引擎基於 Apache Arrow 構建,專為物件儲存設計。
使用情境
XTDB 適用於應用程式開發、時間旅行報告和資料合規。其不可變和雙時間功能使其適用於審計、歷史分析以及管理業務領域中的資料有效性。
快速開始
請參閱儲存庫的 README 以取得安裝和快速入門說明。
授權與價格
XTDB 採用 Mozilla Public License 2.0 版(或依您的選擇,任何更新版本)授權。它是開源的。
Based on the project's public README and repository metadata.