Here's my thought on Why I Built Litestream - Litestream
As applications scale to the edge, to put compute as close to the user as possible, database queries back to the master node get slower and slower. Enter sqlite replication, put the database wtih the application code and replicate from master.
This post was a thought by Waylon Walker see all my thoughts at https://waylonwalker.com/thoughts