Phonegap plugin sqlite

[paudiewalsh]

Hello
I am working on a mobile app for Android and would like to have sqlite for local storage. Will the plugin work with Lianja Phonegap apps. How do I add it to the Phonegap build?

Thank you
Paudie Walsh

[josipradnik]

Regarding SQLite I can recall only this one text, and it was about Python:
https://www.lianja.com/community/sho...ll=1#post16715

You should try with virtual tables, ODBC with specific connection string: https://www.connectionstrings.com/sqlite/
After you get the data in your desktop test app, I think Phonegap will not be a problem.

Josip

[HankFay]

Hi Paudie,

if you look at the PhoneGap setup dialog, you can see there is a place to declare plugins.



How you integrate to the sqlite on the mobile device will be up to you. Lianja has a Section method for importing/export JSON to/from a cursor.

Hank

[barrymavin]

Hi Paudie,

Is the reason you want to use SQLite because you want everything to work offline? If that’s the case you will need to wait for that capability which is already in the roadmap.