#Local-First

18 articles tagged with Local-First

SQLite WASM (OPFS): How to Install, Set Up, and Use a Persistent Browser Database

Complete guide to SQLite WASM with OPFS persistence — how to install SQLite WASM (OPFS), set up a persistent SQLite database, and integrate with Yjs for sync.

8/6/202624 min read

Building a Local-First Note-Taking App: Sync Without a Server

The Local-First software architecture guide. How to build a serverless note-taking app using IndexedDB (RxDB / ElectricSQL), WebRTC P2P mesh sync, and Yjs CRDTs.

8/1/202625 min read

The Local-First Paradigm: Core Architectural Principles

Take back control of user data. Learn the core architectural pillars of local-first development and offline-first state synchronization.

7/13/202613 min read

Git-Style Version Control for Local-First Documents using Loro CRDT

Learn how to build collaborative version control systems. Implement Git-style branch, checkout, commit, and diff operations inside Loro CRDT database models.

7/10/202614 min read

Why Loro CRDT is Redefining High-Performance Local-First Sync

Conflict-free Replicated Data Types (CRDTs) are notoriously memory-hungry. Learn how Loro, built in Rust, optimizes client-side state sync for real-time multiplayer apps.

7/10/202611 min read

Securing Collaborative States: Peer Identity Verification in Loro CRDT

Prevent malicious state injections in local-first apps. Learn how to implement public-key signing and verification for Loro CRDT update blobs.

7/10/202613 min read

Implementing Multi-User Undo/Redo State Tracking with Loro CRDT

Learn how to build collaborative undo/redo state engines. Implement isolation, group edits, and state history trackers using Loro CRDT.

7/10/202613 min read

RAG Optimization: Implementing Local Embedding Cache Layers

Speed up Retrieval-Augmented Generation (RAG). Learn how to implement an IndexedDB-based embedding cache to eliminate redundant network API calls.

7/10/202612 min read

Electric SQL & Loro CRDT: The State of Local-First Web Architectures (2026)

Local-first apps bring sub-millisecond latencies and offline capabilities to users. Discover how to build sync pipelines with Electric SQL and high-performance Loro CRDTs.

6/17/202610 min read

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.

6/4/202612 min read

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.

6/4/202612 min read

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.

6/1/202612 min read