Building circle-db — Phase 1: Core Data Model (EAV)
Most databases you’ve used store data in rows. A users table has columns — id, name, email — and each row is one user. It feels natural because it mirrors...
← Back to All Series
Building circle-db from Scratch
A 9-phase series building circle-db — a Datomic-inspired EAV database in Python and Clojure — from scratch. Covers the core data model, in-memory storage, four indexes (EAVT, AVET, VEAT, VAET), the CRUD write path, transactions, query planning, query execution, and time-travel with graph traversal.
-
1
-
2
Building circle-db — Phase 2: In-Memory Storage
The Shelf and the Card Catalog
-
3
Building circle-db — Phase 3: EAVT Index
The Phone Book Problem
-
4
Building circle-db — Phase 4: Full 4-Index System
The Same Books, Sorted Four Ways
-
5
Building circle-db — Phase 5: CRUD Write Path
A History Book That Can Never Be Erased
-
6
Building circle-db — Phase 6: Transactions & Layered History
Atomic Writes, Layered History
-
7
Building circle-db — Phase 7: Query Planning
Choosing the Right Card Catalog
-
8
Building circle-db — Phase 8: Query Execution
What Does a Query Look Like?
-
9
Building circle-db — Phase 9: Time-travel + Graph Traversal
Two Capabilities, Zero New Data Structures