PDA

View Full Version : Phonegap plugin sqlite



paudiewalsh
2018-11-14, 10:39
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
2018-11-14, 12:03
Regarding SQLite I can recall only this one text, and it was about Python:
https://www.lianja.com/community/showthread.php?3046-Answers-Python&p=16715&viewfull=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
2018-11-14, 15:27
Hi Paudie,

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

1823

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
2018-11-14, 18:32
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.