how to share sqlite database in flutter

Question

I built my database through SQLITE. I read the values from the database and created my page. Then I realized one fact. IOS and ANDROID have different paths in which DATABASE is stored.

It is my database code :

initDB() async{
    Directory dbDir = await getApplicationDocumentsDirectory();
    String path = join(dbDir.path, "social2.db");
    print('init...');
    print(path);
    return await openDatabase(
      path,
      version: 1,
      onOpen: (db) {},
      onCreate: (Database db, int version) async{
        await db.execute('''
        CREATE TABLE $tableName(
        id INTEGER PRIMARY KEY,
        email TEXT,
        password TEXT,
        name TEXT,
        intro TEXT,
        age TEXT,
        image0 BLOB,
        image1 BLOB,
        image2 BLOB,
        image3 BLOB,
        image4 BLOB,
        image5 BLOB,
        vote INTEGER,
        location TEXT) ''');
      },
    );
  }

How can I use my database normally?

Those are two different devices right? iOS and Android has different file structure. It shouldn't matter for the Apps. — Chenna Reddy
– Chenna Reddy, Commented Oct 15, 2019 at 10:47
I didn't get your question, what do you mean by same DB? It's a different DB on different device right? It might have different paths on iOS and Android, but that can't be a problem. — Chenna Reddy
– Chenna Reddy, Commented Oct 15, 2019 at 13:54
@ChennaReddy Strangely, my app works well because the IOS DB is working properly, but the ANDROID does not work.... :( — killer whale
– killer whale, Commented Oct 15, 2019 at 13:57

Marat · Accepted Answer · 2019-10-15 12:06:58Z

1

If you are using path_provider plugin then it supports both iOS and Android as stated in its documentation

A Flutter plugin for finding commonly used locations on the filesystem. Supports iOS and Android.

answered Oct 15, 2019 at 12:06

Marat

1,3683 gold badges13 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

how to share sqlite database in flutter

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related