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 hourlyThe 1st Collaborative AI Design Agent Workspace. Local-first and open source. Create prototypes, websites, apps, dashboards, presentations, images, and videos with your team and AI agents. Share work, exchange feedback, and iterate together in one workspace.
Persistent Context Across Sessions for Every Agent – Captures everything your agent does during sessions, compresses it with AI, and injects relevant context back into future sessions. Works with Claude Code, OpenClaw, Codex, Gemini, Hermes, Copilot, OpenCode + More
:house_with_garden: Open source home automation that puts local control and privacy first.
Open-source AI job search agent and job finder: scan job boards, score each job 1-5 against your CV before you apply, tailor an ATS-friendly resume and cover letter, get interview prep and a job application tracker. It helps you fill in each application; you press Submit. Runs locally in your AI coding CLI (Claude Code, Codex, OpenCode and more).
There can be more than Notion and Miro. AFFiNE(pronounced [ə‘fain]) is a next-gen knowledge base that brings planning, sorting and creating all together. Privacy first, open-source, customizable and ready to use.
VoiceStudio is the open-source, fully-local ElevenLabs alternative — voice cloning, voice design, video dubbing, dictation, transcription & audiobook creation in 646 languages.
Stop renting your intelligence. Own it with AnythingLLM. Everything you need for a powerful local-first agent experience
🔥 🔥 🔥 A Free & Self-hostable Airtable Alternative
A personal timeline for quick notes. Write short memos, find them later by search, tag, or date. Open source and self-hosted.
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.