-
Fix ExecuteTransaction with values throws exception for statements performing no actual changes issue#544
-
Fix executeSet not inserting rows issue#547
-
Update TypeORM-Usage-From-5.6.0.md (PR#549 from SaintPepsi)
- Fix escape string in multi row statements values via DatabaseUtils issue#537 (PR from lasher23)
- Fix(readme): missing closing code symbol issue#542 (PR from mirsella)
- Fix Multiple Row Statement Values case insensitive issue#536
- Fix delete useless semicolon issue#538 (PR#539 from lasher23)
- Update to @capacitor/core@5.7.3
- Update to @capacitor/ios@5.7.3
- Update to @capacitor/android@5.7.3
- Update to @capacitor/cli@5.7.3
- Update to jeep-sqlite@2.7.0
- Fix GetFromHTTPRequest not working issue#534 (Android,iOS, Electron)
- Update to @capacitor/core@5.7.2
- Update to @capacitor/ios@5.7.2
- Update to @capacitor/android@5.7.2
- Update to @capacitor/cli@5.7.2
- Fix ionic7-angular-sqlite-app tutorial fails on v5.7.1 issue#533
- Update to @capacitor/core@5.7.1
- Update to @capacitor/ios@5.7.1
- Update to @capacitor/android@5.7.1
- Update to @capacitor/cli@5.7.1
- Fix Is this plugin still maintained in 2024? issue#529
- Update to @capacitor/core@5.7.0
- Update to @capacitor/ios@5.7.0
- Update to @capacitor/android@5.7.0
- Update to @capacitor/cli@5.7.0
- Update to jeep-sqlite@2.6.2
- Add link to Web/Native vite-sveltekit-capacitor-sqlite in the README.md.
- Add SQLite Commands Within the Plugin chapter in API.md doc.
- Modify TypeORM-Usage-From-5.6.0.md
- Modify addUpgradeStatement parameters of the ISQLiteConnection
- Fix Calling run method with BEGIN statement throws StringOutOfBoundIndexException #526 (iOS, Android, Electron)
- Add SQLite Transactions Documentation SQLiteTransaction.md
- Fix Error in executeTransaction
- Include examples of SQLite comments in the API.md documentation
- Fix Error in README.md with install instructions issue#520
- Fix Unable to run executeSet on SQL with -- comments issue#521
- Fix SQL query is converted to be compatible with SQL92 regardless of argument value of isSQL92 in query method when values argument is an empty array issue#519
- Fix importFromJson of binary blob not working (iOS, Android, Electron)
- Fix exportToJson not working (iOS) issue#513
- Fix BLOB binding issue in iOS #514
- Remove the ability to run
migrations:generatewith the TypeOrm Cli as the way it has been implemented works from some Frameworks but not with Angular were developers could not anymore build there apps. see issue#516 Update 5.6.0.
- Fix Electron Platform SQL92 false generates invalid SQL query issue#518
- Update to @capacitor/core@5.6.0
- Update to @capacitor/ios@5.6.0
- Update to @capacitor/android@5.6.0
- Update to @capacitor/cli@5.6.0
- Update to jeep-sqlite@2.5.9
-
Add the ability to run
migrations:generatewith the TypeOrm Cli outside the DOM Element to create the migrations files. Then the migrations are run inside the DOM Element to create and store the database in the DOM Element. For this add a script to the package.json file"scripts": { ... "typeorm:migration:generate": "npx typeorm-ts-node-esm migration:generate src/PATH_TO_MIGRATIONS/YOUR_MIGRATION_NAME -d src/PATH_TO_YOUR_DATASOURCE"
-
Add TypeORM-Usage-From-5.6.0.md documentation
- Fix The jeep-sqlite element is not present in the DOM when trying to generate migration files via TypeOrm CLI issue#508
- Update to jeep-sqlite@2.5.8
- Fix exportToJson getSchema PRIMARY
- Fix allow exportToJson when mode equals "full" and no "sync_table"
- Fix out of memory since 1.9.0 issue#509 by upgrading sql.js to release 1.10.2
- Fix exportToJson getSchema Exception issue#504
- Fix returning is treated as a keyword in a string object discussion#503
- iOS Fix getDatabaseList & getMigratableDbList
- Android Fix getDatabaseList & getMigratableDbList
- Android addSQLiteSuffix or moveDatabasesAndAddSuffix doesn't copy data inside the original database issue#497
- Update to jeep-sqlite@2.5.5
- Android ImportFromJSON handle id as String in deletion statements issue#495 (PR#496 By mmouterde)
- Update to @capacitor/core@5.5.1
- Update to @capacitor/ios@5.5.1
- Update to @capacitor/android@5.5.1
- Fix importFromJson on android fails to build SQL Statement with ' in values. issue#492
- Update to @capacitor/core@5.5.0
- Update to @capacitor/ios@5.5.0
- Update to @capacitor/android@5.5.0
- Deprecate Ionic-Angular-Usage.md
- Deprecate Ionic-React-Usage.md
- Deprecate Ionic-Vue-Usage.md
- Update Application's links in Readme.md
- importFromJson on android fails to build SQL Statement with ' in values. issue#492
- Add nuxt3 kysely example PR#484 from DawidWetzler
- Update to @capacitor/core@5.4.1
- Update to @capacitor/ios@5.4.1
- Update to @capacitor/android@5.4.1
- Android: optimize executeSet execution time
- Android: optimize importFromJson execution time
- Update to @capacitor/core@5.4.1
- Update to @capacitor/ios@5.4.1
- Update to @capacitor/android@5.4.1
- Fix Two consecutive beginTransaction+commitTransaction calls results in an error on Android. issue#478
- Update to @capacitor/core@5.4.0
- Update to @capacitor/ios@5.4.0
- Update to @capacitor/android@5.4.0
- Add Electron decryptDatabase method
- Fix Electron setEncryptSecret
- Fix Android pattern in extractColumnNames
- Fix Bug: deleteSQL: Did not find column names in the WHERE Statement issue#470 all platforms
- Update to @capacitor/core@5.2.3
- Update to @capacitor/ios@5.2.3
- Update to @capacitor/android@5.2.3
- Remove console.log in definition.ts
- Add Tutorials Blog in README.md
- Fix Cannot export encrypted database as plain JSON anymore issue#462
-
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.
-
Fix Android DELETE From when FOREIGN KEYS and sql_deleted column issue#445.
-
Fix SQL92 compatibility issue #451
-
Modify
transactionmethod to handle the new transaction process flow -
fix Call stmt.run() for statement without return #457 PR from Guilherme Oliveira
- Fix Electron DELETE From when FOREIGN KEYS and sql_deleted column issue#445. Still to be fixed for Android
- 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
- Export encrypted data when database is encrypted issue#227
- insert/delete/update with returning discussion#435
- add Returning.md documentation
- Electron fix encryption of unencrypted databases
- Update to @capacitor/core@5.0.5
- Update to @capacitor/ios@5.0.5
- Update to @capacitor/android@5.0.5
- Electron fix encryption
- Electron Plugin: Remove
@journeyapps/sqlcipherandsqlite3packages
- Electron Plugin: Add
better-sqlite3-multiple-cipherspackage - Electron Plugin: Add
electron-json-storagepackage to store the passphrase for database encryption
- Add method isInConfigEncryption and isDatabaseEncrypted for electron
- Add electronIsEncryption in capacitor.config.ts = true use @journeyapps/sqlcipher = false use sqlite3
- Add SQLiteBlob.md documentation
- fix issue#426 for Android & iOS returning binary array
- fix Cannot bind buffer in Android issue#428 for Android & iOS
- fix issue#426 for Android & iOS with base64 string
- add Ionic react typeorm example PR#423 from Marcello Cosentino
- add link to Ionic7-angular-sqlite-starter
- fix Readme.md file
- Update to @capacitor/core@5.0.4
- Update to @capacitor/ios@5.0.4
- Update to @capacitor/android@5.0.4
- Enable electron database encryption PR#342 from Clément Béligat
- Fix Encrypted electron database issue#162
- Update to @capacitor/core 5.0.0
- Update to @capacitor/ios 5.0.0
- Update to @capacitor/android 5.0.0
- Fix UtilsJson (Android}
- Update to @capacitor/core@5.0.0-beta.1
- Update to @capacitor/ios@5.0.0-beta.1
- Update to @capacitor/android@5.0.0-beta.1
- Enable electron database encryption PR#342 from Clément Béligat
- Update to jeep-sqlite@2.3.4
- Fix Database fails to open when browser window minimized issue#402
- Update to @capacitor/core 4.8.0
- Update to @capacitor/ios 4.8.0
- Update to @capacitor/android 4.8.0
- add SyntaxScanner-For-SQLite-Code.md PR#405 issue#400
- Fix Ionic-React-Usage.md PR#403
- Fix Data import where the ID is a UUID and sql_deleted = 1 issue#399
- Update to jeep-sqlite 2.3.1
- add getFromLocalDiskToStore and saveToLocalDisk methods (Web platform)
- add unexpected behaviour docs PR #394 by folsze
- Remove logs in build (Web) issue#392
- Fix Strip comment lines when using CapacitorSQLite.execute (Android} PR#387 by patdx
- Fix CapacitorSQLite.execute on Android does not support comments issue#386
- Add Comments within SQL statements in API.md
- Update Ionic-React-Usage.md PR#390 by eppineda
- Fix Foreign Key Support on Web Version (jeep-sqlite) issue#385
- Update to @capacitor/core 4.6.3
- Update to @capacitor/ios 4.6.3
- Update to @capacitor/android 4.6.3
- Update configure plugin section #381 by ws-rush
- Add link to vite-vue-sqlite-app
- Update to jeep-sqlite@2.0.0 with @stencil/core@3.00
- Update SQLCipher to 4.5.0 (iOS & Android only)
- Update to androidx.security:security-crypto:1.1.0-alpha05 (should fix issue#321)
-
Keep database version number after encrypting a database (iOS)
-
Encrypted Database isn't Encrypted when no Passphrase stored (iOS, Android) issue#375
- add isDatabaseEncrypted, isInConfigEncryption, isInConfigBiometricAuth methods
- Update to @capacitor/core 4.6.2
- Update to @capacitor/ios 4.6.2
- Update to @capacitor/android 4.6.2
- Failed to parse source map issue#374
- add checkEncryptionSecret #issue-request#370.
- add
ionic-angular-sqlite-startera new application starter for CRUD operations
- fix contributors paragraph ending correctly (PR Micha-Richter)
- fix addUpgradeStatement all platforms
- Update to @capacitor/core 4.6.1
- Update to @capacitor/ios 4.6.1
- Update to @capacitor/android 4.6.1
- fix(docs): use yarn add in favor of deprecated yarn install --save issue#362 (PR from Sirs0ri)
- fix open readonly encrypted database (Android) issue#364 (PR from TheNovemberRain)
- fix file deletion for windows (Electron) issue#367 (PR from tobiasmuecksch)
- improve code in docs issue#368 (PR from fizdalf)
- Update to @capacitor/core 4.6.0
- Update to @capacitor/ios 4.6.0
- Update to @capacitor/android 4.6.0
- Fix createNCConnection and closeNCConnection in Android
- Update to @capacitor/core 4.5.0
- Update to @capacitor/ios 4.5.0
- Update to @capacitor/android 4.5.0
- Update to jeep-sqlite 1.6.9
- Fix sortedKeys in onUpgrade Electron issue#353
- Update to @capacitor/core 4.2.0
- Update to @capacitor/ios 4.2.0
- Update to @capacitor/android 4.2.0
- Fix Write-Ahead logging
- WAL journal_mode implemented for all platforms
- WAL2 journal_mode available only for iOS and Android (default)
🚨 NOT TO BE USED 🚨
- trial to fix Electron WAL2 concurrent access
- fix Electron Windows file lock error issue#326 (PR from tobiasmuecksch)
- fix Electron db.close() error reporting issue#329 (PR from tobiasmuecksch)
- fix README for pnpm installation
- Update to @capacitor/core 4.1.0
- Update to @capacitor/ios 4.1.0
- Update to @capacitor/android 4.1.0
- add getFromHTTPRequest iOS and Android issue#316.
- add getFromHTTPRequest Electron and Web only issue#316.
- fix addUpgradeStatement doesn't create all versions when starting with an empty database issue#320
- add readonly mode to connection (Web) through the use of jeep-sqlite.
- Fix checkConnectionsConsistency for mode readwrite and readonly
- add readonly mode to connection (Electron). So one read&write and one readonly connections could be opened on the same database.
- add readonly mode to connection (iOS & Android only). So one read&write and one readonly connections could be opened on the same database.
- Replace addUpgradeStatement with the new database incremental upgrade version. see new doc IncrementalUpgradeDatabaseVersion
- Fix getAssetsDatabasesPath reading capacitor.config.ts (Electron)
- Remove console.log statements (Electron)
- Redesign of the README.md
- Fix README.md
- Clean up the README.md
- Update to @capacitor/core 4.1.0
- Update to @capacitor/ios 4.1.0
- Update to @capacitor/android 4.1.0
- Composite primary key - export/import problem
- publish as
latestrelease in npm
- Update to @capacitor/core 4.0.1
- Update to @capacitor/ios 4.0.1
- Update to @capacitor/android 4.0.1
- Fix After adding the plugin Android compilation fails #301
- Update to @capacitor/core 3.7.0
- Update to @capacitor/ios 3.7.0
- Update to @capacitor/android 3.7.0
- fix issue#299 (PR joewoodhouse)
- adding some messages for improving error in electron #304
- Allow copying databases from the cache folder #303
- Add move databases #307
- Problems with DELETE FROM #285
- Fix call of setLastExportDate only if sync_table exists
- test
jeep-sqlitewithsql.js@1.7.0
- added method
clearEncryptionSecretto reset a previously saved passphrase in the keychain (issue #283). Thanks to the contributioin of chriswep
- Fix #271 for iOS & added support for table name containing dash/hyphen. Thanks to the contributiion of victorybiz
- Fix No error thrown when table does not exist for Electron issue#277
- Update to @capacitor/core 3.5.1
- Update to @capacitor/ios 3.5.1
- Update to @capacitor/android 3.5.1
- DELETE FROM does not work issue#271 (victorybiz)
- Update to @capacitor/core 3.5.0
- Update to @capacitor/ios 3.5.0
- Update to @capacitor/android 3.5.0
-
Add a link
angular-sqlite-synchronize-appapplication demonstrating the import/export JSON object including the new delete feature with thesql_deletedcolumn to synchronize local database with remote server database. -
Modify Contributor list format
- fix(executeTransaction): fix definition issue#267
- add a
sql_deletedcolumn on table to manage the synchronization of deleted records. Before the record was deleted when aDELETE FROMcommand was issued, now the record is updated with thesql_deletedset to 1 - add
deleteExportedRowsmethod to physically delete the records having thesql_deletedset to 1, after a successful synchronization with a remote server database
- add a
sql_deletedcolumn on table to manage the synchronization of deleted records. Before the record was deleted when aDELETE FROMcommand was issued, now the record is updated with thesql_deletedset to 1 - add
deleteExportedRowsmethod to physically delete the records having thesql_deletedset to 1, after a successful synchronization with a remote server database - add a solidjs-vite-sqlite-app application to demonstrate the use of this new feature
- Delete use case with Local to Server Sync issue#237
- Update to @capacitor/core 3.4.3
- Update to @capacitor/ios 3.4.3
- Update to @capacitor/android 3.4.3
- Fix Upgrade Database Version, another table already exists issue#263
- Improve Electron code visibility
- Upgrade TypeORM-Usage.md
- update _trigger_last_modified (WHEN NEW.last_modified < OLD.last_modified BEGIN )
- iOS: add TYPE AFFINITY in JSON Object for
importFromJsonandExportToJson - do not execute UPDATE in
importFromJsonforpartialmode when all provided column' values are identical to those in the database - Fix TypeError: Cannot convert undefined or null to object during TypeORM DataSource.initialize() issue#249
- Update
ImportExportJson.mddocumentation
- iOS Query returing multiple rows - Array issue#195
!!!! DO NOT USE IT !!!!
- add
getTableListmethod - add
overwriteparameter in JSON object
- update documentation Web-Usage.md for Ionic/Angular
- set Foreign Keys Off before Dropping the tables in import full json issue#245
- Insert Floating point (iOS) issue#239
- Update to @capacitor/core 3.4.2
- Update to @capacitor/ios 3.4.2
- Update to @capacitor/android 3.4.2
- No handling of changeEncryptionSecret iOS & Android issue #233
- add Electron folder databases location in the
capacitor-config.tsfor Windows and Linux
- add Electron folder databases location in the
capacitor-config.tsfirst step MacOS only
- Fix Android the master key android-keystore://androidx_security_master_key exists but is unusable
- Fix ImportExportJson.md regarding the use of last_modified table column
- Fix createSyncTable when last_modified column not in table's schema
- Update to @capacitor/core 3.4.1
- Update to @capacitor/ios 3.4.1
- Update to @capacitor/android 3.4.1
- add iosIsEncryption, androidIsEncryption in capacitor.config.ts iOS KeyChain & Android MasterKey are not defined when these parameters are set to false meaning that databases could not be encrypted
- Fix Android issue#224
- add transaction method to group several sql statements in one transaction
- fix How to handle Transactions with this plugin issue#230
- fix Android Sqlite Encryption DB Failed when tested with Immuniweb issue#229
- add biometric authentication to MasterKey (Android)
- add biometric authentication to Keychain (iOS)
- add Biometric Authentication documentation
- fix variable keychain account for multiple applications using the plugin
- Update to @capacitor/core 3.4.0
- Update to @capacitor/ios 3.4.0
- Update to @capacitor/android 3.4.0
- Fix iOS issue#220
- Fix Android issue#221
- fix TypeORM-Usage.md
- update README.md
- fix getUrl integrate "file://" in the returned url
- fix create databaselocation in iOS
- add getUrl method Get DB Path iOS & Android
- fix Get DB Path or file URI issue#208
- fix Android Error during database version upgrade issue#209
- iOS Support for databases that are not visible to iTunes and are not backed up by iCloud issue#207
- fix README.md
- fix API.md
- Update to @capacitor/core 3.3.3
- Update to @capacitor/ios 3.3.3
- Update to @capacitor/android 3.3.3
- Open in Read-Only Mode databases without SQLite suffix
- getNCDatabasePath, createNCConnection, closeNCConnection, isNCDatabase
- add NonConformedDatabase.md documentation
- fix mode "UNIQUE" not case sensitive in importToJson index issue#203
- fix support non-conformed database in read-only mode issue#201
- Update to @capacitor/core 3.3.2
- Update to @capacitor/ios 3.3.2
- Update to @capacitor/android 3.3.2
- fix addSQLiteSuffix skips databases without .db extension issue#200
- Update to @capacitor/core 3.3.1
- Update to @capacitor/ios 3.3.1
- Update to @capacitor/android 3.3.1
- add link to React-Vite and Vue-Vite application
- fix Plugin failed to register in Android 11 physical device issue#196
- fix Ionic-React-Usage.md
- fix Ionic-Vue-Usage.md
- fix Electron
npm install --save jszipin README issue#197
- stable release
- add importing zipped files using copyFromAssets method
- fix issue#191
- Update to @capacitor/core 3.2.5
- Update to @capacitor/ios 3.2.5
- Update to @capacitor/android 3.2.5
- fix Electron isTable issue#188
- fix iOS closeAllConnections issue#190
- fix Electron + TypeORM - Transaction error issue#186
- add getMigratableDbList requested in issue#182
- fix MigratingCordovaDatabases.md
- Update to @capacitor/core 3.2.4
- Update to @capacitor/ios 3.2.4
- Update to @capacitor/android 3.2.4
- Extend addSQLiteSuffix and deleteOldDatabases by providing a database name's list
- fix issue#182
- Update Web-Usage.md for React and Vue frameworks
- Update to @capacitor/core 3.2.3
- Update to @capacitor/ios 3.2.3
- Update to @capacitor/android 3.2.3
- add initWebStore and saveToStore methods to the web plugin
- Update API.md databases location for Web platform
- Update Ionic-Vue-Usage.md
- Update API.md databases location for Web platform
- Fix Web Platform, add componentOnReady on constructor
- Fix All Platforms, executeSet breaks with empty array issue#170
- Update to @capacitor/core 3.2.2
- Update to @capacitor/ios 3.2.2
- Update to @capacitor/android 3.2.2
- Add Views in JsonSQLite (issue#167)
- Add getVersion method
- Fix Android importFromJson change in version throwing error mentioned in issue#164
- Fix iOS importFromJson change in version throwing error mentioned in issue#164
- Fix Electron importFromJson change in version throwing error mentioned in issue#164
- Fix Web importFromJson change in version throwing error mentioned in issue#164
- Add Ionic/React App to Web_Usage.md
- fix README.md
- Fix Android importFromJson throwing error mentioned in issue#164
- Fix iOS importFromJson throwing error mentioned in issue#164
- Add Ionic/Vue App to Web_Usage.md
- Fix Electron with "electron" in the app name issue#163
- Fix Electron
assets/databasesunderpublicfolder for Vue and React frameworks
- Fix web store initialization
- Fix Electron echo method
- Add Web plugin part based on
sql.js@1.5.0andlocaleforage@1.9.0for database persistency. - Add Web_Usage.md doc
- android in partial model importFromJson failed of update data: NIQUE constraint failed: xxx.id issue#160
- Update to @capacitor-community/electron 4.0.3
- Update to @capacitor/core 3.2.0
- Add Electron plugin part based on sqlite3 and @capacitor-community/electron 3.1.0
- in checkConnectionsConsistency close all connections when not consistent
- Support for Android API level 21 issue#132
- remove temporary fix for Wrong values on insert and query issue#125 fix by Capacitor 3.1.2
- remove trial web implementation with sql.js
- copyFromAssets only takes files with SQLite.db suffix on iOS (contrary to Android) issue#152
- put back temporary fix for Wrong values on insert and query issue#125 not fixed by Capacitor 3.1.2
- Update to Capacitor 3.1.2
- copyFromAssets fails on Android 6 issue#151
- CapacitorSQLite.toJSON Android #144 fix by Capacitor 3.1.2
- remove temporary fix for Wrong values on insert and query issue#125 fix by Capacitor 3.1.2
- Fix issue#147
- Update to Capacitor 3.1.1
- Remove console.log in SQLiteDBConnection
- update npm Version in README.md
- Update to Capacitor 3.0.2
- Update README.md
- Fix Insert Null as Foreign Key Android issue#125
- Fix SetEncryptionSecret Android issue#141
- Thanks to Chris, a driver to TypeORM is now available.
- TypeORM-Usage.md
- Double precision type numbers are read as floats Android #issue124
- CapacitorSQLite.isSecretStored()" is not implemented on android #issue123
- Update to Capacitor 3.0.0
- iOS null or empty column return as string "NULL" #issue119, #issue120
- JS float numbers are rejected in run statements (iOS) #issue121
- Update to Capacitor 3.0.0-rc.1
- Allow users to set secret #issue88
- add isSecretStored, setEncryptionSecret, changeEncryptionSecret methods
- ImportFromJson in Partial Mode without schema changes #issue113
- Event Listeners for Import and Export Json #issue112
- Checking on Types has been removed #issue108
- NULL values are now returned as null #issue109
- values in Query method accepts from now an Array of any #issue110
- fix disable transaction #issue111
- Fix Android app crashes when creating connection with wrong secret issue#105
- Fix reload of webview breaks connection handling #issue106
- Fix user provides a name that ends on ".db" #issue107
- Fix add an option to disable transactions #issue111
- add Supported SQLite Types in README.md #issue108
- Fix prepareSQL Android for null value
- Fix ImportFromJson db is Locked issue#101
- add
Libraryfolder to iOS addSQLiteSuffix method - update MigratingCordovaDatabases.md accordingly
- Fix executeSet on iOS not accept null values issue#89
- Update to Capacitor 3.0.0-rc.0
- isConnection method
- isDatabase method
- getDatabaseList method
- isTable method
- addSQLiteSuffix method
- deleteOldDatabases method
- isDBOpen
- MigratingCordovaDatabases.md
- Fix Copy db from storage issue#77
- Fix Is there a way to connect to a db file, that not has the prefix SQLite.db issue#79
- Fix More precise error message on failing statements issue#82
- Fix issue#84 Android
- Fix executeSet on android not accept null values issue#89
- Fix issue#97
- Fix Data import where the ID is a UUID issue#75
- Fix Can't create my own DB Trigger issue#76
- fix issue#71 Compound primary Key when ImportFromJSON
- getSyncDate returns a toISOString() data and not an Unix Epoch
- update documentation
- add SQLCipher dependency in CapacitorCommunitySqlite.pod
- update API Docs
- update README, CHANGELOG
- update to @capacitor/core@3.0.0-beta.1
- better Error handling throught try...catch
- Fix Android app crashes when creating connection with wrong secret issue#105
- Fix ImportFromJson db is Locked issue#101
- update to @capacitor/core@2.4.7
- Fix issue#89 Android, iOS
- Fix issue#97
- Fix issue#84 Android
- Fix isDBOpen method Android
- isDBOpen method
- isConnection method
- isDatabase method
- getDatabaseList method
- isTable method
- addSQLiteSuffix method
- deleteOldDatabases method
- MigratingCordovaDatabases.md
- Fix Copy db from storage issue#77
- Fix Is there a way to connect to a db file, that not has the prefix SQLite.db issue#79
- Fix More precise error message on failing statements issue#82
- Fix Android export 'Partial' triggers
- Fix Data import where the ID is a UUID issue#75
- Fix Can't create my own DB Trigger issue#76
- Fix Compound primary Key when ImportFromJSON issue#71
- Update ImportExportJson
- Move to latest tag
- Fix isIdExists on Electron
- Readme all links to apps and docs
- importFromJson not working with REAL
- Fix 'build-electron' missing before publish
- update CHANGELOG
- Fix in definition.ts Since 2.4.9 in 2.9.0
- Fix documentation links from 'refactor' to 'master'
- update README and CHANGELOG
- Fix issue#64 create UNIQUE Indexes with combined columns
- update ImportExport documentation
- update README and CHANGELOG
- Fix issue#63 by removing encryption for Windows
- update README and CHANGELOG
- update to @capacitor/core@2.4.6
- remove Android permissions issue#60
- update usage docs
- update README and CHANGELOG
- fix Ionic-React-Usage.md documentation
- fix Ionic-Vue-Usage.md documentation
- update README and CHANGELOG
- update to @capacitor/core@2.4.5
- Ionic-React-Usage.md documentation
- Ionic-Vue-Usage.md documentation
- copyFromAssets
- update README and CHANGELOG
- importFromJson (Android, iOS, Electron)
- exportToJson (Android, iOS, Electron)
- isJsonValid (Android, iOS, Electron)
- getSyncDate (Android, iOS, Electron)
- update README and CHANGELOG
- Update the README and add a link to a Ionic/React app.
- update to @capacitor/core@2.4.4
- createConnection
- closeConnection
- open (non-encrypted DB)
- open (encrypted DB)
- close
- execute
- executeSet
- run
- query
- deleteDatabase
- createSyncTable
- setSyncDate
- isDBExists
- addUpgradeStatement
- in capSQLiteSet the values can be an any[] or any[][]
- Update the README and add a link to a Ionic/React app.
- Update the API documentation
- retrieveConnection (Wrapper Connection)
- retrieveAllConnections (Wrapper Connection)
- closeAllConnections (Wrapper Connection)
- fix rollback transaction in iOS
- createConnection
- closeConnection
- open (non-encrypted DB)
- open (encrypted DB)
- close
- execute
- executeSet
- run
- query
- deleteDatabase
- createSyncTable
- setSyncDate
- isDBExists
- addUpgradeStatement
- Android addUpgradeStatement backup and restore
- add addUpgradeStatement method
- add createSyncTable method
- add setSyncDate method
- update refactor app
- creating database directory in physical device
- app crash when querying non existing tables or columns
- update to @capacitor/core@2.4.3
- add Wrappers documentation (APIConnection && APIDBConnection)
- add
isDBExists,deleteDatabasemethods
- createConnection method
- closeConnection method
- SQLiteConnection Interface & Class
- SQLiteDBConnection Interface & Class
-
update to @capacitor/core@2.4.6
-
move it from tag latest to tag initial
- Fix README and CHANGELOG
- Fix Electron rebuild
- Fix Permission request Android issue#60
- Fix README and CHANGELOG
- Fix API.md
- update to @capacitor/core@2.4.5
- Fix README and CHANGELOG
- update to @capacitor/core@2.4.4
- Fix README
- Fix setSyncDate (iOS)
- Fix exportToJson (Android)
- Fix lastId to Int64 (iOS)
- Fix issue#59 ExportToJson
- update to @capacitor/core@2.4.3
- Fix issue#56 INSERT null value on iOS
- Stable release before looking at a refactor for solving issue#1
- Add Listener for request permissions (Android)
- Add Vue and Ionic/Vue demonstrating apps
- Update documentation
- Fix iOS plugin open bug
- Add addUpgradeStatement for version upgrade (Android)
- Fix README issue#47
- Add addUpgradeStatement for version upgrade (iOS & Electron)
- Add UgradeDatabaseVersion.md documentation
- Fix iOS plugin build failed
- Fix Android Trigger on multi-lines
-
Add docgen to generate API documentation
-
Add a trigger for last_modified in importFromJson method to update the last-modified field when a data in an another field is updated
- Split up capSQLiteOptions capSQLiteResult in multiple interfaces issue#4
- Fix podspec file name (iOS)
- Capacitor: update 2.4.2
- The electron plugin is now compatible with @capacitor-community/electron
- Fix Better permission request on Android issue#40
- Update APIdocumentation.md, .gitignore & .npmignore
- Fix bug in setSyncDate iOS & electron
- Capacitor: update 2.4.0
- Fix Android sqlite3_close issue#36
- Fix iOS encryption issue
- Fix iOS encryption issue
- Capacitor: update 2.4.0
- Fix Android sqlite3_close issue#36
- Publish from 2.3.0-beta3
- Rewrite the iOS Plugin to pass through SwiftLint
- Fix iOS issues due to the move to capacitor-community
- add API documentation
- modify ImportExportJson documentation
- Fix podspec file name
- give the ownership to capacitor-community
- rename the plugin from capacitor-sqlite to sqlite
- Capacitor: update 2.3.0
- Fix issue#31 Android query value array types MUST be an Array
- Fix issue#29 iOS exportToJson converting zero and empty string values to "NULL"
- Capacitor: update 2.2.1
- Fix return changes in IOS plugin when FOREIGN KEY and ON DELETE CASCADE
- Improve the readme
- Fix issue#26, issue#27 in IOS plugin If an insert query fails, all subsequent database commands fail
- Fix in IOS plugin the changes return in Run method (ON DELETE CASCADE)
- add Batch Execution with values (method executeSet)
- Capacitor: update 2.2.0
- Add Capitalization characters in IOS table column names issue#25
- Add import in two steps table schema & indexes and table data to importFromJson
- Fix issue#24
- Fix issue#23
- Fix issue#22 index column value
- Fix issue#22
- add FOREIGN KEY support in importFrom & exportTo Json
- Fix issue#20
- Fix issue#21
- SQLCipher: update 4.4.0
- fix issue#17 Android importFromJson inserting a large amount of data
- fix README
- capacitor: update to capacitor 2.1.0
- fix issue#16: Electron Databases get deleted with app update
- fix issue#15
- fix the readme, test-angular-jeep-capacitor-plugins link
- capacitor: update to capacitor 2.0.1
- add method IsDBExists to check if a database already exists
- add method IsJsonValid to validate the Json Object before proceeding
- add method exportToJson to download a database full or partial
- add method createSyncTable to create a synchronization table
- add method setSyncDate to store a syncronization date for partial export
- the delete database for safety issue requires now to open the database first
- add upload of image (base64 string) to the database
- add the management of NULL in the importFromJson method a NULL value as to be given with the "NULL" string
- add the lastId returned by the run method changes is now a JSON object {changes:number,lastId:number}
- add the transaction (begin and commit) to the run method
- fix the changes return by the execute method
- add importFromJson method to IOS Platform
- add importFromJson method to Android Platform
- add importFromJson method to Electron Platform
- Fix issue#6 commands return -1 when failure
- capacitor: update to capacitor 2.0.0
- android: update to androidX
- add a .gitignore file
- Add Electron Plugin based on sqlite3. Works only for non-encrypted databases
- capacitor: update to capacitor 1.5.2
- Fix Cursor not close in Android plugin
- fix README link to applications
- fix Plugin Name as CapacitorSQLite
- fix interface PluginRegistry
- Undeprecating the npm package to allow user to load only this capacitor plugin in there applications (advise by the Ionic Capacitor team)
- @capacitor/cli: update to 1.5.1
- @capacitor/core: update to 1.5.1
- @capacitor/ios: update to 1.5.1
- @capacitor/android: update to 1.5.1