Native interface to SQLite for PhoneGap/Cordova - cordova-sqlite-storage plugin version. 

Native interface to SQLite for PhoneGap / Cordova - cordova-sqlite-storage plugin version

brodybits

cordova-sqlite-storage

Native interface to SQLite for PhoneGap/Cordova - cordova-sqlite-storage plugin version

Error

Ignore

Warn

License

Maintenance

Miscellaneous

Quality

Supply chain risk

Vulnerability

Admins only

Organization members

Dashboard

<upgradeLink>Upgrade</upgradeLink> to access this feature

About

Blog

Socket CLI

Customers

Socket Dependency Search

Docs

Socket for GitHub

Love

Impersonation Mode Active

Update your browser to the latest version for the best experience.

Your web browser is outdated

Use another browser for the best experience.

Your web browser is unsupported

{{count, number}} commits last two months

{{count, number}} critical severity alert

{{count, number}} critical severity alerts

{{count, number}} dependency vulnerability

{{count, number}} dependency vulnerabilities

{{count, number}} development dependencies

{{count, number}} transitive dependencies

{{count, number}} version published last month

{{count, number}} versions published last month

{{count, number}} version published in last two months

{{count, number}} versions published in last two months

{{count, number}} version published last week

{{count, number}} versions published last week

{{count, number}} version published last year

{{count, number}} versions published last year

Socket undergoes annual SOC2 Type II audits. Socket customers can request a copy of the full SOC2 Type II report.

Allows organization owners and admins to access detailed records of actions taken by members of their organization, complete with timestamps.

Prevent compromised packages from infiltrating your supply chain by monitoring for changes in real-time.

Join our Discord community to get help from Socket engineers and other Socket users.

Compare millions of open source packages on socket.dev

Detect malicious code and risky behavior (e.g. network) in your dependencies using "deep package inspection"

All data is encrypted in transit and at rest using industry standard encryption algorithms.

Get a dedicated Socket account manager and access to Socket’s Customer Success team.

Get dedicated support from Socket engineers via email and Slack.

"Shift left" with the Socket Chrome extension and give intervene early, before developers choose risky or low quality dependencies.

Catch developers using risky dependencies and give them a "speed bump" to encourage good behavior

Install the Socket GitHub app to receive real-time dependency scanning and reports with every pull request.

Integrate Socket into your GitHub SCM to prevent risky dependencies from being installed.

Socket scans for vulnerabilities in your dependencies, including CVEs, security advisories, and more.

Socket supports dependencies in many languages, with most popular ecosystems coming in 2024. We've got you covered no matter what languages you use.

Enforce license policies across your organization

Receive a Microsoft Teams message to the channel of your choice anytime Socket runs a new analysis, has a new finding, or a policy has changed.

Get help migrating from Socket's free plan to Socket's paid plans.

Run Socket on-premises or in your own cloud environment.

Query for any dependency (at any version) across your entire organization

Integrate Socket into your CI/CD pipeline to prevent risky dependencies from being deployed to production.

Analyze an entire project to find supply chain risks

Tag projects to organize and filter your projects

Restrict access based on the roles of individual users within an organization.

Receive a Slack message to the channel of your choice anytime Socket runs a new analysis, has a new finding, or a policy has changed.

Socket is SOC2 Type II compliant and undergoes annual audits.

The Socket CLI allows teams to prevent risky dependencies from being installed, and to get dependency insights from the command line.

Socket supports SAML SSO for single sign-on and identity management.

Integrate Socket into your VS Code IDE to prevent risky dependencies from being installed.

Get a POST request anytime Socket runs a new analysis, has a new finding, or a policy has changed.

Socket will analyzed your SBOMs up to a maximum number of dependencies.

API that allows you to analyze a project, lookup package scores and alerts, and more.

Create API tokens to authenticate with the Socket API and CLI.

The number of developers in your team. A developer is someone who made a commit to your organization's repositories scanned by Socket in the past month.

Use Socket to protect your private repositories.

Socket is always free for open source projects.

Socket retains all reporting data for 3 months, 1 year, or a custom term of your choice.

Access the threat feed that powers Socket.

Unlimited scale, self-hosting, and priority support for large teams.

For open-source projects, individuals, and small teams.

For growing teams with enhanced scale, security, and support.

There is a package with a similar name that is downloaded much more often.

There are packages with similar names that are downloaded much more often.

This may not be the package you want!

Instance

Alert Locations

Package

The {{ecosystem}} package {{- packageName}} receives a total of <strong>{{numWeeklyDownloadCount, number}}</strong> weekly downloads. As such, {{- packageName}} popularity was classified as <strong>{{popularity}}</strong>.

Is {{- packageName}} popular?

Is {{- packageName}} safe to use?

Is {{- packageName}} well maintained?

What is {{- packageName}}?

{{packageDescription}}Version: {{versionString}} was published by {{publisherName}}. Start using Socket to analyze {{- packageName}} and its {{dependencyCount, number}} dependencies to secure your app from supply chain attacks.

Sorry, it seems this package was removed from the registry

Package was removed

This package version has been unpublished, mostly likely due to security reasons

Package version was removed

Provide a detailed description of the malware...

Socket fights vulnerabilities and provides visibility, defense-in-depth, and proactive supply chain protection for JavaScript, Python, and Go dependencies.

Socket - Secure your dependencies. Ship with confidence.

Compare versions

{{- packageName}} - npm Package Compare versions

- cordova-sqlite-storage-dependencies@2.0.1 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

###### cordova-sqlite-ext-common-core 0.2.0

- 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-WinRT` component to `src/windows/SQLite3-WinRT-sync` and update `plugin.xml`

##### cordova-sqlite-ext-common-core 0.1.0

###### cordova-sqlite-ext-core-common 0.1.0

  - 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

###### cordova-sqlite-storage-ext-core-common 2.0.0

- 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 (<https://github.com/litehelpers/Cordova-sqlite-storage/issues/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

- Quick fix for some iOS/macOS internal plugin error log messagess

- Mark some Android errors as internal plugin errors (quick fix)

- remove trailing whitespace from Android implementation

- Mark some iOS/macOS plugin error messages as internal plugin errors (quick fix)

- Use SQLite 3.22.0 with SQLITE_DEFAULT_SYNCHRONOUS=3 (EXTRA DURABLE) compile-time setting on all platforms (Android/iOS/macOS/Windows) ref: litehelpers/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

  "description": "Native interface to SQLite for PhoneGap/Cordova - cordova-sqlite-storage plugin version",

    "url": "https://github.com/xpbrew/cordova-sqlite-storage.git"

    "url": "https://github.com/xpbrew/cordova-sqlite-storage/issues"

  "homepage": "https://github.com/xpbrew/cordova-sqlite-storage",

    "cordova-sqlite-storage-dependencies": "2.0.0"

    "cordova-sqlite-storage-dependencies": "2.0.1"

    "clean-spec": "rm -rf spec/[mnp]* && git cl spec/config.xml && git st",

    "clean-spec": "rm -rf spec/[mnp]* && git cl spec/config.xml && git status --ignored",

    "prepare-js": "coffee -p SQLitePlugin.coffee.md > www/SQLitePlugin.js",

    "prepare-spec": "node scripts/prepareSpec.js"

// NOTE: DEFAULT_SIZE wanted depends on type of browser

var isWindows = /MSAppHost/.test(navigator.userAgent);

var isAndroid = !isWindows && /Android/.test(navigator.userAgent);

var isFirefox = /Firefox/.test(navigator.userAgent);

var isWebKitBrowser = !isWindows && !isAndroid && /Safari/.test(navigator.userAgent);

var isBrowser = isWebKitBrowser || isFirefox;

var isEdgeBrowser = isBrowser && (/Edge/.test(navigator.userAgent));

var isChromeBrowser = isBrowser && !isEdgeBrowser && (/Chrome/.test(navigator.userAgent));

var isSafariBrowser = isWebKitBrowser && !isEdgeBrowser && !isChromeBrowser;

// should avoid popups (Safari seems to count 2x)

var DEFAULT_SIZE = isSafariBrowser ? 2000000 : 5000000;

// FUTURE TBD: 50MB should be OK on Chrome and some other test browsers.

// The following openDatabase settings are used for Plugin-implementation-2

  isAndroid ? 'Plugin-implementation-default' : 'Plugin',

var scenarioCount = (!!window.hasWebKitWebSQL) ? (isAndroid ? 3 : 2) : 1;

    // TBD skip plugin test on browser platform (not yet supported):

    if (isBrowser && (i === 0)) continue;

    describe(scenarioList[i] + ': sqlite version test(s)', function() {

      var scenarioName = scenarioList[i];

      var suiteName = scenarioName + ': ';

      // NOTE 1: MUST be defined in proper describe function scope, NOT outer scope.

      // NOTE 2: Using same database name in this script to avoid creating extra,

      //         unneeded database files.

      var openDatabase = function(name_ignored, ignored1, ignored2, ignored3) {

        var name = 'sqlite-version-test.db';

          return window.sqlitePlugin.openDatabase({

            // prevent reuse of database from default db implementation:

            androidDatabaseImplementation: 2,

          return window.openDatabase(name, "1.0", "Demo", DEFAULT_SIZE);

          return window.sqlitePlugin.openDatabase({name: name, location: 'default'});

      describe(suiteName + 'basic sqlite version test(s)', function() {

        it(suiteName + 'Check sqlite version correctly matches pattern', function(done) {

          var db = openDatabase("check-sqlite-version-matches-pattern.db", "1.0", "Demo", DEFAULT_SIZE);

            tx.executeSql('SELECT SQLITE_VERSION() AS myResult', [], function(tx_ignored, rs) {

              expect(rs.rows).toBeDefined();

              expect(rs.rows.length).toBe(1);

              expect(rs.rows.item(0).myResult).toMatch(/3\.[0-9]+\.[0-9]+/);

              // Close (plugin only) & finish:

              (isWebSql) ? done() : db.close(done, done);

            expect(error.message).toBe('--');

        it(suiteName + 'Check actual sqlite version', function(done) {

          if (isWebSql) pending('NOT DETERMINISTIC for (WebKit) Web SQL');

          if (!isWebSql && isAndroid && isImpl2) pending('NOT DETERMINISTIC for plugin on Android with androidDatabaseImplementation: 2');

          var db = openDatabase("check-actual-sqlite-version.db", "1.0", "Demo", DEFAULT_SIZE);

              expect(rs.rows.item(0).myResult).toBe('3.26.0');

		# Changes

		#### cordova-sqlite-storage 3.2.1

		- cordova-sqlite-storage-dependencies@2.0.1 with SQLite 3.28.0 update for all supported platforms Android/iOS/macOS/Windows

		#### cordova-sqlite-storage 3.2.0
		@@ -4,0 +8,0 @@

		{
		"name": "cordova-sqlite-storage",
		"version": "3.2.0",
		"version": "3.2.1",
		"description": "Native interface to SQLite for PhoneGap/Cordova - cordova-sqlite-storage plugin version",
		@@ -33,6 +33,6 @@ "cordova": {
		"dependencies": {
		"cordova-sqlite-storage-dependencies": "2.0.0"
		"cordova-sqlite-storage-dependencies": "2.0.1"
		},
		"scripts": {
		"clean-spec": "rm -rf spec/[mnp]* && git cl spec/config.xml && git st",
		"clean-spec": "rm -rf spec/[mnp]* && git cl spec/config.xml && git status --ignored",
		"prepare-js": "coffee -p SQLitePlugin.coffee.md > www/SQLitePlugin.js",
		@@ -44,4 +44,4 @@ "prepare-spec": "node scripts/prepareSpec.js"
		"cross-spawn": "^6.0.5",
		"fs-extra": "^7.0.1"
		"fs-extra": "^8.1.0"
		}
		}

		@@ -107,3 +107,3 @@ /* 'use strict'; */
		expect(rs.rows.length).toBe(1);
		expect(rs.rows.item(0).myResult).toBe('3.26.0');
		expect(rs.rows.item(0).myResult).toBe('3.28.0');

		@@ -110,0 +110,0 @@ // Close (plugin only) & finish:

Improved metrics

Dependency changes