SQLite or IndexDB?

[Pro_Certs]

I am working on a native app and I was looking at implementing SQLite but it seems SQL is no longer supported by iOS, and possibly Android in the near future.

My question is should I use the cordova-sqlite-evcore-extbuild-free plugin or look at IndexDB?

I build for Android and iOS with Voltbuilder.

[ghenne]

I would use cordova-sqlite-evcore-extbuild-free.

Have a look at this thread:

The Future of SQLite

It does appear that SQLLite functionality is back in iOS. However, I’ve noticed that the application seems to lose context with the DB on occasion. It might be that I’m opening the connection in main() and expecting the connection to persist. It might simply be that the connection needs to be made as needed. I’m going to try that but most of the functionality is back.

[Pro_Certs]

Thank you.

Do you have a sample project using cordova-sqlite-evcore-extbuild-free I could take a look at?

[ghenne]

Just add this line to config.xml:

<plugin name="cordova-sqlite-evcore-extbuild-free" source="npm" />

[Pro_Certs]

Hi, sorry yes I have done that but I’m new to sql and don’t know all the commands or how to retrieve the data from the tables ie for loading a table column into a list group.

I have looked at the sample projects but non of them are specific to that plug in.

[ghenne]

OK, so your question is actually “How do I use SQLite?”, not about the plugin.

SQLite works fine in Chrome, so you can test on the desktop. Have a look at the samples, including NorthWind to see actual code reading and writing SQLite databases.

There are also several articles in the Wiki:
https://wiki.appstudio.dev/index.php?search=sqlite&title=Special%3ASearch&go=Go