Why I Built a Distributed SQLite on S3 (And Why You Might Care)

The author built a Python library called distributed-sqlite that enables multiple ephemeral compute instances (Lambda, App Runner) to concurrently read and write a SQLite database stored on S3, using optimistic concurrency with S3 object versioning and automatic conflict resolution. It targets append-heavy, low-to-medium write workloads where RDS is too expensive, though it is not a replacement for fully serializable distributed SQL.