resqlite Benchmark Dashboard

Fresh 3-repeat run — April 14, 2026 — Dart 3.11.0, macOS ARM64

resqlite

sqlite3 (raw FFI)

sqlite_async (PowerSync)

5.5x

faster selectBytes()
10K rows vs sqlite3

2.4x

faster single inserts
vs sqlite3

1.9x

faster select() maps
20K rows vs sqlite3

107K

point queries/sec
9.3 us/query

1. Scaling Curves

Select → Maps (wall time)

How wall time grows with row count. Lower is better.

Select → JSON Bytes (wall time)

C-side JSON serialization vs Dart jsonEncode. Lower is better.

Speedup Factor — Maps

How many times faster resqlite is at each row count.

Speedup Factor — Bytes

How many times faster resqlite is at each row count.

2. Main-Isolate Cost

Main-Isolate Time — Maps (10K rows)

Time spent on the main (UI) thread. sqlite3 blocks it entirely.

Main-Isolate Time — Bytes (10K rows)

resqlite: zero-copy Isolate.exit → 0.00 ms on main thread.

3. Schema Shapes (1000 rows)

Wall Time by Schema Shape

Performance across narrow, wide, text-heavy, numeric, and nullable schemas.

4. Write Performance

Single Inserts (100 sequential)

Individual INSERT statements, each with its own transaction.

Batch Inserts (wall time)

Batched writes at 100 / 1K / 10K rows.

Transaction Writes (inside tx)

executeBatch() vs execute()-loop inside a write transaction.

Transaction Reads

Reading rows inside an open write transaction.

5. Concurrent Reads & Parameterized Queries

Concurrent Reads (1K rows each)

Total wall time for N parallel queries. Lower is better.

Parameterized (100 queries × ~500 rows)

Reusing prepared statements with different bind values.

6. Streaming & Reactivity

Stream Lifecycle

Initial emission, invalidation latency, fan-out, and churn.

Comparison vs Previous Run

63 benchmarks compared. All within noise.

7. Full Results Table

Benchmark	resqlite	sqlite3	sqlite_async	resqlite speedup vs best competitor

All times are wall-clock medians in ms (lower is better) from repeat 3/3. Point query is queries/sec (higher is better). Comparison baseline: 2026-04-13. Dart 3.11.0 stable, macOS ARM64.