Instead of "just use Litestream," I'd like to see a review of different object stores one could use and which ones work well with Litestream. Is there a nice object store I could run in another Linux VM? As a hobbyist, which services providing an S3-like API make the most sense?

Back in the day, I wrote a simple job queue with SQLite

https://github.com/guilt/squeue

It did the job, was fairly easy to use.

SQLite is an underrated tool for how powerful it really is and probably people don't think of it often enough.

The GitHub statistics for the project this website represents are insane. It has a sole author that has averaged approximately 20,000 lines of code every week in the past month. How do you even maintain that alone?

Related piece I wrote some time ago: https://www.morling.dev/blog/building-durable-execution-engi...

For something so widely deployed you’d think it’d be included in Claude/Codex/etc for

All this SQLite hate from big vector db... leave SQLite alone!

Cloudflare durable object is implemented with SQLite (or some variant of it)

Surprised no one has mentioned Turbopuffer yet [1] which natively supports dense vector similarity and BM25 keyword indexes out of the box

[1]. https://turbopuffer.com/

Good framing. SQLite is often enough when the main problem is making workflow state durable, inspectable and easy to recover.