2026.10.01

📰 News & Discussions

Design Engineering with Maggie Appleton (podcast episode)

Maggie Appleton discusses local-first as a philosophy for software development to empower 'barefoot developers' and protect user data sovereignty. She argues that because many people lack deep engineering foundations, they are at risk of losing their data if it is solely reliant on cloud databases.

Governed Crossing: draft AT Protocol lexicons for recording what leaves a local-first system

When data, or access to it, crosses from a person's own local-first system into shared infrastructure, Governed Crossing records it as a signed crossing record kept by that person: what was authorized to cross, by whom, when, and where it landed. The work grew out of a prototype that gates publishing from a Keyhive-protected Automerge document to Bluesky with intent and completion records (featured in This Month in Automerge, August).

DuckCon #7 – Building local-first analytics apps with SQLRooms (Ilya Boyandin)

Boyandin is currently developing a CLI tool, SQLRooms, which allows users to store both their data and application state in a single, portable DuckDB file. The project aims to provide a lightweight, local-first alternative for analytics workflows

🛠️ Tools & Resources

pgxsinkit

"Opinionated, Offline-first, RLS-aware sync between PostgreSQL/Supabase and Drizzle/pgwasm at the edge."

"Peer to peer and read-only. Bytes move only when someone reads them. No daemon, no FUSE, no account."

HOL Guard

"HOL Guard is a local-first runtime security layer for AI agents. Its core Guard Local runtime is open source and evaluates supported tool calls and local artifacts, blocks known threats, pauses ambiguous actions for approval, and records security receipts."

CodeCrab: AI Pull Request Reviewer

"CodeCrab is a native AI desktop app that learns your codebase. It combines your skills with specialized CodeCrab review skills, orchestrating your local CLIs to review PRs with zero code leaving your laptop."

✨ Apps

Paperweight V1

"Paperweight is a local-first, open-source desktop app that scans your inbox to map your digital footprint and helps you clean up old accounts, mailing lists and personal data." Paperweight has been featured before in Local-First News, but has now reached V1.

Socratus

"Socratus combines AI-powered retrieval, a visual knowledge graph, and built-in code execution, all running locally, with your data always under your control."

LettuceAI

"Privacy-first AI roleplay & BYOK (Bring Your Own Key) & roleplaying, companion and storytelling app with long-term memory, custom characters, and 20+ providers."

How to Contribute

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

📰 News & Discussions

🛠️ Tools & Resources

✨ Apps

How to Contribute

Sponsors