In this post, Ben describes why SQLite is a good choice for most applications, and how Litestream solves the problem of resilience to storage failures. Litestream will soon have support for read replicas.
This is another indication that architectures are moving toward “local first,” where the data lives at the location the app is running and is replicated wherever it is needed. Simple IoT will likely soon be moving to SQLite. Exciting times!