2025.01.09
đź“° News & Discussions
Local-first client database migrations
"Local database migrations is a required feature for all local-first apps. This example shows a strategy on how with Pglite using Drizzle and Effect." By @SandroMaglione
Back to Basics: Why We Chose Long Polling Over WebSockets
"Like many teams building real-time systems with Node.js and TypeScript, we've been exploring ways to handle real-time updates at scale. Our system handles hundreds of worker nodes constantly polling our PostgreSQL-backed control plane for new jobs (tool calls issued by agents), while agents themselves continuously pull for execution and chat state updates. What started as an exploration into WebSockets led us to a surprisingly effective "old-school" solution: HTTP long polling with Postgres." See also HN discussion.
Rewriting PrayerMate Sync With PowerSync
"When I first went full-time on PrayerMate back in 2016, one of the very first major projects I tackled was to implement data syncing between devices. I hated every minute of it, and whilst the implementation mostly worked in most situations, there was a frustrating number of edge cases where it failed fairly spectacularly in unpredictable ways."
DWeb Local First Weekend (upcoming event)
"Join us for a weekend of exploring the emerging technologies and principles of this new kind of software. We'll learn about the broader DWeb movement, local-first technologies we can use right now and hack on some projects." Scheduled for Saturday, January 11th at 12pm PT.
Why SQLite is Perfect for the Web | Modern Web (podcast episode)
"Dive deep into the fascinating world of SQLite and Turso with Gláuber Costa, the founder and CEO of Turso, as he shares insights into the evolution of modern database technologies. Hosted by Danny Thompson and Adam Rakus on the Modern Web Podcast, this episode unpacks SQLite's growing popularity, Turso's innovative managed database services, and how local-first architectures are changing the database landscape."
Batteries Included: The Local-First Approach to Data Visualization
"The local-first approach flips the traditional BI paradigm on its head. By leveraging the processing power of users’ local devices—such as laptops or phones —this method offers nearly zero marginal cost for scaling analytics to millions of users."
🛠️ Tools & Resources
postgres-sqlite: In-memory SQLite as a Postgres data type
"postgres-sqlite is a PostgreSQL extension that introduces SQLite databases as a first-class data type within PostgreSQL." "[a] powerful use case is pairing postgres-sqlite with the official SQLite Wasm (WebAssembly) build to synchronize client-side and server-side data"
Dolphin 3.0 Released (Llama 3.1 + 3.2 + Qwen 2.5): A Local-First, Steerable AI Model
"Local-First Architecture: Prioritizing on-device computation, Dolphin 3.0 reduces dependency on cloud services. This not only improves latency but also ensures data remains private and secure."
DataBridge — Multi-modal modular data ingestion and retrieval
"[The] local-first approach ensures better privacy, security, and flexibility, especially for teams dealing with sensitive data." - Adityav369 on HN
Phi Silica, small but mighty on-device SLM
"Today we will share how the Applied Sciences team used a multi-interdisciplinary approach to achieve a breakthrough in power efficiency, inference speed and memory efficiency for a state-of-the-art small language model (SLM), Phi Silica."
✨ Apps
dict-to-flashcard: Local-first spaced repetition with macOS Dictionary and Logseq
"A tiny Alfred workflow that gets the word definition from macOS dictionary (with extra steps), converts it to Logseq flashcard. Allows to practice words met while reading, on the phone too, offline too."
Octoclip — Copy Here, Paste Anywhere
"Local First... Prioritize local storage to protect your privacy and data security."
Arboretum — AI powered note-taking and knowledge management
"A local-first PKMS which automatically builds connections between your notes" - u/GarettWithOneR
Digital Notes — All your ideas in one place
"Everything’s local-first and exportable in open formats like Markdown, PDF, or HTML." - Flavio Carvalho on Product Hunt
Notate — Your Intelligent, Private AI Research Companion
"I built Notate, a desktop research assistant that combines AI-driven analysis with vector search technology [...] Key features: Local-first architecture with Ollama support for complete privacy"
How to Contribute
Anyone can contribute to Local-First News with a pull request. Instructions and guidelines available here.