2025.07.24

📰 News & Discussions

Offline-first Architecture - How to survive without the internet? - Zixuan Liu & Ahlam Aatif

"During this presentation, we’ll share our insights from building a complex ticketing application based on offline-first architecture, discuss the challenges encountered along the way, and highlight some of the solutions we’ve discovered."

LoFi/28 community meetup (upcoming event)

LoFi/28 is scheduled for Tuesday July 29th at 8am PT, with talks by David Fahlander ("Why I Built Dexie"), Carl Sverre ("Replication three ways: logica, physical and Graft") and Jay Meistrich ("High performance local-first with Legend State").

Why I moved away from SQL | Theo - t3․gg

"Convex is one of those products I just kinda wrote off. At least until people I trusted started using them. I finally gave them a real shot, and now I'll never go back..."

🛠️ Tools & Resources

Show HN: Deeb – a lightweight embedded JSON database written in Rust

"I’ve been working on Deeb — a tiny embedded database that stores your data as JSON files and behaves like an ACID-ish transactional database. It’s written in Rust and designed for small apps, side projects, experiments, or dev tools where spinning up Postgres or Mongo is overkill."

Show HN: SQLite AI - Open-Source Extensions to Bring AI to SQLite, Everywhere

"We’re excited to share SQLite AI, an open-source project designed to turn SQLite into a powerful AI infrastructure layer for cross-platform, local-first applications."

BlockNote + Electric SQL: Real-time Collaborative Rich Text Editing

"This example showcases a multiplayer BlockNote rich text editor with YJS and Electric SQL. All collaborative data is synchronized through PostgreSQL, providing real-time editing with cursor awareness without requiring additional real-time infrastructure."

How to Contribute

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