Ben Johnson, the creator of BoltDB, introduces Litestream, an open-source project that aims to make SQLite suitable for full-stack applications through replication. Johnson explains that the conventional wisdom was to use SQLite for unit tests in n-tier architecture, but he argues that SQLite can serve as the core of data and persistence layer in production applications. He discusses the evolution of database architectures and the limitations and advantages of SQLite. Johnson then introduces Litestream’s functionality, including replication and concurrency features. He emphasizes the simplicity and performance benefits of using SQLite and concludes by highlighting upcoming improvements to Litestream.
https://fly.io/blog/all-in-on-sqlite-litestream/