Get the latest tech news
Siren Call of SQLite on the Server
At Terrateam, we are big fans of Fly.io. The service is hosted there and it’s served us well. Just deploy your TOML file, get your infrastructure, do something else with the rest of your day. One of the interesting sides of Fly is that they invest heavily in server-side SQLite. They’ve written a number of blog posts on how they enable server-side SQLite: I’m All-In on Server-Side SQLite - Ben Johnson, the author of BoltDB, joins Fly to work on Litestream, a SQLite replication solution. Introducing LiteFS - The introduction of LiteFS, which is a FUSE file system designed to replicate SQLite transactions over the network. LiteFS Cloud: Distributed SQLite with Managed Backups - Introducing backups and restores for LiteFS.
There are lots of options for managing scale and failure in a boring app with a database server architecture. Interacting with a database library vs a server also has very different latency profiles, so you might have to refactor your queries to be more server-latency friendly. With Terrateam, we knew that we wanted the option to run it as a SaaS, requiring both high availability and scalability, so we chose a traditional architecture.
Or read this on Hacker News