On-Device Vector Search: SQLite + AI Embeddings in Flutter Apps
Build private, offline-capable semantic search in Flutter using SQLite vector extensions and local embedding models — no cloud API required.
7/19/202614 min read
#SQLite
16 articles tagged with SQLite
sqlite3 WASM + OPFS: Native-Speed Persistent Browser Storage in 2026
Ditch IndexedDB for structured relational storage. Discover how to configure sqlite3 WebAssembly on the Origin Private File System (OPFS) for microsecond browser queries.
7/10/202616 min read
IndexedDB vs. OPFS: Write Throughput and Latency Performance Benchmarks
Analyze detailed database benchmarks comparing traditional IndexedDB with sqlite3 WASM mounted on the Origin Private File System (OPFS). Learn why OPFS is 25x faster.
7/10/202613 min read
Turso LibSQL Edge Replication: Structuring Offline-First Next.js Systems
Learn how to build edge-replicated databases using Turso and LibSQL. Master local SQLite synchronization, dynamic server reads, and Next.js connection caching.
7/10/202614 min read
Turso & SQLite: Real-time Database Sync at the Edge
Offline-first applications require robust database replication. Learn how to synchronize local SQLite client instances with Turso edge databases over web sockets.
6/24/20269 min read
sqlite3 WASM + OPFS: Browser Persistent Storage Guide (2026)
IndexedDB is notoriously slow for large datasets. Discover the official API guide to running sqlite3 WASM inside browsers at native speeds using the W3C Origin Private File System (OPFS).
6/19/20269 min read
Building Offline-First Mobile Apps: Hive, Drift, and Sync Strategies for Flutter
Your users don't always have internet. This guide covers the three offline-first architectures I've used in production — from simple Hive caching to full bidirectional Drift + server sync with conflict resolution.
6/16/202619 min read
Designing a Distributed Job Queue with SQLite and LiteFS at the Edge
Learn how to architect an offline-resilient, distributed background job queue using SQLite WAL mode concurrency and LiteFS transactional replication on Fly.io.
6/4/202612 min read
Architecting a Global SQLite Database Mesh with Turso and Cloudflare Workers: Replication, Latency, and Cache Consistency
Learn how to architect a globally replicated SQLite database mesh. Build low-latency database backends using Turso, Cloudflare Workers, and dynamic read-after-write session consistency.
6/4/202614 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
Synchronizing SQLite Databases Over WebRTC: Building a Fully Decentralized Sync Engine
Learn how to build a fully decentralized, peer-to-peer database synchronization engine using SQLite WebAssembly and WebRTC Data Channels.
6/1/202612 min read
SQLite on the Edge: Replicating Databases with LiteFS and Fly.io
A technical dive into distributed edge storage, exploring how LiteFS replicates SQLite databases across global Fly.io regions using FUSE and lease-based consensus.
5/31/202610 min read