I love SQLite for many reasons. LiteFS promised background fs based replication for SQLite databases on the server, providing local access times and eventual consistency. While it has worked well for us on
fly.io, I can no longer recommend it and will unfortunately move away from it. Why? Read on...