powersync-ja / powersync.dart

SDK that enables local-first and real-time reactive apps with embedded SQLite for Flutter/Dart clients
https://www.powersync.com
133 stars 18 forks source link

IndexedDB flushing #208

Closed rkistner closed 1 week ago

rkistner commented 1 week ago

An update in sqlite_async will automatically flush each write. This gives some durability guarantees, but significantly slows down initial sync of 100k rows.

This change configures bucket storage to selectively disable flushing in cases where durability is not important. This only has an effect for Flutter Web, and only when IndexedDB storage is used.

Despite this change, OPFS storage is still much better. This just makes IndexedDB storage a little less bad.