Cordova/PhoneGap SQLitePlugin - Windows Phone
Native interface to sqlite in a Cordova/PhoneGap plugin, working to follow the HTML5 Web SQL API as close as possible.
License for this version: MIT or Apache
Status
- Working with Cordova 3.0 tooling
- Tested on WP8 (included libraries should also support WP7)
- Next step is to integrate this version with the failure-safe transaction mechanism in lite4cordova / Cordova-SQLitePlugin
Highlights
- Keeps sqlite database in a user data location that is known and can be reconfigured
- Drop-in replacement for HTML5 SQL API, the only change is window.openDatabase() --> sqlitePlugin.openDatabase()
- batch processing optimizations
- No 5MB maximum, more information at: http://www.sqlite.org/limits.html
Known Issues
- Drop table is not working, looks like a bug in the net or csharp sqlite library. To get around this we can empty the tabe instead of dropping it.
- A high number of features in csharp-sqlite were disabled to build when included by Cordova 3.0 CLI.
- Missing failure-safe transaction mechanism
- Not (yet) working with SQLCipher for encryption
Installation
Download & Windows version of node.js then follow normal instructions for Cordova CLI for WP8
Test in wp-test subdirectory
Included dependencies
Support
If you have an issue with the plugin the best way to get help is by raising an issue. It is best to make post the simplest code necessary to demonstrate the issue.
If you have any questions please post to the lite4cordova forum.
Apps using the plugin