- SQLite 3.40.0 update
- remove Windows ARM support again
- add back LIMITED support for Windows ARM CPU
- include BLOBFROMBASE64 support from cordova-sqlite-evcore-free-dependencies@0.12.0
- SQLite 3.37.2 update from cordova-sqlite-evcore-free-dependencies@0.11.2 - with resolution for a very rare & unlikely corruption issue from SQLite 3.35.0 ref: https://sqlite.org/forum/forumpost/ac381d64d8
- SQLite 3.36.0 update from cordova-sqlite-evcore-free-dependencies@0.11.1 - as needed to avoid an issue with SQLite 3.35.x: https://sqlite.org/src/info/c88f3036a2 "ALTER TABLE DROP COLUMN corrupts data"
NOTE: "ALTER TABLE DROP COLUMN corrupts data" issue seems to have been resolved in SQLite 3.35.5 as well:
- update Windows minimum & target platform versions - BREAKING CHANGE
- update evcore NDK library - solution for Android 11 with target SDK 30, from cordova-sqlite-evcore-free-dependencies@0.11.0
- update libs from cordova-sqlite-evcore-free-dependencies@0.10.1
- BREAKING: drop Android pre-5.1 support
- SQLite 3.35.5 update
- fix for emojis and other 4-byte UTF-8 characters on Android
- update affected test cases
- update README.md
- refactor: update androidDatabaseLocation error messages
- refactor: clean up imports for Android
- Fix plugin param name for macOS ("osx") - tested with Cordova 9 and cordova-osx@5
- Drop support for Windows on ARM (Windows Mobile)
- enable RENAME table with view test - from December 2019 SQLite crash report, fixed in 2020 ref:
- SQLite 3.32.3 update - commit dependencies from cordova-sqlite-evcore-free-dependencies@0.9.3
- avoid incorrect default directory on iOS/macOS - to be extra safe (see storesafe/cordova-sqlite-storage#907)
- ensure that default "nosync" directory always has resource value set for
NSURLIsExcludedFromBackupKey - add more checks for missing database directory
- ensure that default "nosync" directory always has resource value set for
- internal Android evcore database state 100% non-static and private
- SQLite 3.30.1 build update, with new default page & cache sizes from cordova-sqlite-ext-deps@2.1.0
- rename PSPDFThreadSafeMutableDictionary to CustomPSPDFThreadSafeMutableDictionary and completely remove PSPDFThreadSafeMutableDictionary.h
- SQLite 3.30.1 update from cordova-sqlite-storage-dependencies@2.1.1
- quick workaround for
SYNTAX_ERRredefinition
- new default page & cache sizes with cordova-sqlite-storage-dependencies@2.1.0
- additional EU string manipulation test cases
- cordova-sqlite-storage-dependencies@2.0.1 with SQLite 3.28.0 update for all supported platforms Android/iOS/macOS/Windows
- sqlite3_threadsafe() error handling on iOS/macOS
- no SQLITE_DEFAULT_CACHE_SIZE compile-time setting on iOS/macOS/Windows
- Use cordova-sqlite-storage-dependencies 2.0.0 with SQLITE_DBCONFIG_DEFENSIVE setting used by sqlite-native-driver.jar on Android
- Move SQLite3.UWP.vcxproj out of extra SQLite3.UWP subdirectory
- Completely remove old Windows 8.1 & Windows Phone 8.1 vcxproj files
- move the embedded
SQLite3-WinRTcomponent tosrc/windows/SQLite3-WinRT-syncand updateplugin.xml
- Use cordova-sqlite-ext-deps@2.0.0 with SQLITE_DBCONFIG_DEFENSIVE setting used by sqlite-native-driver.jar on Android
- SQLite3 build updates from cordova-sqlite-ext version 2.3.1:
- build with SQLite 3.26.0 from cordova-sqlite-ext-deps@1.1.1
- sqlite-native-driver NDK build in JAR
- FTS5 & JSON1 enabled on all platforms
- SQLITE_DEFAULT_SYNCHRONOUS=3 (EXTRA DURABLE) compile-time setting on all platforms
- continue using SQLITE_THREADSAFE=1 on all platforms
- use & test with cordova-sqlite-evcore-free-dependencies@0.9.2 with SQLite 3.30.1 update
- quick fix of error messages on Windows
- use cordova-sqlite-evcore-free-dependencies@0.9.1 (with SQLite 3.28.0 update)
- additional EU string manipulation test cases
- SQLite 3.30.1 update from cordova-sqlite-evcore-free-dependencies@0.9.2
- SQLite 3.28.0 update from cordova-sqlite-evcore-free-dependencies 0.9.1
- evcore-native-driver.jar from cordova-sqlite-evcore-free-dependencies 0.9.0, with the following Android build updates (using SQLite 3.26.0):
- Set SQLITE_DBCONFIG_DEFENSIVE flag when opening db (POSSIBLY BREAKING CHANGE)
- Explicit APP_PLATFORM := android-14 setting in jni/Application.mk
with no more static members on Android
- beforePluginInstall.js updates
- use standard Promise
- get the plugin package name from package.json
- use const instead of var (this should be considered a POSSIBLY BREAKING CHANGE since const may not work on some really old Node.js versions)
- remove hasbang line that is not needed
- SQLITE_DBCONFIG_DEFENSIVE flag - iOS/macOS/Windows (POTENTIALLY BREAKING CHANGE)
- remove internal qid usage from JavaScript (not needed)
- non-static Android database runner map (POTENTIALLY BREAKING CHANGE)
- Completely remove old Android SuppressLint (android.annotation.SuppressLint) - POSSIBLY BREAKING CHANGE
- drop workaround for pre-Honeycomb Android API (BREAKING CHANGE)
- no extra @synchronized block per batch (iOS/macOS) - should be considered a POSSIBLY BREAKING change
- remove backgroundExecuteSql method not needed (iOS/macOS)
- Completely remove iOS/macOS MRC (Manual Reference Counting) support - should be considered a POSSIBLY BREAKING change
- Use cordova-sqlite-storage-dependencies 1.2.1 with SQLite 3.26.0, with a security update and support for window functions
- Ignore Android end transaction error when closing for androidDatabaseProvider: 'system' setting, to avoid possible crash during app shutdown (storesafe/cordova-sqlite-storage#833)
- Include SQLite 3.26.0 update from cordova-sqlite-evcore-free-dependencies 0.8.7
- evcore-native-driver.jar from cordova-sqlite-evcore-free-dependencies 0.8.6, with workaround for 4-byte UTF-8 crash bug and fix for Samaritan character crash bug on Android
- fix internal plugin cleanup error log on Android
- androidDatabaseProvider: 'system' setting, to replace androidDatabaseImplementation setting which is now deprecated
- evcore-native-driver.jar from cordova-sqlite-evcore-free-dependencies 0.8.4, with quick fix for error messages on Android
- Internal error message fix for evcore on Android
- Report internal plugin error in case of attempt to open database with no database name on iOS or macOS
- Cover use of standard (WebKit) Web SQL API in spec test suite
- Test and document insertId in UPDATE result set on plugin vs (WebKit) Web SQL
- other test updates
- Quick fix for some iOS/macOS internal plugin error log messagess
- test updates
- quick doc updates
- Mark some Android errors as internal plugin errors (quick fix)
- remove trailing whitespace from Android implementation
- test coverage updates
- quick doc updates
- Mark some iOS/macOS plugin error messages as internal plugin errors (quick fix)
- Quick documentation updates
- Fix Android/iOS src copyright, perpetually
- Fix SQLiteAndroidDatabase implementation for Turkish and other foreign locales
- Visual Studio 2017 updates for Windows UWP build
- Fix Windows target platform version
- Reference Windows platform toolset v141 to support Visual Studio 2017 (RC)
- Use cordova-sqlite-evcore-free-dependencies 0.8.3 with fix for multi-byte UTF-8 characters on Android ref:
- fix for multi-byte UTF-8 characters on Android ref:
- Fix Android/iOS src copyright, perpetually
- SQLite 3.22.0, with SQLITE_DEFAULT_SYNCHRONOUS=3 (EXTRA DURABLE ref: storesafe/cordova-sqlite-storage#736) & other build fixes
- additional evcore iOS/macOS/Windows compile-time options
- Android evcore NDK JAR from cordova-sqlite-evcore-free-dependencies 0.8.0, no longer using JSMN component
- cordova-sqlite-evcore-extbuild-free with SQLITE_THREADSAFE=1 on iOS/macOS ref: storesafe/cordova-sqlite-storage#754 (storesafe/cordova-sqlite-storage#754)
- Fix SQLiteAndroidDatabase implementation for Turkish and other foreign locales
- Visual Studio 2017 updates for Windows UWP build
- cordova-sqlite-evcore-common-free compile-time option fixes for iOS/macOS:
- SQLITE_THREADSAFE=2 on iOS/macOS to avoid possible malformed database due to multithreaded access ref: storesafe/cordova-sqlite-storage#703
- Suppress warnings when building sqlite3.c (iOS/macOS)
- Remove unwanted SQLITE_OMIT_BUILTIN_TEST option (iOS/macOS)
- Android evcore-native-driver NDK build in JAR from https://github.com/litehelpers/Android-sqlite-evcore-native-driver-free/tree/ext-master (with FTS5/JSON1/SQLITE_DEFAULT_PAGE_SIZE/SQLITE_DEFAULT_CACHE_SIZE build fixes included), wth JSMN (http://zserge.com/jsmn.html) included again under MIT license, now supports cordova-android@7.
- additional doc fixes
- Add error info text in case of close error on Windows
- Signal INTERNAL ERROR in case of attempt to reuse db on Windows (should never happen due to workaround solution to BUG 666)
- iOS/macOS @synchronized guard for sqlite3_open operation
- Signal INTERNAL ERROR in case of attempt to reuse db (Android/iOS) (should never happen due to workaround solution to BUG 666)
- Cleaned up workaround solution to BUG 666: close db before opening (ignore close error)
- android.database end transaction if active before closing (needed for new BUG 666 workaround solution to pass selfTest in case of builtin android.database implementation)
- Resolve Java 6/7/8 concurrent map compatibility issue reported in storesafe/cordova-sqlite-storage#726, THANKS to pointer by @NeoLSN (Jason Yang/楊朝傑) in storesafe/cordova-sqlite-storage#727.
- selfTest database cleanup do not ignore close or delete error on any platforms
- New workaround solution to BUG 666: close db before opening (ignore close error)
- Suppress warnings when building sqlite3.c & PSPDFThreadSafeMutableDictionary.m on iOS/macOS
- Fix log in case of transaction waiting for open to finish; doc fixes
- Windows 10 (UWP) build with /SAFESEH flag on Win32 (x86) target
- Use PSPDFThreadSafeMutableDictionary for iOS/macOS to avoid threading issue ref: storesafe/cordova-sqlite-storage#716
- Fix bug 666 workaround to trigger ROLLBACK in the next event tick (needed to support version with pre-populated database on Windows)
NOTICE: cordova-sqlite-evcore-extbuild-free releases 0.8.5, 0.8.6, 0.8.7, and 0.9.0 include evcore-native-driver build with missing source; a special GPL v3 exception is granted for these releases as described in #24.
- Drop engines rule from package.json
- Doc fixes
- Fix Windows target platform version
- Reference Windows platform toolset v141 to support Visual Studio 2017 (RC)
NOTICE: cordova-sqlite-evcore-extbuild-free releases 0.8.5, 0.8.6, 0.8.7, and 0.9.0 include evcore-native-driver build with missing source; a special GPL v3 exception is granted for these releases as described in #24.
- Workaround solution to BUG storesafe/cordova-sqlite-storage#666 (hanging transaction in case of location reload/change)
- selfTest simulate scenario & test solution to BUG storesafe/cordova-sqlite-storage#666 (also includes string test and test of effects of location reload/change in this version branch, along with another internal check)
- Drop engine constraints in package.json & plugin.xml (in this version branch)
NOTICE: cordova-sqlite-evcore-extbuild-free releases 0.8.5, 0.8.6, 0.8.7, and 0.9.0 include evcore-native-driver build with missing source; a special GPL v3 exception is granted for these releases as described in #24.
- Minor doc fixes
- Fix iOS/macOS version to report undefined insertId in case INSERT OR IGNORE is ignored
- Fix FIRST_WORD check for android.sqlite.database implementation
- Doc updates
- Fix merges to prevent possible conflicts with other plugins (Windows)
- Fix handling of undefined SQL argument values (Windows)
- Signal error in case of a failure opening the database file (iOS/macOS)
- Doc fixes and updates
NOTICE: cordova-sqlite-evcore-extbuild-free releases 0.8.5, 0.8.6, 0.8.7, and 0.9.0 include evcore-native-driver build with missing source; a special GPL v3 exception is granted for these releases as described in #24.
- Fix openDatabase/deleteDatabase exception messages in this version branch
- Build (with SQLite 3.15.2) with the following defines:
- SQLITE_TEMP_STORE=2
- SQLITE_THREADSAFE=1
- SQLITE_ENABLE_FTS3
- SQLITE_ENABLE_FTS3_PARENTHESIS
- SQLITE_ENABLE_FTS4
- SQLITE_ENABLE_FTS5
- SQLITE_ENABLE_RTREE
- SQLITE_ENABLE_JSON1
- SQLITE_OMIT_BUILTIN_TEST
- SQLITE_OMIT_LOAD_EXTENSION
- SQLITE_DEFAULT_PAGE_SIZE=4096 and SQLITE_DEFAULT_CACHE_SIZE=-2000 - new stable page/cache sizes from 3.12.0 ref:
- SQLITE_OS_WINRT for Windows only
- Android version with JSMN (http://zserge.com/jsmn.html) dependency removed.
- Doc updates
- Check transaction callback functions to avoid crash on Windows
- Fix echoTest callback handling
- Move Lawnchair adapter to a separate project
- Doc updates
- BASE64 support
- REGEXP for Android/iOS/macOS using sqlite3-regexp-cached
- Use SQLite 3.15.2 for all platforms (no SQLITE_DEFAULT_PAGE_SIZE or SQLITE_DEFAULT_CACHE_SIZE defined in this version branch)
- empty engines rule in package.json in this version branch
- Add engines rule to package.json (...)
- Drop support for Windows 8.1 & Windows Phone 8.1
- Minor JavaScript fix (generated by CoffeeScript 1.11.1)
- Update test due to issue with u2028/u2029 on cordova-android 6.0.0
- doc fixes
- Cleanup plugin.xml: remove old engine constraint that was already commented out
- Fix LICENSE.md
- Quick fix for Android error mapping and reporting
- Fix default Android implementation to reject SQL with too many parameters
- Fix Android version to handle location reload/change properly
- selfTest function add string test and test of effects of location reload/change
- Support macOS ("osx" platform)
- Signal an error in case of SQL with too many parameter argument values on iOS (in addition to Android & Windows)
- Include proper SQL error code on Android (in certain cases)
- Fix reporting of SQL statement execution errors in Windows version
- Fix Windows version to report errors with a valid error code (0)
- Some doc fixes
- Minor JavaScript fixes to pass @brodybits/Cordova-sql-test-app
- Custom Android database file location
- Include SQLite 3.14 for iOS and Windows (without FTS5 or JSON1 enabled)
- Stop remaining transaction callback in case of an error with no error handler returning false
- Expand selfTest function to cover CRUD with unique record keys
- Fix readTransaction to reject ALTER, REINDEX, and REPLACE operations
- Fix Windows 10 ARM Release Build of SQLite3 by disabling SDL check (ARM Release only)
- Fix Windows 8.1/Windows Phone 8.1 Release Build of SQLite3 by disabling SDL check
- Some documentation fixes
- Log/error message fixes; remove extra qid from internal JSON interface
- Fix readTransaction to reject modification statements with extra semicolon(s) in the beginning
- Announce new Cordova-sqlite-evcore-extbuild-free version
- Additional tests
- Other doc fixes
- SQLite and Android-sqlite-evcore-native-driver-free dependencies included to support PhoneGap Build
- Cordova engines specification dropped from package.json
- Use Android-sqlite-evcore-native-driver-free for high performance and memory improvements on Android
- Handle executeSql with object sql value (solves another possible crash on iOS)
- Fix sqlitePlugin.openDatabase and sqlitePlugin.deleteDatabase to check location/iosDatabaseLocation values
- Fix sqlitePlugin.deleteDatabase to check that db name is really a string (prevents possible crash on iOS)
- Fix iOS version to use DLog macro to remove extra logging from release build
- Fix Lawnchair adapter to use new mandatory "location" parameter
- Remove special handling of Blob parameters, use toString for all non-value parameter objects
- Minor cleanup of Android version code
- Minimum Cordova version no longer enforced in this version
- Now using cordova-sqlite-storage-dependencies for SQLite 3.8.10.2 Android/iOS/Windows
- Android-sqlite-connector implementation supported by this version again
- Enforce minimum cordova-windows version (should be OK in Cordova 6.x)
- Support Windows 10 along with Windows 8.1/Windows Phone 8.1
- Self-test function to verify ability to open/populate/read/delete a test database
- Read BLOB as Base-64 DISABLED in Android version (was already disabled for iOS)
- Close Android SQLiteStatement after INSERT/UPDATE/DELETE
- Specify minimum Cordova version 6.0.0
- Lawnchair adapter fix: Changed remove method to work with key array
- Rename Lawnchair adapter to prevent clash with standard webkit-sqlite adapter
- Support location: 'default' setting in openDatabase & deleteDatabase
- More explicit iosDatabaseLocation option
- iOS database location is now mandatory
- Split-up of some more spec test scripts
- Workaround fix for empty readTransaction issue (storesafe/cordova-sqlite-storage#409)
- Split spec/www/spec/legacy.js into db-open-close-delete-test.js & tx-extended.js
- Simple sql batch transaction function
- Echo test function
- All iOS operations are now using background processing (reported to resolve intermittent problems with cordova-ios@4.0.1)
- Java source of Android version now using io.sqlc package
- Drop Android-sqlite-connector support
- Drop WP(8) and Windows support
- REGEXP support completely removed from this version branch
- Remove src/android/libs/.gitignore (inadvertently added in 0.7.13)
- REGEXP support partially removed from this version branch
- Rename Windows C++ Database close function to closedb to resolve conflict for Windows Store certification
- Android version with sqlite
3.8.10.2embedded (with error messages fixed) - Pre-populated database support removed from this version branch
- Amazon Fire-OS support removed
- Fix conversion warnings in iOS version
- Fix to Windows "Universal" version to support big integers
- Implement database close and delete operations for Windows "Universal"
- Fix readTransaction to skip BEGIN/COMMIT/ROLLBACK
- Fix plugin ID in plugin.xml to match npm package ID
- Unpacked sqlite-native-driver.so libraries from jar
- Fix conversion of INTEGER type (iOS version)
- Disable code to read BLOB as Base-64 (iOS version) due to https://issues.apache.org/jira/browse/CB-9638
- Use Android-sqlite-connector instead of sqlite4java
- Build iOS and Windows versions with sqlite 3.8.10.2 embedded
- Fix plugin id to match npm package id
- Support FTS3/FTS4 and R-Tree in iOS and Windows "Universal" (8.1) versions
- Build ARM target with Function Level Linking ref: http://www.monkey-x.com/Community/posts.php?topic=7739
- SQLite3.Windows.vcxproj and SQLite3.WindowsPhone.vcxproj in their own directories to avoid problems due to temporary files
- include build of sqlite4java for Android x86_64 and arm-64
- clean publish to plugins.cordova.io
- Small fix to plugin id
- Disable use of gethostuuid() in sqlite3.c (only used in iOS version)
- published to plugins.cordova.io - [BUG] published extra junk in workarea, causing problems with Windows (Universal) version
- Windows (Universal) version now supports both Windows 8.1 and Windows Phone 8.1
- iOS and Windows versions are now built with sqlite 3.8.9 embedded
- Improved locking style and other optimizations applied for iOS version
- iOS and Windows (8.1) versions built to keep non-essential temporary sqlite files in memory
- Option to use legacy Android database library, with Android locking/closing issue (BUG #193) workaround included again
- insertId & rowsAffected implemented for Windows (8.1)
- plugin id changed
- Android version with sqlite4java (sqlite 3.8.7 embedded), which solves BUG #193: Android closing/locking issue (ICU-UNICODE integration is now missing)
- iOS version fixed to override the correct pluginInitialize method and built with sqlite 3.8.8.3 embedded
- Project renamed
- Initial version for Windows (8.1) [with sqlite 3.8.8.3 embedded]
- Abort initially pending transactions for db handle (due to incorrect password key, for example) [from Cordova-sqlcipher-storage]
- WP7 build enabled (NOT TESTED)
- Proper handling of transactions that may be requested before the database open operation is completed
- Report an error upon attempt to close a database handle object multiple times.
- Workaround for Android db locking/closing issue
- Fix double-precision REAL values in result (iOS version)
- Fix query result truncation in case of NULL character (\0 or \u0000) (iOS version)
- Convert array SQL parameters to string, according to match Web SQL spec
- Fix closing of Android database
- Some fixes for SQL API error handling to be consistent with Web SQL
- Pre-populated database option (Android/iOS)
- Option to select database location to disable iCloud backup (iOS ONLY)
- Safeguard against closing of database while transaction is pending
- Fix to prevent double marshaling of data
- Fixed issue with multi-page apps on Android (due to problem when closing & re-opening app)
- Workaround for issue with multiple UPDATE statements WP(8) (#128)
- Support Cordova 3.3.0/3.4.0 to support Amazon-FireOS
- Fixes for WP(8):
- use one thread per db to solve open/close/delete issues
- fix integer data binding
- Fix open/close callbacks Android & WP(8)
- Resolve issue with INSERT OR IGNORE (Android)