Issue #1 - 9/16/2022

Welcome to the inaugural issue of Sqlite News, a curated newsletter on all things SQLite. The Sqlite community is growing fast and it's about time we had a newsletter highlighting some of the cool things our community is doing.

---

How SQLite Scales Read Concurrency - "If you scour Hacker News & Reddit for advice about databases, some common words of caution are that SQLite doesn't scale or that it is a single-user database and it's not appropriate for your web-scale application...Like any folklore, it has some historical truth. But it's also so wildly out-of-date." Fly.io

Conflict-free-sqlite - This project implements conflict-free replicated data types and conflict-free replicated relations in SQLite, allowing databases that share a common schema to merge their state. Merges can happen between an arbitrary number of peers and all peers will eventually converge to the same state. This project is young but could offer an amazing extension to the millions of applications that use SQlite. Matt Tantaman

SQLite has pretty limited built in functions - a library to augment SQLite with more functions. written in Golang. Phil Eaton

Mojo - MojoFS is a versioning, userspace filesystem for sqlite DB. It is tailor made for sqlite and not supposed to be used as a general purpose fs. The main feature of the fs is versioning/snapshotting. Only one version is writable and all the old versions are immutable. Sudeep Jathar

SQLite: Past, Present, and Future - "In this paper, we discuss SQLite in the context of this changing workload landscape. We describe how SQLite evolved from its humble beginnings to the full-featured database engine it is today. We evaluate the performance of modern SQLite on three benchmarks, each representing a different flavor of in-process data management, including transactional, analytical, and blob processing" Richard Hipp

Building data-centric apps with a reactive relational database - "It feels like application development should mostly about modeling the domain and writing the right queries to present things to the user, but in reality, it's much much harder... What if you could build iTunes as just a pile of well chosen queries" Nicholas Schiefer

Drift - Drift is a reactive persistence library for Flutter and Dart, built on top of sqlite. Simon Binder

Memos - An open source, self-hosted knowledge base that works with a SQLite db file. @stevenlgtm

Sqlean - The ultimate set of SQLite extensions. Anton Zhiyanov

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