I found two SQLite related articles in my Pocket list, which I wanted to share.

The first one is an article by Michael Lynch about Litestream, a tool that automatically replicates SQLite databases every few seconds to a remote storage. This allows one to worry less about backups or use SQLite instead of server-based database. I thought about ways I could use Litestream: Maybe to automatically replicate my blog database to a S3 bucket at Scaleway? In addition to the already existing daily backups?

The second article is from GitHub user phiresky who found a clever way to execute SQLite queries in the browser on huge databases hosted on GitHub pages without transferring the huge databases first. It’s interesting what’s possible with JavaScript, WebAssembly and HTTP.

SQLite is awesome!