How to ENABLE sqlite Pragma AUTO_VACCUM = FULL with ionic native sqlite


#1

I am creating an IPAD Application, which requires lot of insertions & deletions very frequently. So i went to use IONIC Native SQLITE storage for my multiple forms records. [My IPAD are less (costs expensive, having memory, having storage)]
suddenly i came to an article, which says, **

When you delete /drop any objects [tables, rows, indexes … ] from sqlite, It will not defragment / resize the database file [empty space stays on / AUTO INCREMENT RowID will not become 0]

which mean next insertion of a row with AUTO INCREMENT results to use next rowID rather than starts from 0 on whole table delete/ truncate.

So this is article helped me using SQLITE built in pragma commands to set DATABASE VACCUME to 1 or FULL will avoid such above highlighted situation : http://www.sqlitetutorial.net/sqlite-vacuum/

Unfortunately after reading these two pages,

  1. https://github.com/litehelpers/Cordova-sqlite-storage/issues/646
  2. https://stackoverflow.com/questions/16910149/phonegap-sqlite-vacuum

I learned that, it is not quite a straight way to use SQLITE Commands with Cordova / IONIC. I think most apple app developers depends on local storage as SQLITE for their swift / object C coded apps [think / might be].
So there should be alternate work around to resolve my issue.