Building a Bitemporal Data System with SQLite and Clojure
By
adityaathalye
Front-window bakery material. Catches the eye, delivers the goods.
Summary
This technical article describes building a bitemporal data system using SQLite and Clojure, inspired by concepts from accounting, Datomic, XTDB, and other database systems. The author creates a simplified implementation of bitemporal databases to explore complex data management concepts while acknowledging it's an informal, potentially buggy solution. The piece serves as both a technical exploration and philosophical commentary on database design complexity.
Key quotes
· 3 pulledto make a sufficiently complicated data system containing an ad-hoc, informally-specified, bug-ridden, slow implementation of half of a bitemporal database
mash up SQLite with ideas stolen from Accountants, Clojure, Datomic, XTDB, Rama, and Local-first-ers
contemplating hopelessly complected objects like Current Databases isn't just for the Rich man
You might also wanna read
Rethinking Database Usage: When File-Based Storage Might Be Better Than Traditional Databases
The article challenges conventional wisdom about database usage, arguing that databases are essentially just files on disk and that for many
dbpro.app·1mo ago
Grafeo: High-Performance Graph Database Built in Rust with Multi-Language Support
Grafeo is a high-performance, embeddable graph database built in Rust that offers exceptional speed and efficiency. It claims to be the fast
grafeo.dev·2mo ago
vdb: A Header-Only C Library for Vector Database Operations
vdb is a lightweight, header-only C library for storing and searching high-dimensional vector embeddings. The library provides database mana
github.com·3mo ago
Litestream Adds Write Capabilities to Its Virtual File System
The article introduces Litestream Writable VFS, a new feature that adds write capabilities to Litestream's virtual file system. Previously,
fly.io·3mo ago
Turso: SQLite Rewritten in Rust for Modern Database Applications
The article discusses Turso, a database platform that uses SQLite rewritten in Rust, exploring its technical implementation, performance ben
kerkour.com·4mo ago
Ayder: A Durability-First Event Log System Verified for Crash Recovery
Ayder is a durability-first event log system designed to maintain data correctness under real-world failures including crashes, partitions,
github.com·4mo ago