Backup and restore database across web and mobile

[anthonychwong]

How to import sqlite file from mobile to web, and vice versa?

I did some searching, while sql.js can create db from binaries, but moor don't have constructor to create DB from this format.

[simolus3]

You could use a LazyDatabase to check if data is available and create it if it isn't:

LazyDatabase(() async {
  MoorWebStorage newStorage() => MoorWebStorage('your-database-name');

  final storage = newStorage();
  await storage.open();
  if (await storage.restore() == null) {
    await storage.store(your_database_bytes);
  }
  await storage.close();

  return WebDatabase.withStorage(newStorage());
});