# Changes #### cordova-sqlite-storage 7.0.0 - minimum Android API -> 24 (Android 7.0), with 16 KB page alignment update, from cordova-sqlite-storage-dependencies@5.0.0 #### cordova-sqlite-storage 6.1.0 - SQLite 3.40.0 update from cordova-sqlite-storage-dependencies@4.1.0 #### cordova-sqlite-storage 6.0.0 - use cordova-sqlite-storage-dependencies@4.0.0 with Android JARs built from android-sqlite-native-ndk-connector and android-sqlite-ndk-native-driver, with enhancements by Luis Silva of OutSystems needed for some Android 11 devices, drops support for Android pre-5.1 ### cordova-sqlite-storage-commoncore 2.0.0 - 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) #### cordova-sqlite-storage 5.1.0 - Add browser platform support using sql-asm-memory-growth.js from sql.js, with some limitations as documented #### cordova-sqlite-storage 5.0.1 - enable RENAME table with view test - from December 2019 SQLite crash report, fixed in 2020 ref: - http://sqlite.1065341.n5.nabble.com/Crash-Bug-Report-tc109903.html - https://github.com/xpbrew/cordova-sqlite-storage/issues/904 - SQLite 3.32.3 update from cordova-sqlite-storage-dependencies@2.1.2 #### cordova-sqlite-storage 5.0.0 - avoid incorrect default directory on iOS/macOS - to be extra safe (see ) - ensure that default "nosync" directory *always* has resource value set for `NSURLIsExcludedFromBackupKey` - add more checks for missing database directory #### cordova-sqlite-storage 4.0.0 - rename PSPDFThreadSafeMutableDictionary to CustomPSPDFThreadSafeMutableDictionary and completely remove PSPDFThreadSafeMutableDictionary.h #### cordova-sqlite-storage 3.4.1 - SQLite 3.30.1 update from cordova-sqlite-storage-dependencies@2.1.1 #### cordova-sqlite-storage 3.4.0 - quick workaround for `SYNTAX_ERR` redefinition #### cordova-sqlite-storage 3.3.0 - new default page & cache sizes with cordova-sqlite-storage-dependencies@2.1.0 ##### cordova-sqlite-storage-commoncore 1.0.0 - additional EU string manipulation test cases #### cordova-sqlite-storage 3.2.1 - cordova-sqlite-storage-dependencies@2.0.1 with SQLite 3.28.0 update for all supported platforms Android/iOS/macOS/Windows #### cordova-sqlite-storage 3.2.0 - sqlite3_threadsafe() error handling on iOS/macOS #### cordova-sqlite-storage 3.1.0 - no SQLITE_DEFAULT_CACHE_SIZE compile-time setting on iOS/macOS/Windows #### cordova-sqlite-storage 3.0.0 - Use cordova-sqlite-storage-dependencies 2.0.0 with SQLITE_DBCONFIG_DEFENSIVE setting used by sqlite-native-driver.jar on Android ###### cordova-sqlite-ext-common-core 0.2.0 - Move SQLite3.UWP.vcxproj out of extra SQLite3.UWP subdirectory - Completely remove old Windows 8.1 & Windows Phone 8.1 vcxproj files ###### cordova-sqlite-extcore 0.1.0 - move the embedded `SQLite3-WinRT` component to `src/windows/SQLite3-WinRT-sync` and update `plugin.xml` ##### cordova-sqlite-ext-common-core 0.1.0 ###### cordova-sqlite-ext-core-common 0.1.0 - 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 ###### cordova-sqlite-storage-ext-core-common 2.0.0 - 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 ### cordova-sqlite-storage 2.6.0 - Use cordova-sqlite-storage-dependencies 1.2.1 with SQLite 3.26.0, with a security update and support for window functions ### cordova-sqlite-storage 2.5.2 - Ignore Android end transaction error when closing for androidDatabaseProvider: 'system' setting, to avoid possible crash during app shutdown () ### cordova-sqlite-storage 2.5.1 - fix internal plugin cleanup error log on Android ### cordova-sqlite-storage 2.5.0 - androidDatabaseProvider: 'system' setting, to replace androidDatabaseImplementation setting which is now deprecated ### cordova-sqlite-storage 2.4.0 - 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 ### cordova-sqlite-storage 2.3.3 - Quick fix for some iOS/macOS internal plugin error log messagess - test updates - quick doc updates ### cordova-sqlite-storage 2.3.2 - Mark some Android errors as internal plugin errors (quick fix) - remove trailing whitespace from Android implementation - test coverage updates - quick doc updates ### cordova-sqlite-storage 2.3.1 - Mark some iOS/macOS plugin error messages as internal plugin errors (quick fix) - Quick documentation updates ### cordova-sqlite-storage 2.3.0 - Use SQLite 3.22.0 with SQLITE_DEFAULT_SYNCHRONOUS=3 (EXTRA DURABLE) compile-time setting on all platforms (Android/iOS/macOS/Windows) ref: litehelpers/Cordova-sqlite-storage#736 ### cordova-sqlite-storage 2.2.1 - SQLITE_THREADSAFE=1 compile-time setting for iOS/macOS - Fix Android/iOS src copyright, perpetually ## cordova-sqlite-storage 2.2.0 - Android-sqlite-native-driver NDK objects in JAR to resolve issue on cordova-android@7 - Fix SQLiteAndroidDatabase implementation for Turkish and other foreign locales ## cordova-sqlite-storage 2.1.5 ##### cordova-sqlite-legacy-core 1.0.7 - 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) - SQLITE_DEFAULT_CACHE_SIZE build flag fix for macOS ("osx") and Windows ###### cordova-sqlite-legacy-express-core 1.0.5 - 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) ## cordova-sqlite-storage 2.1.4 ##### cordova-sqlite-legacy-core 1.0.6 ###### cordova-sqlite-legacy-express-core 1.0.4 - 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) ## cordova-sqlite-storage 2.1.3 ##### cordova-sqlite-legacy-core 1.0.5 ###### cordova-sqlite-legacy-express-core 1.0.3 - Resolve Java 6/7/8 concurrent map compatibility issue reported in litehelpers/Cordova-sqlite-storage#726, THANKS to pointer by @NeoLSN (Jason Yang/楊朝傑) in litehelpers/Cordova-sqlite-storage#727. - selfTest database cleanup do not ignore close or delete error on any platforms ## cordova-sqlite-storage 2.1.2 ##### cordova-sqlite-legacy-core 1.0.4 - New workaround solution to BUG 666: close db before opening (ignore close error) ## cordova-sqlite-storage 2.1.1 ##### cordova-sqlite-legacy-core 1.0.3 - Suppress warnings when building sqlite3.c & PSPDFThreadSafeMutableDictionary.m on iOS/macOS ##### cordova-sqlite-legacy-core 1.0.2 - Fix log in case of transaction waiting for open to finish; doc fixes - SQLite 3.15.2 build with SQLITE_THREADSAFE=2 on iOS/macOS (SQLITE_THREADSAFE=1 on Android/Windows) and other flag fixes in this version branch to avoid possible malformed database due to multithreaded access ref: litehelpers/Cordova-sqlite-storage#703 - Windows 10 (UWP) build with /SAFESEH flag on Win32 (x86) target ###### cordova-sqlite-legacy-express-core 1.0.2 - Use PSPDFThreadSafeMutableDictionary for iOS/macOS to avoid threading issue ref: litehelpers/Cordova-sqlite-storage#716 ###### cordova-sqlite-legacy-express-core 1.0.1 - Fix bug 666 workaround to trigger ROLLBACK in the next event tick (needed to support version with pre-populated database on Windows) ## cordova-sqlite-storage 2.1.0 - Visual Studio 2017 updates for Windows UWP build ## cordova-sqlite-storage 2.0.4 ###### cordova-sqlite-legacy-express-core 1.0.0 - Workaround solution to BUG litehelpers/Cordova-sqlite-storage#666 (hanging transaction in case of location reload/change) - selfTest simulate scenario & test solution to BUG litehelpers/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) ## cordova-sqlite-storage 2.0.3 - Drop engines rule from package.json - Doc fixes ### cordova-sqlite-storage 1.5.4 - Fix iOS/macOS version to report undefined insertId in case INSERT OR IGNORE is ignored - Fix FIRST_WORD check for android.sqlite.database implementation - SQLite 3.15.2 build fixes - Doc updates ## cordova-sqlite-storage 2.0.2 - Fix Windows target platform version ### cordova-sqlite-storage 1.5.3 - 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 ## cordova-sqlite-storage 2.0.1 ### cordova-sqlite-storage 1.5.2 - Build with sqlite 3.15.2 with the following settings in this version branch: - SQLITE_TEMP_STORE=2 - SQLITE_THREADSAFE=1 - SQLITE_ENABLE_FTS3 - SQLITE_ENABLE_FTS3_PARENTHESIS - SQLITE_ENABLE_FTS4 - SQLITE_ENABLE_RTREE - SQLITE_OMIT_BUILTIN_TEST - SQLITE_OMIT_LOAD_EXTENSION - SQLITE_DEFAULT_PAGE_SIZE=1024 and SQLITE_DEFAULT_CACHE_SIZE=2000 to avoid "potentially distruptive change(s)" from SQLite 3.12.0 ref: - SQLITE_OS_WINRT for Windows only - Check transaction callback functions to avoid crash on Windows - Fix echoTest callback handling - Fix openDatabase/deleteDatabase exception messages - Move Lawnchair adapter to a separate project - Doc updates ### cordova-sqlite-storage 2.0.0 - Reference Windows platform toolset v141 to support Visual Studio 2017 (RC) ### cordova-sqlite-storage 1.5.1 - Add engines rule to package.json to specify plugin version >= 2.0.0 in case of cordova-windows 4.4.2 or newer for Visual Studio 2017 (Preview) ### cordova-sqlite-storage 1.5.0 - Build with sqlite 3.15.1, with the following settings: - SQLITE_TEMP_STORE=2 - SQLITE_THREADSAFE=2 - FTS3, FTS4, and R-Tree enabled - SQLITE_DEFAULT_PAGE_SIZE=1024 and SQLITE_DEFAULT_CACHE_SIZE=2000 to avoid "potentially distruptive change(s)" from SQLite 3.12.0 ref: - Drop support for Windows 8.1 & Windows Phone 8.1 ### cordova-sqlite-storage 1.4.9 - 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 ### cordova-sqlite-storage 1.4.8 - 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 ### cordova-sqlite-storage 1.4.7 - Minor JavaScript fixes to pass @brodybits/Cordova-sql-test-app ### cordova-sqlite-storage 1.4.6 - 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 ### cordova-sqlite-storage 1.4.5 - Log/error message fixes; remove extra qid from internal JSON interface ### cordova-sqlite-storage 1.4.4 - 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 ### cordova-sqlite-storage 1.4.3 - Handle executeSql with object sql value (solves another possible crash on iOS) ### cordova-sqlite-storage 1.4.2 - 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 ### cordova-sqlite-storage 1.4.1 - Minimum Cordova version no longer enforced in this version ### cordova-sqlite-storage 1.4.0 - 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 ### cordova-sqlite-storage 1.2.2 - 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) ### cordova-sqlite-storage 1.2.1 - 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 ### cordova-sqlite-storage 1.2.0 - Rename Lawnchair adapter to prevent clash with standard webkit-sqlite adapter - Support location: 'default' setting in openDatabase & deleteDatabase ### cordova-sqlite-storage 0.8.5 - More explicit iosDatabaseLocation option - iOS database location is now mandatory - Split-up of some more spec test scripts ### cordova-sqlite-storage 0.8.2 - Workaround fix for empty readTransaction issue (litehelpers/Cordova-sqlite-storage#409) - Split spec/www/spec/legacy.js into db-open-close-delete-test.js & tx-extended.js ### cordova-sqlite-storage 0.8.0 - 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 ### 0.7.14 - REGEXP support completely removed from this version branch - Remove src/android/libs/.gitignore (inadvertently added in 0.7.13) ### 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.2` embedded (with error messages fixed) - Pre-populated database support removed from this version branch - Amazon Fire-OS support removed - Fix conversion warnings in iOS version ### 0.7.12 - 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 ### 0.7.11 - 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 ### 0.7.10 - Use Android-sqlite-connector instead of sqlite4java ### 0.7.9 - Build iOS and Windows versions with sqlite 3.8.10.2 embedded - Fix plugin id to match npm package id ### 0.7.8 - 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 ### 0.7.7 - include build of sqlite4java for Android x86_64 and arm-64 - clean publish to plugins.cordova.io ### 0.7.6 - 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 ### 0.7.5 - 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 ### 0.7.4 - 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 ### 0.7.3 - insertId & rowsAffected implemented for Windows (8.1) - plugin id changed ### 0.7.2 - 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 ### 0.7.1 - 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) ### 1.0.6 - 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. ### 1.0.5 - 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 ### 1.0.4 - 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 ### 1.0.3 - Fixed issue with multi-page apps on Android (due to problem when closing & re-opening app) ### 1.0.2 - Workaround for issue with multiple UPDATE statements WP(8) (#128) ### 1.0.1 - 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)