Jan-Lukas Else

Thoughts of an IT expert

Two articles about awesome SQLite projects

Published on in 🔗 Links
Short link: https://b.jlel.se/s/43a
⚠️ This entry is already over one year old. It may no longer be up to date. Opinions may have changed.

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!


Jan-Lukas Else
Interactions & Comments