- use cordova-sqlite-ext-deps 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
- fix: use cordova-sqlite-ext-deps 3.0.1 - with quick workaround update needed for BLOBFROMBASE64 on Android ARM target CPUs
- feat: add BLOBFROMBASE64 using cordova-sqlite-ext-deps 3.0.0 - BREAKING CHANGE due to removed Android pre-5.1 support
- 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)
- update cordova-sqlite-ext-deps -> 2.1.1 with SQLite 3.32.3 update
- enable RENAME table with view test - from December 2019 SQLite crash report, fixed in 2020 ref:
- 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
- SQLite 3.30.1 build update, with new default page & cache sizes from [email protected]
- rename PSPDFThreadSafeMutableDictionary to CustomPSPDFThreadSafeMutableDictionary and completely remove PSPDFThreadSafeMutableDictionary.h
- SQLite 3.30.1 update from [email protected]
- quick workaround for
SYNTAX_ERRredefinition
- new default page & cache sizes with [email protected]
- additional EU string manipulation test cases
- [email protected] 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
- [email protected] with SQLite 3.30.1 update, with new default page size & cache size on Android
- [email protected] with SQLite 3.28.0 update
Note that [email protected] includes the SQLite 3.26.0 build updates from the following cordova-sqlite-ext versions:
- Use [email protected] 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 [email protected]
- 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
- 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)
- fix internal plugin cleanup error log on Android
- androidDatabaseProvider: 'system' setting, to replace androidDatabaseImplementation setting which is now deprecated
- 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
- Use SQLite 3.22.0 with SQLITE_DEFAULT_SYNCHRONOUS=3 (EXTRA DURABLE) compile-time setting on all platforms (Android/iOS/macOS/Windows) ref: storesafe/cordova-sqlite-storage#736
- SQLITE_THREADSAFE=1 compile-time setting for iOS/macOS
- Fix Android/iOS src copyright, perpetually
- Android-sqlite-native-driver NDK objects in JAR to resolve issue on cordova-android@7
- Fix SQLiteAndroidDatabase implementation for Turkish and other foreign locales
- 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
- 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)
- Visual Studio 2017 updates for Windows UWP build
- 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
- Fix Windows target platform version
- 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)
- Reference Windows platform toolset v141 to support Visual Studio 2017 (RC)
- cordova-sqlite-ext build flag fixes:
- SQLite (3.15.2) build with SQLITE_THREADSAFE=2 on iOS as well as macOS to avoid possible malformed database due to multithreaded access ref: storesafe/cordova-sqlite-storage#703
- Suppress warnings when building sqlite3.c on iOS/macOS
- Some additional iOS build flag updates in this plugin version
- 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
- SQLite 3.15.2 build with SQLITE_THREADSAFE=2 on macOS ONLY (SQLITE_THREADSAFE=1 on Android/iOS/Windows) and other flag fixes in this plugin version
- 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)
- 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)
- Remove Lawnchair adapter from this version branch
- Support macOS platform with builtin libsqlite3.dylib framework in this version branch
- Part of openDatabase in nextTick as a hack to solve problem with workaround solution to storesafe/cordova-sqlite-storage#666 & pre-populated database on Windows
- Completely remove engine constraints from package.json in this version branch
- 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)
- 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
- BASE64 support
- REGEXP for Android/iOS/macOS using sqlite3-regexp-cached
- Build with sqlite 3.15.2, with the following settings:
- 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: http://sqlite.org/pgszchng2016.html
- SQLITE_OS_WINRT for Windows only
- 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)
- 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: http://sqlite.org/pgszchng2016.html
- 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
- 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
- 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
- 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
- Code to read BLOB data fixed and enabled for iOS version (as well as Android version)
- Now using cordova-sqlite-ext-deps for SQLite 3.8.10.2 Android/iOS/Windows
- Enforce minimum cordova-windows version (should be OK in Cordova 6.x)
- Self-test function to verify ability to open/populate/read/delete a test database
- 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
- Support Windows 8.1/Windows Phone 8.1 along with Windows 10
- Fix PCH issue with Debug Win32 UWP (Windows 10) build
- 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
- Mark upcoming BREAKING CHANGES to openDatabase parameters
NOTICE: 0.8.6 release was published to npm based on the wrong branch and is withdrawn, to be completely superseded by the 0.9.* release.
- Introduce Windows 10 UWP build (Windows 8.1 and Windows Phone 8.1 build disabled)
- 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
- Fix pre-populated database for Windows 8.1(+)/Windows Phone 8.1(+)
- Separate SQLiteConnectorDatabase class for Android
- Renamed SQLiteProxy.js to sqlite-proxy.js in Windows version
- Simple sql batch transaction function
- Echo test function
- Remove extra runInBackground: step from iOS version
- Java source of Android version now using io.sqlc package
- Support REGEXP on Android using PCRE (8.37)
- Support REGEXP for iOS included
- Support pre-populated database for Windows "Universal" (BROKEN)
- All iOS operations are now using background processing (reported to resolve intermittent problems with [email protected])
- Java source of Android version now using io.sqlc package
- Drop WP(8) 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)