How do I use a pre-populated sqlite db on flutter web with drift?

[ehtiqamar]

I've added support to open a pre-populate db on native side with drift using the code provided in the docs, but I don't see any way of doing it on web with drift? Is it supported yet? If yes, please let me know how

[simolus3]

Sure, you can use the initializeDatabase parameter on WasmDatabase.open to provide the database file as bytes. It's kind of documented with this example here although that is doing a lot more. But using the callback to load an asset should work fine.

[ehtiqamar]

Is the initializeDatabase method only called once i.e. when the web app is opened for the first time or is it opened everytime the web app is opened? Also where do I load the asset to on web? Don't have much knowledge on flutter web, so any sample code would be appreciated. The one give in the reference does not seem to work

[ehtiqamar]

I've used this code to load my existing db on web:

DatabaseConnection connect() {
  return DatabaseConnection.delayed(Future(() async {
    final db = await WasmDatabase.open(
      databaseName: 'sqlite',
      sqlite3Uri: Uri.parse('sqlite3.wasm'),
      driftWorkerUri: Uri.parse('drift_worker.js'),
      initializeDatabase: () async {
        logger.d("initializeDatabase: Initializing web db");

        Uint8List? oldDatabase;

        final blob = await rootBundle.load('assets/sqlite.db');
        final buffer = blob.buffer;
        oldDatabase =
            buffer.asUint8List(blob.offsetInBytes, blob.lengthInBytes);
        logger.d("Old Database: $oldDatabase");
        return oldDatabase;
      },
    );

    if (db.missingFeatures.isNotEmpty) {
      debugPrint('Using ${db.chosenImplementation} due to unsupported '
          'browser features: ${db.missingFeatures}');
    }

    return db.resolvedExecutor;
  }));
}

[simolus3]

Does that code not work? It looks correct to me.

Is the initializeDatabase method only called once i.e. when the web app is opened for the first time or is it opened everytime the web app is opened?

It will only be called the first time we try to open the database.

[ehtiqamar]

You mean the code that I mentioned above or the example that you've mentioned?

[ehtiqamar]

Yea, my code did work but I'm not really sure if it is the correct approach since I've directly loaded my db from assets without checking anything where as the code in example had some checks in place for db.

[simolus3]

It is correct, I'll update the website to include this as well.