When Two-Character Queries Silently Return Nothing: Measuring Japanese Search Indexes in an Expo App
SQLite FTS5's trigram tokenizer returns zero rows for Japanese queries shorter than three characters, without raising anything. I benchmarked linear scan, a bigram inverted index, and FTS5 over a 20,000-item catalog to find the real threshold.
Building Offline-First Apps with Rork — Practical Cache Strategies Using AsyncStorage and SQLite
A step-by-step guide to adding offline capabilities to Rork-generated apps, covering data persistence, background sync, and conflict resolution patterns that prevent user churn.
Local Data Persistence in Rork Apps — Choosing AsyncStorage, MMKV, and SQLite by Measurement
A measured comparison of local storage in Rork apps: AsyncStorage, MMKV, and SQLite. Covers a zero-downtime migration, MMKV pitfalls, and how transactions plus WAL make SQLite bulk inserts dozens of times faster — grounded in hands-on indie development.
Building Resilient Offline-First Apps with Rork Max — Local-First Databases, Sync Engines & Conflict Resolution
Master offline-first architecture with Rork Max. Learn local-first databases, CRDT sync engines, conflict resolution strategies, and production-ready patterns for building apps that work seamlessly online and offline.