2026.09.17

đź“° News & Discussions

Substract: ideas for a personal, local-first database

"I’m currently brainstorming/prototyping 'Substract', a triple store CRDT to build personal, local-first software. The ideas here aren’t particularly original; this is just my own re-packaging of things I’ve been interested in for a while. This blogpost gives an overview of how Substract works, or rather, how it will work. The project is only partly implemented, and subject to change. Feedback is very much welcome!"

Serverpod 4: Full-stack hot reload, agentic coding, offline sync, and more

"Serverpod has always provided a type-safe ORM for working with Postgres on the backend. Serverpod 4 brings that experience to the client with SQLite support. Your Flutter application can use the same Serverpod models and the same type-safe approach to working with data locally. But SQLite support is only the beginning. For the past eighteen months, we have been working on one of the most technically challenging features we have ever built: Full offline sync."

🛠️ Tools & Resources

"[A] local-first, embedded capture library I built in Python (code is heavily AI generated but designed and reviewed by yours truly). I've been using this for point-and-shoot WebSocket capture but I imagine it could also be useful for observability/metrics ingestion as well. Litelink supports a single writer per stream. I've been doing a lot of development and deployments on tiny VMs (2 vCPU, 8GB, 50-100GB disk) and didn't want the complexity or cost of managing central brokers (Kafka), databases (Postgres), and CDC/connectors just to get queryable WebSocket stream capture running."

Cbox Sync for Laravel

"Offline-first sync for Laravel applications: one authoritative server, many replicas, field-level conflicts that are preserved rather than silently overwritten."

✨ Apps

Avendo

"Client, job, payment and booking organizer for freelancers and small service businesses. The free tier runs entirely on-device — no account, no network, local storage — with cloud sync, web access and a booking page as a paid upgrade. Desktop builds for Linux (.deb/.AppImage, amd64 and arm64), macOS and Windows, plus iOS, Android and web."

VisiGrid

"A native, keyboard-first spreadsheet built like a code editor, with a command palette, Vim mode, Lua automation, and a CLI for calculating, converting, and diffing spreadsheet data in scripts and CI. Files stay on-device with no account, cloud, or telemetry."

Valv Desktop

"Database client built for agent queries. Point the coding agent you already run (Claude Code, Codex, Cursor, opencode) at your database and Valv adds access control, citations so you can verify results, codemode for complex queries, HTML dashboards, and git-based workspaces to share it all with your team."

Monday Morning

"Monday Morning condenses your team’s scattered ideas into a ranked, verified plan — briefs, specs, parallel builds, and every claim checked against what actually landed." "Stay local-first. Every spec, task, and decision is plain markdown in your repo — versioned, diff-friendly, no database."

How to Contribute

Anyone can contribute to Local-First News with a pull request. Instructions and guidelines available here.

Sponsors

Local-First News is sponsored by PowerSync. Interested in sponsoring? Get in touch