Can I export my sqlite database from Flutter?

Question

There are various articles on how to import data on the internal database from a csv, from another database etc .. but I haven't found anyone explaining how to export the flutter database.

The goal is to create a backup for each cell phone. (So I need to understand where it is located for create a backup)

Are you using the flutter package sqflite ? – hawkbee Jul 10 '19 at 16:02 — hawkbee, Jul 10 '19 at 16:02

CopsOnRoad · Answer 1 · 2019-07-10T18:35:34.250

5

I assume you are using sqflite plugin for SQLite operations and path_provider for storage. The path of the database can be found using

String path = await getDatabasesPath(); // which is data/data/<package_name>/databases

Additionally, sqflite plugin doesn't provide any way to import/export database, here is an open issue, if you really want to do it, you will have to do it natively using MethodChannel, here is the solution for Android and AFAIK there is no way to do it in iOS.

edited Jul 10 '19 at 18:35

answered Jul 10 '19 at 15:41

CopsOnRoad

175,842
51
533
380

Ok, but for ios is there a solution? Obviously always natively – AlexPad Jul 10 '19 at 16:43
@AlexPad I don't think there exist any solution for iOS. – CopsOnRoad Jul 10 '19 at 17:04
1

@AlexPad I tested the method, it works both for iOS(emulator) and Android(emulator). – CharlesC Aug 15 '20 at 23:08

score 3 · Answer 2 · edited Feb 25 '21 at 11:31

if you use Sqlite to create database:

Step 1: When you create database, you set a directory for it, you can use path_provider like this:

var dir = await getApplicationDocumentsDirectory();
_dbPath = dir.path + '/$dbName';

so now you know what directory and path it is.

Step 2: Then use flutter_archive plugin to zip the file (This will zip the file in a directory, which is your db);

Step 3: use flutter_email_sender to send it by email, like this:

final email = Email(
      body: 'content',
      subject: 'content',
      recipients: ['email'],
      cc: ['email'],
      attachmentPaths: [exportPath],
      isHTML: false,
    );
    await FlutterEmailSender.send(email);

Your need to provide exportPath, which is the zip file path you set up.

It worked for us, hope this will help other people!

Actually when your database is open, you can not archive it I think and you need to close the database first which is a bit challenging like how you can do it when you is still running? — Haroon khan, Oct 24 '21 at 07:52

score 0 · Answer 3 · answered Jun 09 '19 at 13:52

0

Usually on Android, databases are stored at /data/data/your.app.signature.here/databases/. But I don't know if that's different on flutter apps.

Hope that helps.

answered Jun 09 '19 at 13:52

bluewolf

1

Can I export my sqlite database from Flutter?

3 Answers3