What is the way to connect a pre-populated sqlite db in react-native-sqlite-storage?

Question

I was trying hard to make a connection to sqlite db using react-native-sqlite-storage, I copied the steps in github, it worked perfectly on android but not on IOS, It is unable to find db file even I put it in the supposed folder "iOS/www", here is the open statement:

import {openDatabase} from 'react-native-sqlite-storage';

.....

const database = openDatabase({

      name: 'hebron_db.db',

      createFromLocation: '~hebron_db.db',

      location: 'default'

}, () => {

   console.log('db connection success')

}, () => {

   console.log('db connection error')

});

It states that "db connection success" even when I type wrong file name.

I use react native 0.62.2 Xcode: 11.5 npm: 6.13.4 macOS: Catalina 10.15.5

Any help will be much appreciated.

Answer 1

Tryout this connection string, it worked fine for me:

import {openDatabase} from 'react-native-sqlite-storage';

const database = openDatabase({name : "hebron_db", createFromLocation : 1}, null, null);

export default database;

If you want to get more insights into SQL, checkout this SQL Course from Intellipaat.