2026.03.12
đź“° News & Discussions
We are a year into rewriting SQLite. How is that going? | Turso
"[T]he important metrics for database scalability today are how much data you can store, and how fast your queries are. But AI is about to introduce a new one: how many databases you can provision and manage, and how fast you can do it."
Aliro 1.0 Is Local-First Done Right — But Your Existing Locks Probably Won't Get It
"Aliro is a new open standard from the Connectivity Standards Alliance (the same organization behind Matter) — but where Matter handles device control, Aliro handles credentials. It defines how a digital key stored in your phone's wallet talks to a smart lock — directly, locally, without a cloud server in the middle."
Local-first with Tanstack DB with Schalk Venter
"There have been various tools that help implement and manage a local-first architecture for a while now. However, with the recent beta release of TanStack DB (part of the extremely popular TanStack ecosystem), we might be on the cusp of local-first going mainstream. In this session, we will explore the principles behind local-first and how TanStack DB can be used to achieve these."
OpenClaw and the Architecture Nobody Noticed
"The value in OpenClaw was in the deployment topology: local compute, local data access, familiar interfaces. That's the part that generated 209,000 stars. Not the model. Not the 'agent' capability in the abstract. The fact that it worked here, on your machine, with your stuff."
A Love Letter to Grist
"I would not say that Grist has all of the local-first ideals nailed. I don’t think anyone does. I realised as I was using it that the data sovereignty piece is the one that I really care about though, and that is why I am all in on Grist at the moment. I would much rather have Grist with its long-now-proof sqlite storage than AFFiNE with its magical real time sync engine and no trust that I will be able to get my data out in 10 years time."
Mitigating Geopolitical Risks with Local-First Software and atproto (upcoming event)
Upcoming talk by Martin Kleppmann at QCon London. Tuesday March 17th at 09:00AM GMT. "In this keynote Martin Kleppmann will talk about two technological trends that he has helped kick off, and that both aim to enable easy provider switching for different domains: local-first software (for collaborative tools) and the atproto ecosystem around Bluesky (for social media)."
🛠️ Tools & Resources
Choosing a Sync Engine for Local-First in 2026
"The following is a first-hand account of how I chose a sync engine for nibfont."
Qwen3.5 - How to Run Locally Guide
"Run the new Qwen3.5 LLMs including Medium: Qwen3.5-35B-A3B, 27B, 122B-A10B, Small: Qwen3.5-0.8B, 2B, 4B, 9B and 397B-A17B on your local device!" See also HN discussion
Building a Real-Time Todo App with Jazz and Vue 3
"Build a real-time, offline-capable todo app with Jazz and Vue 3. Jazz replaces your entire backend with collaborative data structures called CoValues. Combined with community-jazz-vue, you get composables like useCoState that plug into Vue’s reactivity system. The app syncs across tabs and devices, supports drag-and-drop with fractional indexing, and generates shareable URLs."
Building an Agent-Friendly, Local-First Analytics Stack with MotherDuck and Rill
"Times are shifting rapidly toward CLI-first development. You know that's true when even email and calendar get their own Google CLIs. So why not have CLIs for your business metrics too? This is what Rill and MotherDuck provide, including excellent developer workflows with a local-and-CLI-first approach, focusing on a developer-friendly interface and empowering users. Both work great on local laptops but can easily scale to the cloud, backed by a serverless data warehouse.."
Nucleus
"Nucleus is the local-first security and identity layer for the Agentic Age. It gives AI agents a persistent brain that syncs Cursor, Claude, and Windsurf into one sovereign identity. No cloud required."
Rooms: local-first multi-agent orchestration framework
"Rooms is a robust, highly-configurable framework designed for testing, simulating, and orchestrating multiple AI agents in structured conversation spaces. Built with a local-first philosophy, it leverages LiteLLM to securely route requests to local models (like Ollama) or commercial APIs without data leakage."
✨ Apps
DenchClaw
"AI CRM, hosted locally on your Mac. Built on OpenClaw." See also Show HN
YouniqMail
"While other mail apps route your messages through their servers, YouniqMail keeps things private by connecting straight from your device to your email provider."
Open Drone Log
"Free, open-source drone flight log analyzer for DJI and Litchi. Analyze telemetry, replay 3D flights, track battery health with privacy-first local storage."
Ollie
"Install it. Own it. Your AI, your machine, your data. Connect local or cloud models to power your coding, writing, and design workflows—all without a subscription."
Voicebox
"Voicebox is a local-first voice cloning studio with DAW-like features for professional voice synthesis. Think of it as a local, free and open-source alternative to ElevenLabs — download models, clone voices, and generate speech entirely on your machine."
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