Flutter - where to put own SQLite .db file?

Question

I have a SQLite .db file that I want to access through sqflite on Flutter. Where in the Flutter project am I supposed to put it so that I can access it both on Android and iOS? How do I make sure that it's shipped with the apk? All examples that I found assume that the db needs to be created from scratch at the first launch.

Does this answer your question? [Sqlite in flutter, how database assets work](https://stackoverflow.com/questions/51384175/sqlite-in-flutter-how-database-assets-work) In this link, the steps to use the SQLite database as an ASSET are fully described. — Esmaeil Ahmadipour, Jan 05 '23 at 08:20

score 3 · Answer 1 · answered Mar 14 '19 at 16:44

You can put the db file in your assets folder and declare it in your pubspec.yaml. On startup you can write it out to disk and then use that path with your connection string to connect the db.

You can read from assets using

var dbContent =
        await rootBundle.load('assets/database/mydb.db');

Then write it out to your file system and go from there.

score 1 · Answer 2 · answered Mar 14 '19 at 16:50

1

I've found that this problem is related to:

https://stackoverflow.com/a/51387985/3902715

Credits to R. C. Howell

answered Mar 14 '19 at 16:50

GLodi

201
1
3
13

Flutter - where to put own SQLite .db file?

2 Answers2