- 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
latest
release 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-sqlite
with[email protected]
- added method
clearEncryptionSecret
to 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-app
application demonstrating the import/export JSON object including the new delete feature with thesql_deleted
column to synchronize local database with remote server database. -
Modify Contributor list format
- fix(executeTransaction): fix definition issue#267
- add a
sql_deleted
column on table to manage the synchronization of deleted records. Before the record was deleted when aDELETE FROM
command was issued, now the record is updated with thesql_deleted
set to 1 - add
deleteExportedRows
method to physically delete the records having thesql_deleted
set to 1, after a successful synchronization with a remote server database
- add a
sql_deleted
column on table to manage the synchronization of deleted records. Before the record was deleted when aDELETE FROM
command was issued, now the record is updated with thesql_deleted
set to 1 - add
deleteExportedRows
method to physically delete the records having thesql_deleted
set 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
importFromJson
andExportToJson
- do not execute UPDATE in
importFromJson
forpartial
mode 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.md
documentation
- iOS Query returing multiple rows - Array issue#195
!!!! DO NOT USE IT !!!!
- add
getTableList
method - add
overwrite
parameter 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.ts
for Windows and Linux
- add Electron folder databases location in the
capacitor-config.ts
first 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 jszip
in 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/databases
underpublic
folder for Vue and React frameworks
- Fix web store initialization
- Fix Electron echo method
- Add Web plugin part based on
[email protected]
and[email protected]
for 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
Library
folder 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/[email protected]
- 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/[email protected]
- 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/[email protected]
- 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/[email protected]
- 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/[email protected]
- 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/[email protected]
- add Wrappers documentation (APIConnection && APIDBConnection)
- add
isDBExists
,deleteDatabase
methods
- createConnection method
- closeConnection method
- SQLiteConnection Interface & Class
- SQLiteDBConnection Interface & Class
-
update to @capacitor/[email protected]
-
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/[email protected]
- Fix README and CHANGELOG
- update to @capacitor/[email protected]
- Fix README
- Fix setSyncDate (iOS)
- Fix exportToJson (Android)
- Fix lastId to Int64 (iOS)
- Fix issue#59 ExportToJson
- update to @capacitor/[email protected]
- 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