endatabas
A SQL document database with full history, enabling time-travel queries and immutable data.
What is endatabas?
Endatabas (Endb) is a SQL document database that maintains a complete, immutable history of all data changes, enabling time-travel queries to retrieve data as it existed at any point. It combines the flexibility of document storage for semi-structured JSON-like data with the power of standard SQL and built-in versioning. This solves the problem of tracking data evolution and auditing changes without requiring external logging or complex application logic.
Developers building applications that require inherent auditability, temporal data analysis, or the ability to query historical states, such as in financial systems, regulatory compliance platforms, or versioned content management. Database engineers seeking a document model with relational query capabilities and immutable data storage.
Developers choose Endatabas over alternatives because it uniquely integrates full historical versioning directly into the database with SQL support, eliminating the need for separate audit logs or custom temporal solutions. Its combination of document flexibility, SQL interface, and immutable change history provides built-in reliability and query capabilities for data evolution.
Overview
SQL document database with full history.
Use Cases
Best For
- Building applications with strict audit trail and compliance requirements, such as financial transaction systems or healthcare records.
- Implementing time-travel features to query past data states, like versioned content management or historical analytics dashboards.
- Developing systems that need to track data evolution over time without overwriting records, such as collaborative editing platforms or configuration management.
- Storing and querying semi-structured JSON documents while maintaining a complete change history using standard SQL.
- Creating immutable data logs for debugging or forensic analysis in production environments.
- Integrating document storage with relational query capabilities where historical data integrity is critical, such as in legal or regulatory platforms.
Not Ideal For
- Production environments requiring stable, mature database software with long-term vendor support
- High-throughput OLTP applications where immutable data storage could impose performance overhead
- Teams needing extensive third-party tooling (e.g., ORMs, GUI clients) or a large community ecosystem
- Projects with simple CRUD requirements and no need for audit trails or historical querying
Pros & Cons
Pros
Every data change is preserved immutably, enabling time-travel queries to retrieve past states directly, as highlighted in the key features for auditability and temporal analysis.
Combines semi-structured JSON document storage with standard SQL querying, allowing relational operations on flexible data without sacrificing query power, per the project description.
Data is never overwritten by design, providing an inherent and reliable change log for compliance and debugging, eliminating the need for external logging systems.
Offers official client libraries for JavaScript/TypeScript and Python, as shown by the NPM and PyPI badges, simplifying integration into diverse tech stacks.
Cons
The project is explicitly marked as experimental and in Beta, meaning it may have bugs, breaking changes, or lack production-ready reliability, as noted in the status section.
Building from source requires installing specific versions of SBCL and Rust, and initializing submodules, which can be cumbersome and error-prone for developers.
As a new database, it likely lacks extensive documentation, community support, and third-party tools compared to established alternatives like PostgreSQL or MongoDB.
Frequently Asked Questions
Related Projects
lispc"Lispsy" Lisp(ish) to C Converter (designed for CLISP)
C-meraNext-level syntax for C-like languages :)
composable query builderAn SQL generator for Common Lisp.
cl-dbiDatabase independent interface for Common Lisp
Found a gem we're missing?
Open-Awesome is built by the community, for the community. Submit a project, suggest an awesome list, or help improve the catalog on GitHub.