Here is an important note in regards to Items 9 and 10 from the list.
When using the “cordova-sqlite-evcore-extbuild-free” plugin be aware that… “This plugin does not support the database creation callback or standard database versions. Please read the Database schema versions section below for tips on how to support database schema versioning.”
This means that you need to be careful on how you set the extraFiles parameter in the Projects Properties and Global Functions. Specifically, the overwrite parameter for Database instantiation.
eg. Database.db,DB,initDB,{overwrite}
Since there is no database versioning, there is only 2 choices to make when setting the parameter.
If you want the SQLite Database to persist (with any changes or updates made via the running app) between restarts you need to set the overwite parameter to “NSB.overwriteNever”.
If you set it to any of the other options (NSB.overwriteAlways, NSB.overwriteIfVersionDifferent, or NSB.overwriteIfVersionSame) each time the Application is restarted the Database will be initialized and overwrite the exisiting one.
Hope this helps anyone that is having similar issues with Initializing and persisiting an SQLite Database.