Cross-platform implementation to delete the database entirely?

[johannesstricker]

During dev I sometimes encounter a corrupted database. That's likely related to hot-reloads or exceptions, but since I can't be entirely sure that this doesn't happen in production, I want a way for the user to manually reset the database.

I'm getting this error as soon as I start a transaction or query on the database:

Invalid argument(s): Invalid typed array length: -147456

At the moment I'm only supporting web, but there will be iOS in the future. I already found this discussion #2821, which looks helpful, but (1) is only for web and (2) only for wasm. For me, drift is currently using IndexedDB and outputs this warning:

Using WasmStorageImplementation.sharedIndexedDb due to missing browser features: {MissingBrowserFeature.dedicatedWorkersInSharedWorkers, MissingBrowserFeature.sharedArrayBuffers}

To reset IndexedDB I could use package:web I guess. So I think I might be able to build a solution that works on wasm and IndexedDB. Does that solve all cases for web or is there another possible storage engine?

Then what about the other platforms?

This is how I open the connection

    final connection = driftDatabase(
      name: name,
      native: const DriftNativeOptions(),
      web: DriftWebOptions(
        sqlite3Wasm: Uri.parse('sqlite3.wasm'),
        driftWorker: Uri.parse('drift_worker.dart.js'),
      ),
    );

Since I don't explicitly pass a file argument, I don't know where the sqlite database is located. I think it would be really great if drift would support purging the database out of the box.

[simolus3]

Does that solve all cases for web or is there another possible storage engine?

So just to be clear, wasm here refers to the fact that SQLite is compiled to a WebAssembly bundle. So the snippet from the linked discussion should work correctly (using WasmDatabase.probe + deleteDatabase actually works for all storage modes drift can use on the web, with your setup you'd get OPFS on Firefox and IndexedDB on other browsers).

I'm trying to keep the api in drift_flutter somewhat minimal, but I agree that a cross-platform way to delete databases might be helpful. I'll take a look!

[johannesstricker]

Thank you for clearing that up!

Yeah, would really appreciate the cross-platform way.