@capacitor-community/sqlite - npm Package Versions

5.0.8 (2023-09-01)

Added Features

• Add Tutorials Blog in README.md

Bug Fixes

• Fix Cannot export encrypted database as plain JSON anymore issue#462

5.0.7 (2023-08-22)

Added Features

• Add a paramater isSQL92 default to true in execute, executeSet, run and query methods for ELECTRON plugin ONLY. if set to false the statements you were using in sqlite3 based release will be converted to SQL92 statement. As this is time consuming, we will advise you to cereate SQL statement compliant to SQL92.

• Add new methods (beginTransaction,commitTransaction,rollbackTransaction,isTransactionActive), that let you control the transaction process flow. In that case you MUST set the transition to false in any method you call.

Bug Fixes

• Fix Android DELETE From when FOREIGN KEYS and sql_deleted column issue#445.

• Fix SQL92 compatibility issue #451

• Modify transaction method to handle the new transaction process flow

• fix Call stmt.run() for statement without return #457 PR from Guilherme Oliveira

5.0.7-2 (2023-08-10)

Bug Fixes

• Fix Electron DELETE From when FOREIGN KEYS and sql_deleted column issue#445. Still to be fixed for Android

5.0.7-1 (2023-08-09)

Bug Fixes

• Fix iOS & Web(jeep-sqlite@2.4.0) DELETE From when FOREIGN KEYS and sql_deleted column issue#445. Still to be fixed for Android and Electron
• Add support for Math functions iOS issue#446

5.0.6 (2023-07-25)

Added Features

• Export encrypted data when database is encrypted issue#227

5.0.5 (2023-07-14)

Added Features

• insert/delete/update with returning discussion#435
• add Returning.md documentation

5.0.5-2 (2023-07-03)

Bug Fixes

• Electron fix encryption of unencrypted databases

5.0.5-1 (2023-07-01)

Chore

• Update to @capacitor/core@5.0.5
• Update to @capacitor/ios@5.0.5
• Update to @capacitor/android@5.0.5

Bug Fixes

• Electron fix encryption

5.0.4 (2023-06-29)

Removed Features

• Electron Plugin: Remove @journeyapps/sqlcipher and sqlite3 packages

Added Features

• Electron Plugin: Add better-sqlite3-multiple-ciphers package
• Electron Plugin: Add electron-json-storage package to store the passphrase for database encryption