2024.12.26

📰 News & Discussions

How bloom filters made SQLite 10x faster

"This is the fascinating story of how researchers used Bloom filters cleverly to make SQLite 10x faster for analytical queries." See also HN discussion.

Local-First Berlin #2 (video playlist of talks)

Video recordings of talks by James Arthur ("Local-first with your existing API"), Kevin Jahns ("CRDT performance trade-offs"), Bartosz Sypytkowski ("Yrs - what we've learned"), Vojtech Rinik ("Using SQLite with MobX in Reflect"), and Andrei Popa ("How we built practical local-first permissions").

Lab note #055 Rabbit holes leave project in shambles

"[A]ll this makes me think there's an underlying common model for reactivity/incrementality, real-time collaboration, and offline sync. I have to figure out what it would look like."

Why Local-First and Offline-First Software Is the Future

"Local-first and offline-first design offer a radical rethinking of software. Instead of treating the internet as a constant requirement, these principles prioritize autonomy, resilience, and privacy"

🛠️ Tools & Resources

Show HN: Rivet Actors – Durable Objects build with Rust, FoundationDB, Isolates

"One of the reasons we built Rivet Actors is because we tried to replace most of our Redis-based realtime infrastructure with Durable Objects." "The most common use cases are high contention & strong consistency workloads where using an OLTP database doesn't work well [...] For example – I'm a big proponent of local-first apps, but even those require a sync server. You can easily implement one in under 100 lines of code with actors."

Show HN: NoSQL, but it's SQLite

"SQLite-backed key-value store with JS-like object manipulation and automatic JSON serialization."

Build a Local-First Real-Time Shopping List App with Expo, TinyBase, Clerk & Cloudflare

"Learn how to build a local-first, real-time shopping list app using Expo, TinyBase, Clerk, and Cloudflare Durable Objects. Explore offline capabilities, real-time syncing, and cross-platform functionality."

✨ Apps

Nullboard: Kanban board in a single HTML file

"All data is stored locally, for now using localStorage. The data can be exported to- or imported from a plain text file in a simple JSON format." See also HN discussion.

Hoppscotch: Make Better APIs

"Local-first data storage. No tracking. No analytics. No ads."

Titan Workout Tracker

"Trying out a new pattern on @TitanGymApp involving @powersync_ for a feature" "It's an exciting time for local-first apps with platforms like @powersync_ @instant_db @triplit_dev @livestoredev etc"

How to Contribute

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