Implementing a DCB-Compliant Event Store in SQLite
Dynamic Consistency Boundary doesn’t require specialized infrastructure. A four-column SQLite table is enough. The DCB specification defines the minimal feature set an Event Store must provide to support Dynamic Consistency Boundary. This article walks through how to implement it using SQLite, requirement by requirement. This approach relies on SQLite’s global file-level lock to guarantee consistency. It cannot be applied as-is with MariaDB, MySQL, or PostgreSQL. See the appendix for details. The READ Requirements Let’s go through each READ requirement from the spec and map it to a column. ...