The Cordova SQLite plugin

The storage limitations enforced by the browser implementation of Web SQL Database is problematic for mobile apps, as 5 or even 50 MB may not be sufficient for the app's needs. Thankfully, there's a way around this limitation, and also around the fact that the standard is now dead and may be removed from browsers in the future: a third-party plugin.

There are several third-party plugins available that interface with SQLite, but the one we're going to use seeks to implement the same API as the specification used. This means that, in general, you can use the same code on desktop browsers and on mobile browsers. Some other plugins provide a very different API, which is fine, but it doesn't allow for as much reusability across platforms.

The plugin we'll be using is named Cordova SQLite Storage and is available from https://github.com/litehelpers/Cordova-sqlite-storage. You can add it to a Cordova project using the following command:

$ cordova plugin add io.litehelpers...