Skip to content

How SQLite Started

Welcome to the inaugural newsletter for SQLite Fun.

Over the past year, I've spent much time appreciating SQLite. It has allowed me to build large applications on a small scale. I'm sharing the experience of what SQLite is capable of and what others are using it for.

Get ready for a diverse range of content in this newsletter, including stories, code, and projects that all revolve around SQLite.

Highlights

  • The Untold Story of SQLite - An insightful interview with Richard Hipp, the creator of SQLite. Discover what drives Richard to develop free software, the importance of rigorous testing, and how many devices actually run SQLite. ‐ Corecursive

  • Node.js Experimental Support - Node.js v22.5.0+ introduces native bindings to SQLite—no npm install required. This experimental feature is now on par with bun. ‐ Node.js

  • SQL for Fun and Profit - Watch this video for an introduction to recursive common table expressions, complete with a real-world example. ‐ Aaron Francis

  • Gotchas with SQLite in Production - An experience report detailing the pitfalls you should be aware of before deploying SQLite in production. Learn from the experiences of others. ‐ Anže's Blog

  • How We Sped Up Notion in the Browser with WASM SQLite - Notion, more than just a note-taking app, uses SQLite to cache data in the browser. This article explores different methods of data persistence, ensuring non-blocking performance, and the meaning behind "OPFS SyncAccessHandle Pool VFS because it didn’t have the requirement of cross-origin isolation." ‐ Notion

Code

  • sqlite-vec enables vector searching for all your embedding needs. It implements a subset of pgvector functionality. 3.3k ⭐️
  • Redka is Redis re-implemented with SQLite. This project started when Redis changed its license, showcasing the power of an SQL-backed key-value store. 3.3k ⭐️

The Liter Side

  • SQLite News aggregates HackerNews posts related to SQLite.
  • RQLite 8.27 now supports loading native SQLite extensions.
  • Just Use Postgres - A discussion on why Postgres should be your default database instead of other options, with a section dedicated to SQLite. 🤔