Post

The new OPFSWriteAheadVFS for wa-sqlite not only brings concurrent reads to SQLite on the web, but also makes write transactions faster!

It does this by not insisting every commit hit the disk immediately. Instead of updating the main database file right away, it writes changes into side log files first. That is cheaper, so small write transactions finish much faster.

Key idea: keep the database correct even if newest writes are not fully durable yet.

Why the speedup is big: forcing storage flush on every tiny write is expensive. That flush is often the slowest part of the commit. By skipping it on a hot path, the VFS removes a lot of overhead, which especially helps with workloads with many small transactions.

So the tradeoff is simple: faster writes now, weaker crash protection for newest data. This is often fine for local-first apps where recent changes can be retried, re-synced, or recreated from server state.

If the app needs stronger guarantees, it can turn durability back up with PRAGMA synchronous=FULL or EXTRA. Then the VFS flushes more aggressively so recent commits are much more likely to survive crashes, but write performance drops.