ionic2/3 Pre-Populated Database Example

Simple Ionic 2/3 pre-populated database starter project.

To install this project:

Now you should see on your emulator/device the project and on the main page the elements from the database data.db table testTable.

I used the emulator for android Google Nexus 5X - 6.0.0 - API 23 from Genymotion

Create ionic project e.g., ionic start projectName blank
Add cordova-sqlite-ext: ionic cordova plugin add cordova-sqlite-ext --save
Create the database (you can use DB Browser for this) and copy the .db file to your project /www folder.
Add code to your home.ts folder to open the pre-populated database and then execute some query on a existing table on said database.
Run your project on a emulator/device and see the results.

If you can't execute with sucess the commands: ionic build android or ionic run android then run:

cordova platform add https://github.com/apache/cordova-android

This example contains commented code to use async/await to query the database.

To use this code, you should go to home.ts and comment lines 16-23 and uncomment line 24 and the method called accessDB().

Then go to tsconfig.json and change "target":"es5" to "target":"es2015"