#Local-First

Building a Local RAG Pipeline inside the Browser with SQLite-VSS and WebGPU

Learn how to build a fully client-side Retrieval-Augmented Generation (RAG) pipeline. Query documents locally using SQLite-VSS vector search and WebGPU-accelerated LLMs.

Offline-First Synchronization: Syncing Loro CRDTs over WebRTC DataChannels

Build a fully decentralized real-time collaborative document editor. Learn how to synchronize Loro CRDT updates peer-to-peer using WebRTC DataChannels.

Building a Local-First Collaborative Spreadsheet with Yjs, SQLite, and WebSockets

Learn how to architect a local-first collaborative spreadsheet app. Master CRDTs using Yjs, browser-local SQLite persistence, and WebSockets synchronization.

The Distributed State Renaissance: P2P Sync as Default in 2026

Centralized state is a bottleneck. Discover how CRDTs and P2P synchronization have become the default state management model for the web of 2026.

Local-First Real-time Sync: The New Standard for Web Apps in 2026

Waiting for the server is so 2024. Explore the rise of local-first architectures and why instant, offline-capable sync is the baseline in 2026.

Zero-Trust Local: Securing the Client-Side in 2026

The firewall is dead. Discover the zero-trust local model where the security boundary is the individual browser sandbox and the cryptographically-signed local store in 2026.

Local-First: The New Standard for Web Apps in 2026

Offline-capable is no longer enough. Learn how local-first architecture is eliminating loading states and making the web feel as fast as desktop software.

Edge-Native & Local-First Databases: Embedded SQLite-Wasm, LibSQL, CRDTs & ElectricSQL (2026)

High-Performance CRDTs with Loro in 2026: The Rust + Wasm Revolution in Local-First Collaboration