SQLite is all you need for durable workflows

SQLite can serve as a sufficient foundation for durable workflows by storing workflow state locally without requiring a separate database service or operational overhead. The approach becomes portable through Litestream, which asynchronously backs up SQLite files to S3-compatible storage, making it particularly well-suited for bursty, experimental AI agent systems that benefit from self-contained state units. Postgres remains the better choice for systems requiring higher availability and shared scalability, but SQLite offers a simpler, cheaper default for many workflow systems that don't initially demand that level of infrastructure.