Issue #16 - 1/13/2023

Got something for the newsletter? Please share it!

---

SQLite Wasm in the browser backed by the Origin Private File System - Use SQLite to handle all your storage needs performantly on the web. Chrome

I Migrated from a Postgres Cluster to Distributed SQLite with LiteFS - "Only time will tell whether this was a good idea or not. I'm pretty confident that it will be. Just moving from three services to one is quite nice. Local development is simpler thanks to just using SQLite as well." Kent C. Dodds

Sqld - LibSQL, a fork of SQLite, "glued" together SQLite to the PostgreSQL wire protocol thus creating a server mode. libSQL

Building a location to time zone API with SpatiaLite - "This tutorial will show how SpatiaLite and Datasette can be combined to create a JSON API that can return the time zone for a specific latitude and longitude point on earth." Simon Willison

WAL Mode in LiteFS - LiteFS now supports WAL mode! Fly

Sponsored by Mycelial, maker of local-first software tools.
Sponsor