SQLite, Local-First & CRDTs: Live GitHub Trending & Developer Pulse
Live stream of SQLite innovations, in-browser WASM databases, and conflict-free replicated data types (CRDTs).
Top Trending SQLite, Local-First & CRDTs Repositories on GitHub
Updated hourlyPersonal and organic AI agent framework with autonomous execution and self-healing terminal tools.
High-performance vector and relational engine compiled to WebAssembly with zero network overhead.
Production primitives for React 19 Actions, optimistic mutations, and Server Components in Next.js.
Ultra-low latency HTTP/3 and gRPC gateway engine built for zero-trust microservice meshes.
Hybrid dense & sparse embedding retrieval engine with reranking and context compression.
Client-side quantum gate simulator and Bloch sphere visualizer built with WebGL shaders.
Hacker News Engineering Discussions on #sqlite
Hosting SQLite databases on GitHub Pages or any static file hoster
I'm all-in on server-side SQLite
Tracking down the 16-year-old WAL-reset SQLite bug
SQLite is not a toy database
How SQL Database Engines Work, by the Creator of SQLite (2008) [video]
DuckDB – An embeddable SQL database like SQLite, but supports Postgres features
Community Articles & Tutorials (SQLite, Local-First & CRDTs)
PostgreSQL 19's REPACK CONCURRENTLY swaps a five-second table lock for one under a second
I bloated a Postgres 19 beta table, then rewrote it with VACUUM FULL and with the new REPACK CONCURRENTLY: 4.3-5.9s of blocked client time against 0.3-0.9s, and a documented replication-slot limit I managed to actually hit.
MongoDB 8.3's arrayIndexAs cuts a map-with-index workaround's overhead by up to 31%
I benchmarked MongoDB 8.3's new arrayIndexAs against the range-and-arrayElemAt workaround it replaces: 134ms versus 102ms server-side at 320,000 elements, a gap that shrinks to about 5% once ten clients compete for the same CPU cores.
DuckDB 2.0 alpha's triggers cost three times more per row than per statement
I benchmarked DuckDB 2.0 alpha's new triggers on a 500,000-row insert: row-level triggers cost about 3x a plain insert, statement-level ones with transition tables cost about 1.3x. Half the documented trigger matrix isn't implemented yet.
Changing one field in a 100KB document, in Postgres and in MongoDB
The usual argument for keeping documents in Postgres is that jsonb gives you most of MongoDB without...
Introducing SurrealMX: SurrealDB’s new in-memory storage engine
Author: Tobie Morgan Hitchcock Today, we are introducing SurrealMX 1.0, our new high-performance...
We are replacing RocksDB with SurrealKV 1.0
Author: Tobie Morgan Hitchcock SurrealKV 1.0 is a new open source persistent storage engine for...
Explore More Live Developer Trend Radars
Frequently Asked Questions
How often is the SQLite, Local-First & CRDTs trend radar updated?
Castov updates the SQLite, Local-First & CRDTs radar every hour using Incremental Static Regeneration (ISR), aggregating active GitHub repositories, Hacker News discussions, and Dev.to engineering articles.
How are the top SQLite, Local-First & CRDTs GitHub repositories ranked?
Repositories matching sqlite OR local-first OR crdt are filtered for recent commit activity and ranked by community star velocity and fork count.
What developer tool on Castov pairs best with SQLite, Local-First & CRDTs?
We recommend using SQL Query Formatter (/sql-formatter) alongside our 100% client-side developer utilities.