This is a common plugin version branch which supports the most widely used features and serves as the basis for other plugin versions. remove androidLockWorkaround: 1 option if not needed any longer - storesafe/cordova-sqlite-storage#925.throw an exception in case of androidDatabaseImplementation: 2 setting which is now superseded by androidDatabaseProvider: 'system' setting.drop support for location: 0-2 values in openDatabase call (please use location: 'default' or iosDatabaseLocation setting in openDatabase as documented below).error code will always be 0 (which is already the case on browser and Windows) actual SQLite3 error code will be part of the error message member whenever possible (see storesafe/cordova-sqlite-storage#821).In an upcoming major release - see storesafe/cordova-sqlite-storage#922 New SQLite plugin design with a simpler API with a working demo - see brodybits/ask-me-anything#3 Breaking changes coming soon Permissive (see cordova-sqlcipher-adapter for details)Īvailable - contact - using built-in SQLite libraries on Android, iOS, and macOS - may be missing some important SQLite updates Breaking changes coming soon - see section nearby & see storesafe/cordova-sqlite-storage#922Ĭordova-sqlite-storage - core plugin versionĬordova-sqlite-ext - with extra features including BASE64 (SELECT BLOB in Base64 format), REGEXP, and pre-populated databasesĬordova-sqlite-evcore-extbuild-free - plugin version with lighter resource usage in Android NDKĪvailable - see or contact - includes workaround for extra-large result data on Android and lighter resource usage on iOS, macOS, and in Android NDKĪvailable - see or contact - includes encryption functionality using SQLCipher for Android/iOS/macOS.Multiple SQLite corruption problem - see section below & storesafe/cordova-sqlite-storage#626.LICENSE: MIT, with Apache 2.0 option for Android and Windows platforms (see LICENSE.md for details, including third-party components used by this plugin) WARNINGS Other alternatives documented in the alternative browser platform usage notes section below.This plugin now supports the browser platform using storesafe/sql.js (fork of sql-js/sql.js), with no persistence and other limitations described below.The browser platform is now supported with the following options: Windows 10 (UWP) DESKTOP and MOBILE (see below for major limitations). Native SQLite component with API based on HTML5/ Web SQL (DRAFT) API for the following platforms: SQLite.Cross-platform SQLite storage plugin for Cordova / PhoneGap - cordova-sqlite-storage plugin version Sqlite.query('SELECT ? + ? AS solution',, function(err, res) ) leteDatabase(name, callback)ĭelete the SQLite database with the specified name. With Cordova CLI tool: cordova plugin add cordova-sqlite-plugin Usage var SQLite = ('cordova-sqlite-plugin.SQLite') You can use this module directly but I would rather recommend to go with the AnySQL module which is a slightly higher level API. This is why I created this module, I extracted all the good part (the native code) from cordova-sqlite-storage and replaced the less good part (the JavaScript code implementing the WebSQL API) by a much simpler low-level API. Jokes aside, in my opinion there is something fundamentally wrong: when we are in the middle of a transaction, there is no way to run something asynchronously. What's wrong with the WebSQL API? It is simply the worst API ever created throughout the history of computing. It is a good choice if you like the WebSQL API but in case you don't, there are not many options. To use a SQLite database from a Cordova app, there is the cordova-sqlite-storage plugin. Cordova SQLite plugin with a straightforward low-level API.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |