Issue #6 - 10/21/2022

Got something for the newsletter? Please share it!

---

Investigating SQLite replication - Kent C. Dodds livestreams his investigation into SQLite replication with LiteFS. Kent C. Dodds

"SQLite not open enough and needs modernization..." - "A new fork of SQLite, called libSQL, aims to modernize this massively popular embedded database, with its founder complaining that SQLite is explicitly and unequivocally 'Open Source, not Open Contribution.'" Tim Anderson

SQLite-utils - Python CLI utility and library for manipulating SQLite databases. Simon Willison

Virtual tables with zig-sqlite - "My goals for this feature were: providing a nice Zig API to implement a virtual table and allow building a virtual table as a loadable extension" Vincent Rischmann

Postgres Full Text Search vs the rest - Compares Postgres FTS to other solutions, including SQLite. Supabase

Verneuil - Verneuil is a VFS extension for SQLite that asynchronously replicates databases to S3-compatible blob stores. Backtrace

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