Articles
Notes techniques, retours d'expérience, publications.
- Why We Wrote a C SQLite Driver and Got 4.7× Faster
## The problem with modernc modernc.org/sqlite is a pure-Go translation of the SQLite C source. No CGO, no linker headaches, `go build` just works. For two years it carried every HOROS service in pro...
- Why I Quit Postgres for SQLite — and Stopped Caching Anything
## The switch Six months into building HOROS, I was running PostgreSQL. Sessions, permissions, user data, job queues — everything went through a networked database. It worked. It also meant every p...
- Three Distributed Patterns From One SQLite Primitive
## The primitive squeueHA is a visibility timeout queue backed by SQLite. A job is published with a payload. A worker claims it — the job becomes invisible to other workers for a configurable durat...