CRDTs for Mortals
by james-long
You don't need a PhD to use CRDTs — a Last-Write-Wins Map plus a Grow-Only Set on top of SQLite gives you production-grade sync in 630 lines of JavaScript.
sqlite
(9)SQLite Persistence on the Web
by conrad-hofmeyr
SQLite in the browser is already production-ready if you pick the right VFS — OPFS with synchronous access handles solved the persistence and sync/async impedance mismatch that held it back for years.
I Built a Context7 Local-First Alternative With Claude Code
by moshe-simantov
Documentation indexing for AI agents belongs on the local machine: pre-built SQLite databases eliminate rate limits, cut query latency to sub-10ms, and keep proprietary code queries completely private.
Unleashing the Power of Sync
by dev-agrawal
Sync engines collapse distributed state management into straightforward SQL by maintaining local databases that sync bidirectionally, and this architecture extends naturally to AI agents that read and write directly to the database.
Native-Grade Web Apps with Local-First Data
by johannes-schickling
Web apps can rival native quality by replacing server-centric data architecture with client-side SQLite and automatic sync engines, eliminating loading states and enabling instant responsiveness
LiveStore
by johannes-schickling
A client-centric state management framework combining reactive SQLite with event sourcing and built-in sync, designed for high-performance local-first applications
Using Drizzle with Durable Objects
by nicholas-griffin
Drizzle ORM now supports Cloudflare Durable Objects with SQLite, replacing buggy custom migration code with a clean, automated schema management workflow.
Basic Likes Feature with LiveStore
by bohdan-ptyts
LiveStore's event sourcing model makes implementing persistent, synced features trivial—define an event, a materializer, and a reactive query, and the framework handles offline support and cross-device sync automatically.
The why and how of building a local-first music app
by johannes-schickling
Building a native-quality music app in the browser requires treating the web as a game engine problem — custom schedulers, canvas rendering, and event-sourced SQLite replace the standard toolkit when you refuse to accept spinners.