View Full Version : Phonegap plugin sqlite
paudiewalsh
2018-11-14, 11: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, 13: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
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, 19: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.