Read data from existing SQLite database through ionic and angular

Question

I'm new to ionic app development.
Going to develop a dictionary app with ionic, angular and sqlite.
SQLite db file is already prepared with required tables and the app needs to be deployed with the db file.

As the first step how can I read data from db file?

Should I use SQLite https://ionicframework.com/docs/native/sqlite
or SQLite Porter https://ionicframework.com/docs/native/sqlite-porter

let db = (<any>window).openDatabase('dictionary', '1.0', 'dictionary', 1 * 1024);
    this.http.get('../assets/database/dictionary.db', { responseType: 'text' })
          .subscribe(sql => {
            this.sqlitePorter.importSqlToDb(db, 'select * from terms')
              .then(() => console.log('Imported'))
              .catch(e => console.error(e));
          }, error => {
            console.log('error: ' + JSON.stringify(error));
          });

I tried above coding but it gives me 404 not found error on Android Studio emulator.

halfer · Accepted Answer · 2021-04-18 19:13:07Z

1

The import file should be .sql not .db. Since SqliteDbCopy is having an copying issue with capacitor, I used SQLitePorter

Final solution is to use capacitor, SQLitePorter and .sql file to import data.

edited Apr 18, 2021 at 19:13

halfer

20.2k20 gold badges110 silver badges207 bronze badges

answered Mar 12, 2021 at 5:08

devnc

10010 bronze badges

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

1 Comment

halfer Over a year ago

Where you have a supplementary question, please ask that as a new question. Thanks!

Collectives™ on Stack Overflow

Read data from existing SQLite database through ionic and angular

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related