2024.12.19

📰 News & Discussions

Vancouver DWeb Local-First Weekend (upcoming event)

A weekend of talks, shared learning and coding on January 11th and 12th 2025 at Z-Space in Vancouver. We'll learn about the broader DWeb movement, local-first technologies we can use right now, and hack on some projects.

Encrypting Offline Storage for Local-First Apps

Lessons from building encrypted local offline storage into the Y-Sweet sync engine with IndexedDB and WebCrypto.

In search of a faster SQLite

"SQLite is already fast. But can we make it even faster? Researchers at the University of Helsinki and Cambridge began with this question and published a paper, 'Serverless Runtime / Database Co-Design With Asynchronous I/O'. They demonstrate up to a 100x reduction in tail latency. These are my notes on the paper. This is the foundational paper behind Limbo, the SQLite rewrite in Rust."

Leaf, ATProto and ActivityPub

"Powered by Willow, subspaces have replication built-in: you can synchronize your subspace to your local devices and even edit your data offline." "Devices can synchronize subspaces peer-to-peer, without needing servers, allowing you to build local-first workflows."

Hannes Muhleisen - DuckDB Deep Dive, The Challenges of Lakehouses, and More (podcast episode)

"[we] recorded a chat about all things DuckDB, the challenges of data lakehouses and open table formats, local-first tech, and much more. 🦆 🐥"

SQLite in Modern Web Production: Dreams Becoming Reality

"This is the first in a two-part series on using SQLite for web applications and machine learning. In this article, I dive into why SQLite is rapidly becoming a production-ready database for modern web apps. In the second article, I will discuss how to perform retrieval-augmented-generation using SQLite."

🛠️ Tools & Resources

Y-Sweet 0.7.0

Y-Sweet 0.7.0 (Yjs-based sync engine) is out, with client-side offline support.

Day Zero: Build Good Web Apps with the Zero Sync Engine

"Six months ago, we announced Zero – a new general-purpose sync engine for the web. Today, we’re making Zero available for the first time." See also HN discussion.

Skip - makes your backend reactive

"Skip is an open-source framework first developed at Meta that makes it easy for engineers to build reactive backend systems."

Surfer Protocol

"Surfer Protocol is an open-source framework that revolutionizes how you access and utilize your personal data. We provide the tools, documentation, and infrastructure needed to liberate your data from various platforms and build powerful applications with it."

Now we’re all Forked!

"TLDR; I’m launching a new Swift framework called Forked for working with shared data, both on a single device, and across many."

How to Contribute

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