SirixDB 1.0 Beta – Git-Like Versioning, Diffs, Time-Travel Queries
Structural sharing below page level beats ZFS block copying and event replay.
SirixDB is an an embeddable, bitemporal, append-only database system and event store, storing immutable lightweight snapshots. It keeps the full history of each resource. Every commit stores a space-efficient snapshot through structural sharing. It is log-structured and never overwrites data. SirixDB uses a novel page-level versioning approach.
Query any past revision instantly without replaying logs or reconstructing state.
Backend engineers building audit-heavy or temporal applications
Datomic · EventStoreDB · Crux
Structural sharing below page level beats ZFS block copying and event replay.
Type-safe JSON migrations inspired by database patterns—clean API but crowded space.
Local CLI for prompt versioning using JSON stores instead of actual Git commits.
Zero-config single-file persistence plus two query styles (Mongo-like dicts or a Pythonic Q builder) makes everyday prototyping painless. The built-in Studio UI and auto-index hints are thoughtful extras for inspecting data and nudging performance, though this competes with established tiny DBs and SQLite/JSON patterns — great for side projects, but check concurrency and durability needs first.
JSON model storage beats Simulink's proprietary lock-in for Git workflows.
Single-file mmap storage plus an HNSW vector index and explicit graph edges is an elegant, practical combo — think "SQLite for agent memory" with CRC-32 crash recovery and zero-server convenience. The C++20 core + nanobind gives zero-copy NumPy views and GIL-free searches, and the claimed FAISS-like throughput makes this genuinely interesting for local setups; main caveat is build/toolchain friction and how rich the surrounding ecosystem becomes.