Migration issues with Firefox

[bytepoets-jhe]

In think the migrations are not successful on Firefox.
I'm stuck on an empty page.

When I release a new version with a db change and migration, it does work for Chrome and Safari, but not for Firefox.
I created data first with the old version and everything worked after releasing the migration on Chrome and Safari.

On Firefox I have to delete my cache or delete the db in my index.html like this
const deleteDatabaseRequest = indexedDB.deleteDatabase('db.sqlite'); for the app to even load.

https://drift.simonbinder.eu/web/
With this check I can see, that Safari and Chrome are using opfsLocks, while Firefox uses opfsShared
Anyone experiencing this issue?

Flutter 3.10.0
drift 2.9.0
Firefox 123.0

[simolus3]

I have tried to reproduce this in 54e205a, but that seems to work on Firefox with all supported web implementations.

Are you using package:drift/web.dart or a WasmDatabase from the newer package:drift/wasm.dart? I'm surprised to see that deleting an IndexedDB database fixes this issue, since we should use the much faster OPFS-based file system on Firefox by default.