2025.09.18

📰 News & Discussions

Speeding up PowerSync with a SQLite extension written in Rust

"We’re already using a custom SQLite extension written in Rust to define a few virtual tables and SQL helper functions, so our idea was to expand that extension to include a client state machine for the PowerSync protocol. The extension would be responsible for reacting to data received from the network and writing changes to the database, while SDKs open the HTTP stream and forward data into the client."

p2p lecture series

"bi-weekly-ish, in-person lecture series about radical peer-to-peer, local-first, convergent data-types and networking"

Johannes Schickling @ ViteConf 2025

"I'm very excited to announce that I'll be speaking at @viteconf.org about building native-grade web apps with local-first data. I'll share lessons learned and what it takes to build high-performance web apps from working on Overtone over the past 4 years." 9-10 October in Amsterdam.

🛠️ Tools & Resources

"Today we are releasing SQLiteData 1.0, an alternative to SwiftData that provides familiar tool to build apps with complex persistence and query needs, with none of the gotchas, based on SQLite"

Stop Wasting Time With REST – Build Real-Time Apps with SQL Over WebSockets!

"Let's be honest – REST APIs are starting to feel like fax machines in the age of WhatsApp. We're building rich, collaborative, real-time interfaces, yet still fetching data like it's 1999. It's time to rethink how we design data-driven applications."

IPFS PMTiles Demo

"This demo showcases how to distribute and serve static maps over IPFS using PMTiles format, providing a decentralized approach to map hosting."

✨ Apps

Tetrify

"tetrify is by default completely local-first, on-device and we have no access to your messaging data. End to end encrypted sync is in beta!"

Show HN: Unheard.fm – No-repeat, user-controlled music discovery for Spotify

"Local-first: Known tracks are cached on your device; no listening history is stored server-side."

Still unhappy with the state of knowledge bases

"What I'd like to see is: 1. Local-First. Not being able to jot down something whilst offline or even read notes is terrible. 2. Sync + Collab. I want to be able to have collaborative notes and access them on multiple devices. 3. At least one of: Self-Hosting possible or E2E encrypted. I want to have agency over my data."

How to Contribute

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