Technical deep-dives into how resqlite works and why it's fast.
Every SQLite library in the Dart ecosystem has the same bottleneck: getting data from SQLite's C engine to your Dart code without blocking the UI. Over 40 experiments, we ended up building somethin...
Architectureresqlite is a high-performance SQLite library for Dart built on raw C FFI (Foreign Function Interface — how Dart calls native C code). It's designed around a single principle: **minimize main-isola...
Deep DiveReads are the most common database operation — and the place where most SQLite libraries waste the most time on your UI thread. This post explains how resqlite's read path works, from the API call ...
Deep DiveSQLite only allows one writer at a time — that's a fundamental constraint of the database engine. resqlite embraces this by routing all writes through a single dedicated background isolate, keeping...
Deep DiveMost database libraries give you a one-shot query: ask for data, get data, done. resqlite's `stream()` API turns any query into a live data source — it emits results immediately and then re-emits w...