@capacitor-community/sqlite - npm Package Compare versions

Comparing version 6.0.0 to 6.0.1-dev.094dcaf.1724913257

package.json

 {
   "name": "@capacitor-community/sqlite",
-  "version": "6.0.0",
+  "version": "6.0.1-dev.094dcaf.1724913257",
   "description": "Community plugin for native & electron SQLite databases",
@@ -5,0 +5,0 @@ "main": "dist/plugin.cjs.js",

README.md

@@ -5,26 +5,2 @@ <p align="center"><br><img src="https://user-images.githubusercontent.com/236501/85893648-1c92e880-b7a8-11ea-926d-95355b8175c7.png" width="128" height="128" /></p>
 <br>
-<p align="center" style="font-size:50px;color:red"><strong>CAPACITOR 6</strong></p><br>
-<br>
-<!-- Note from the Owner - Start -->
-<p align="center" style="font-size:50px;color:red"><strong>Note from the Owner</strong></p>
-<!-- Note from the Owner - End -->
-<br>
-<!-- Message below Note from the Owner - Start -->
-<p align="left" style="font-size:47px">Start --></p>
-<br>
-<p align="left">
-I have been dedicated to developing and maintaining this plugin for many years since the inception of Ionic Capacitor. Now, at 73+ years old, and with my MacBook Pro becoming obsolete for running Capacitor 6 for iOS, I have made the decision to cease maintenance of the plugin. If anyone wishes to take ownership of this plugin, they are welcome to do so.
-</p>
-<br>
-<p align="left">
-It has been a great honor to be part of this development journey alongside the developer community. I am grateful to see many of you following me on this path and incorporating the plugin into your applications. Your comments and suggestions have motivated me to continuously improve it.
-</p>
-<br>
-<p align="left">
-I have made this decision due to several family-related troubles that require my full attention and time. Therefore, I will not be stepping back. Thank you to all of you for your support.
-</p>
-<br>
-<p align="left" style="font-size:47px">End <--</p>
-<!-- Message below Note from the Owner - End -->
-<br>
 
@@ -39,4 +15,4 @@ <p align="center">
   <img src="https://img.shields.io/maintenance/yes/2024?style=flat-square" />
-  <a href="https://github.com/capacitor-community/sqlite/actions?query=workflow%3A%22CI%22"><img src="https://img.shields.io/github/workflow/status/capacitor-community/sqlite/CI?style=flat-square" /></a>
-  <a href="https://www.npmjs.com/package/@capacitor-community/sqlite"><img src="https://img.shields.io/npm/l/@capacitor-community/sqlite?style=flat-square" /></a>
+  <a href="https://github.com/capacitor-community/sqlite/actions?query=workflow%3A%22CI%22"><img src="https://img.shields.io/github/actions/workflow/status/capacitor-community/sqlite/ci.yml?style=flat-square" /></a>
+  <a href="https://www.npmjs.com/package/@capacitor-community/sqlite"><img src="https://img.shields.io/npm/l/@capacitor-community/sqlite?branch=master&style=flat-square" /></a>
 <br>
@@ -53,5 +29,5 @@ <a href="https://www.npmjs.com/package/@capacitor-community/sqlite"><img src="https://img.shields.io/npm/dw/@capacitor-community/sqlite?style=flat-square" /></a>
 
-| Maintainer        | GitHub                                    | Social |
-| ----------------- | ----------------------------------------- | ------ |
-| Quéau Jean Pierre | [jepiqueau](https://github.com/jepiqueau) |        |
+| Maintainer | GitHub                                    | Social                                        |
+| ---------- | ----------------------------------------- | --------------------------------------------- |
+| Robin Genz | [robingenz](https://github.com/robingenz) | [@robin_genz](https://twitter.com/robin_genz) |
 
@@ -118,3 +94,3 @@ To install:
  - [Updating to Capacitor 5](https://capacitorjs.com/docs/updating/5-0)
- - [Releases](https://github.com/capacitor-community/sqlite/blob/master/info_releases.md)
+ - [Releases](https://github.com/capacitor-community/sqlite/blob/master/docs/info_releases.md)
  - [Changelog](https://github.com/capacitor-community/sqlite/blob/master/CHANGELOG.md)
@@ -233,62 +209,62 @@ - [Issues](https://github.com/capacitor-community/sqlite/issues)
 
-| Name                        | Android | iOS | Electron | Web |
-| :-------------------------- | :------ | :-- | :------- | :-- |
-| createConnection (ReadWrite)| ✅      | ✅  | ✅        | ✅  |
-| createConnection (ReadOnly) | ✅      | ✅  | ✅        | ❌  | since 4.1.0-7
-| closeConnection (ReadWrite) | ✅      | ✅  | ✅        | ✅  |
-| closeConnection (ReadOnly)  | ✅      | ✅  | ✅        | ❌  | since 4.1.0-7
-| isConnection (ReadWrite)    | ✅      | ✅  | ✅        | ✅  |
-| isConnection (ReadOnly)     | ✅      | ✅  | ✅        | ❌  | since 4.1.0-7
-| open (non-encrypted DB)     | ✅      | ✅  | ✅        | ✅  |
-| open (encrypted DB)         | ✅      | ✅  | ✅        | ❌  |
-| close                       | ✅      | ✅  | ✅        | ✅  |
-| getUrl                      | ✅      | ✅  | ❌        | ❌  |
-| getVersion                  | ✅      | ✅  | ✅        | ✅  |
-| execute                     | ✅      | ✅  | ✅        | ✅  |
-| executeSet                  | ✅      | ✅  | ✅        | ✅  |
-| run                         | ✅      | ✅  | ✅        | ✅  |
-| query                       | ✅      | ✅  | ✅        | ✅  |
-| deleteDatabase              | ✅      | ✅  | ✅        | ✅  |
-| importFromJson              | ✅      | ✅  | ✅        | ✅  |
-| exportToJson                | ✅      | ✅  | ✅        | ✅  |
-| deleteExportedRows          | ✅      | ✅  | ✅        | ✅  |
-| createSyncTable             | ✅      | ✅  | ✅        | ✅  |
-| setSyncDate                 | ✅      | ✅  | ✅        | ✅  |
-| getSyncDate                 | ✅      | ✅  | ✅        | ✅  |
-| isJsonValid                 | ✅      | ✅  | ✅        | ✅  |
-| isDBExists                  | ✅      | ✅  | ✅        | ✅  |
-| addUpgradeStatement         | ✅      | ✅  | ✅        | ✅  | Modified 4.1.0-6
-| copyFromAssets              | ✅      | ✅  | ✅        | ✅  |
-| isDBOpen                    | ✅      | ✅  | ✅        | ✅  |
-| isDatabase                  | ✅      | ✅  | ✅        | ✅  |
-| isTableExists               | ✅      | ✅  | ✅        | ✅  |
-| getTableList                | ✅      | ✅  | ✅        | ✅  |
-| getDatabaseList             | ✅      | ✅  | ✅        | ✅  |
-| getMigratableDbList         | ✅      | ✅  | ❌        | ❌  |
-| addSQLiteSuffix             | ✅      | ✅  | ❌        | ❌  |
-| deleteOldDatabases          | ✅      | ✅  | ❌        | ❌  |
-| moveDatabasesAndAddSuffix   | ✅      | ✅  | ❌        | ❌  |
-| checkConnectionsConsistency | ✅      | ✅  | ✅        | ✅  |
-| isSecretStored              | ✅      | ✅  | ✅        | ❌  |
-| setEncryptionSecret         | ✅      | ✅  | ✅        | ❌  |
-| changeEncryptionSecret      | ✅      | ✅  | ✅        | ❌  |
-| clearEncryptionSecret       | ✅      | ✅  | ✅        | ❌  |
-| checkEncryptionSecret       | ✅      | ✅  | ✅        | ❌  |
-| initWebStore                | ❌      | ❌  | ❌        | ✅  |
-| saveToStore                 | ❌      | ❌  | ❌        | ✅  |
-| getNCDatabasePath           | ✅      | ✅  | ❌        | ❌  |
-| createNCConnection          | ✅      | ✅  | ❌        | ❌  |
-| closeNCConnection           | ✅      | ✅  | ❌        | ❌  |
-| isNCDatabase                | ✅      | ✅  | ❌        | ❌  |
-| transaction                 | ✅      | ✅  | ✅        | ✅  |
-| getFromHTTPRequest          | ✅      | ✅  | ✅        | ✅  | since 4.2.0
-| isDatabaseEncrypted         | ✅      | ✅  | ✅        | ❌  | since 4.6.2-2
-| isInConfigEncryption        | ✅      | ✅  | ✅        | ❌  | since 4.6.2-2
-| isInConfigBiometricAuth     | ✅      | ✅  | ❌        | ❌  | since 4.6.2-2
-| getFromLocalDiskToStore     | ❌      | ❌  | ❌        | ✅  | since 4.6.3
-| saveToLocalDisk             | ❌      | ❌  | ❌        | ✅  | since 4.6.3
-| beginTransaction            | ✅      | ✅  | ✅        | ✅  | since 5.0.7
-| commitTransaction           | ✅      | ✅  | ✅        | ✅  | since 5.0.7
-| rollbackTransaction         | ✅      | ✅  | ✅        | ✅  | since 5.0.7
-| isTransactionActive         | ✅      | ✅  | ✅        | ✅  | since 5.0.7
+| Name                         | Android | iOS  | Electron | Web  |
+| :--------------------------- | :------ | :--- | :------- | :--- |
+| createConnection (ReadWrite) | ✅       | ✅    | ✅        | ✅    |
+| createConnection (ReadOnly)  | ✅       | ✅    | ✅        | ❌    | since 4.1.0-7    |
+| closeConnection (ReadWrite)  | ✅       | ✅    | ✅        | ✅    |
+| closeConnection (ReadOnly)   | ✅       | ✅    | ✅        | ❌    | since 4.1.0-7    |
+| isConnection (ReadWrite)     | ✅       | ✅    | ✅        | ✅    |
+| isConnection (ReadOnly)      | ✅       | ✅    | ✅        | ❌    | since 4.1.0-7    |
+| open (non-encrypted DB)      | ✅       | ✅    | ✅        | ✅    |
+| open (encrypted DB)          | ✅       | ✅    | ✅        | ❌    |
+| close                        | ✅       | ✅    | ✅        | ✅    |
+| getUrl                       | ✅       | ✅    | ❌        | ❌    |
+| getVersion                   | ✅       | ✅    | ✅        | ✅    |
+| execute                      | ✅       | ✅    | ✅        | ✅    |
+| executeSet                   | ✅       | ✅    | ✅        | ✅    |
+| run                          | ✅       | ✅    | ✅        | ✅    |
+| query                        | ✅       | ✅    | ✅        | ✅    |
+| deleteDatabase               | ✅       | ✅    | ✅        | ✅    |
+| importFromJson               | ✅       | ✅    | ✅        | ✅    |
+| exportToJson                 | ✅       | ✅    | ✅        | ✅    |
+| deleteExportedRows           | ✅       | ✅    | ✅        | ✅    |
+| createSyncTable              | ✅       | ✅    | ✅        | ✅    |
+| setSyncDate                  | ✅       | ✅    | ✅        | ✅    |
+| getSyncDate                  | ✅       | ✅    | ✅        | ✅    |
+| isJsonValid                  | ✅       | ✅    | ✅        | ✅    |
+| isDBExists                   | ✅       | ✅    | ✅        | ✅    |
+| addUpgradeStatement          | ✅       | ✅    | ✅        | ✅    | Modified 4.1.0-6 |
+| copyFromAssets               | ✅       | ✅    | ✅        | ✅    |
+| isDBOpen                     | ✅       | ✅    | ✅        | ✅    |
+| isDatabase                   | ✅       | ✅    | ✅        | ✅    |
+| isTableExists                | ✅       | ✅    | ✅        | ✅    |
+| getTableList                 | ✅       | ✅    | ✅        | ✅    |
+| getDatabaseList              | ✅       | ✅    | ✅        | ✅    |
+| getMigratableDbList          | ✅       | ✅    | ❌        | ❌    |
+| addSQLiteSuffix              | ✅       | ✅    | ❌        | ❌    |
+| deleteOldDatabases           | ✅       | ✅    | ❌        | ❌    |
+| moveDatabasesAndAddSuffix    | ✅       | ✅    | ❌        | ❌    |
+| checkConnectionsConsistency  | ✅       | ✅    | ✅        | ✅    |
+| isSecretStored               | ✅       | ✅    | ✅        | ❌    |
+| setEncryptionSecret          | ✅       | ✅    | ✅        | ❌    |
+| changeEncryptionSecret       | ✅       | ✅    | ✅        | ❌    |
+| clearEncryptionSecret        | ✅       | ✅    | ✅        | ❌    |
+| checkEncryptionSecret        | ✅       | ✅    | ✅        | ❌    |
+| initWebStore                 | ❌       | ❌    | ❌        | ✅    |
+| saveToStore                  | ❌       | ❌    | ❌        | ✅    |
+| getNCDatabasePath            | ✅       | ✅    | ❌        | ❌    |
+| createNCConnection           | ✅       | ✅    | ❌        | ❌    |
+| closeNCConnection            | ✅       | ✅    | ❌        | ❌    |
+| isNCDatabase                 | ✅       | ✅    | ❌        | ❌    |
+| transaction                  | ✅       | ✅    | ✅        | ✅    |
+| getFromHTTPRequest           | ✅       | ✅    | ✅        | ✅    | since 4.2.0      |
+| isDatabaseEncrypted          | ✅       | ✅    | ✅        | ❌    | since 4.6.2-2    |
+| isInConfigEncryption         | ✅       | ✅    | ✅        | ❌    | since 4.6.2-2    |
+| isInConfigBiometricAuth      | ✅       | ✅    | ❌        | ❌    | since 4.6.2-2    |
+| getFromLocalDiskToStore      | ❌       | ❌    | ❌        | ✅    | since 4.6.3      |
+| saveToLocalDisk              | ❌       | ❌    | ❌        | ✅    | since 4.6.3      |
+| beginTransaction             | ✅       | ✅    | ✅        | ✅    | since 5.0.7      |
+| commitTransaction            | ✅       | ✅    | ✅        | ✅    | since 5.0.7      |
+| rollbackTransaction          | ✅       | ✅    | ✅        | ✅    | since 5.0.7      |
+| isTransactionActive          | ✅       | ✅    | ✅        | ✅    | since 5.0.7      |
 
@@ -295,0 +271,0 @@

src/definitions.ts

@@ -1140,3 +1140,3 @@ //import { Capacitor } from '@capacitor/core';
    * @param database
-   * @param upgrade @since 5.6.4 
+   * @param upgrade @since 5.6.4
    * @returns Promise<void>
@@ -1147,3 +1147,3 @@ * @since 2.9.0 refactor
     database: string,
-    upgrade: capSQLiteVersionUpgrade[]
+    upgrade: capSQLiteVersionUpgrade[],
   ): Promise<void>;
@@ -1462,3 +1462,3 @@ /**
     database: string,
-    upgrade: capSQLiteVersionUpgrade[]
+    upgrade: capSQLiteVersionUpgrade[],
   ): Promise<void> {
@@ -2414,9 +2414,7 @@ try {
       if (!isActive) {
-        return Promise.reject(
-          'After Begin Transaction, no transaction active',
-        );
+        return Promise.reject('After Begin Transaction, no transaction active');
       }
       try {
         for (const task of txn) {
-          if(typeof task !== 'object' || !('statement' in task)) {
+          if (typeof task !== 'object' || !('statement' in task)) {
             throw new Error('Error a task.statement must be provided');
@@ -2423,0 +2421,0 @@ }

src/web.ts

@@ -48,43 +48,43 @@ import { WebPlugin } from '@capacitor/core';
   async initWebStore(): Promise<void> {
-     await customElements.whenDefined('jeep-sqlite')
+    await customElements.whenDefined('jeep-sqlite');
 
-      this.jeepSqliteElement = document.querySelector('jeep-sqlite');
-      this.ensureJeepSqliteIsAvailable();
+    this.jeepSqliteElement = document.querySelector('jeep-sqlite');
+    this.ensureJeepSqliteIsAvailable();
 
-      this.jeepSqliteElement.addEventListener(
-        'jeepSqliteImportProgress',
-        (event: CustomEvent) => {
-          this.notifyListeners('sqliteImportProgressEvent', event.detail);
-        },
-      );
-      this.jeepSqliteElement.addEventListener(
-        'jeepSqliteExportProgress',
-        (event: CustomEvent) => {
-          this.notifyListeners('sqliteExportProgressEvent', event.detail);
-        },
-      );
-      this.jeepSqliteElement.addEventListener(
-        'jeepSqliteHTTPRequestEnded',
-        (event: CustomEvent) => {
-          this.notifyListeners('sqliteHTTPRequestEndedEvent', event.detail);
-        },
-      );
-      this.jeepSqliteElement.addEventListener(
-        'jeepSqlitePickDatabaseEnded',
-        (event: CustomEvent) => {
-          this.notifyListeners('sqlitePickDatabaseEndedEvent', event.detail);
-        },
-      );
-      this.jeepSqliteElement.addEventListener(
-        'jeepSqliteSaveDatabaseToDisk',
-        (event: CustomEvent) => {
-          this.notifyListeners('sqliteSaveDatabaseToDiskEvent', event.detail);
-        },
-      );
+    this.jeepSqliteElement.addEventListener(
+      'jeepSqliteImportProgress',
+      (event: CustomEvent) => {
+        this.notifyListeners('sqliteImportProgressEvent', event.detail);
+      },
+    );
+    this.jeepSqliteElement.addEventListener(
+      'jeepSqliteExportProgress',
+      (event: CustomEvent) => {
+        this.notifyListeners('sqliteExportProgressEvent', event.detail);
+      },
+    );
+    this.jeepSqliteElement.addEventListener(
+      'jeepSqliteHTTPRequestEnded',
+      (event: CustomEvent) => {
+        this.notifyListeners('sqliteHTTPRequestEndedEvent', event.detail);
+      },
+    );
+    this.jeepSqliteElement.addEventListener(
+      'jeepSqlitePickDatabaseEnded',
+      (event: CustomEvent) => {
+        this.notifyListeners('sqlitePickDatabaseEndedEvent', event.detail);
+      },
+    );
+    this.jeepSqliteElement.addEventListener(
+      'jeepSqliteSaveDatabaseToDisk',
+      (event: CustomEvent) => {
+        this.notifyListeners('sqliteSaveDatabaseToDiskEvent', event.detail);
+      },
+    );
 
-      if (!this.isWebStoreOpen) {
-        this.isWebStoreOpen = await this.jeepSqliteElement.isStoreOpen();
-      }
+    if (!this.isWebStoreOpen) {
+      this.isWebStoreOpen = await this.jeepSqliteElement.isStoreOpen();
+    }
 
-      return;
+    return;
   }
@@ -208,3 +208,2 @@
     }
-
   }
@@ -290,3 +289,2 @@ async beginTransaction(options: capSQLiteOptions): Promise<capSQLiteChanges> {
     }
-
   }
@@ -561,3 +559,2 @@
 
-
   ////////////////////////////////////
@@ -564,0 +561,0 @@ ////// UNIMPLEMENTED METHODS

New alerts

New author

Supply chain risk

A new npm collaborator published a version of the package for the first time. New collaborators are usually benign additions to a project, but do indicate a change to the security surface area of a package.

Found 1 instance in 1 package

No v1

Quality

Package is not semver >=1. This means it is not stable and does not support ^ ranges.

Found 1 instance in 1 package

Worsened metrics

Total package byte prevSize

2055943

-0.05%

Number of low quality alerts

3

50%

Number of lines in readme file

429

-5.3%

Number of medium supply chain risk alerts

1

Infinity%

No dependency changes