Registry / database / cordova-sqlite-evcore-extbuild-free

cordova-sqlite-evcore-extbuild-free

library0.19.1jsnpmunverified

Cordova/PhoneGap SQLite plugin (v0.19.1) based on HTML5 Web SQL API for Android, iOS, macOS, and Windows 10. Uses a custom Android NDK C-language SQLite library with performance improvements and reduced memory footprint. Licensed under GPL v3 or commercial. Known for multiple SQLite corruption issues and upcoming breaking changes (error codes become 0, location values 0-2 deprecated). Unlike MIT-licensed alternatives, this emphasizes enterprise-grade Android performance.

database

npm install cordova-sqlite-evcore-extbuild-free

github ↗package ↗homepage ↗

INSTALL

IMPORT

SIG · CORDOVA-SQLITE-EVC

cordova-sqlite-evcore-extbuild-free

databasejavascriptv0.19.1

harness data pending

Install & Compatibility

Where this runs

No compatibility data collected yet for this library.

Code

Verified usage

Verified import paths — ran on the pinned version, not inferred.

sqlitePlugin

✓ var sqlitePlugin = window.sqlitePlugin;

✗ var sqlitePlugin = require('cordova-sqlite-evcore-extbuild-free');

In Cordova/browser environments, the plugin is attached to window; no import/require needed.

openDatabase

✓ var db = window.sqlitePlugin.openDatabase({name: 'test.db', location: 'default'});

✗ var db = openDatabase('test.db', '1.0', 'test', 5*1024*1024);

Cordova version does not support the HTML5 openDatabase signature; location option required.

SQLTransaction

✓ db.transaction(function(tx) { tx.executeSql('SELECT 1', [], function(tx, res) {}); });

✗ db.transaction(function(tx) { tx.executeSql('SELECT 1'); });

Callback parameters are optional but often misused; res.rows.length and res.rows.item(i) for results.

SqlResSet

✓ tx.executeSql('SELECT ?', [1], function(tx, res) { var count = res.rows.length; var item = res.rows.item(0); });

✗ tx.executeSql('SELECT 1', [], function(tx, res) { var item = res.rows[0]; });

Rows access via .item() method, not array index; standard Web SQL behavior.

Shows opening a database, creating table, inserting and selecting data using Web SQL API via Cordova plugin.

// Cordova plugin adds window.sqlitePlugin var db = window.sqlitePlugin.openDatabase({ name: 'my.db', location: 'default' }); db.transaction(function(tx) { tx.executeSql('CREATE TABLE IF NOT EXISTS test (id integer primary key, val text)'); tx.executeSql('INSERT INTO test VALUES (?,?)', [1, 'hello']); tx.executeSql('SELECT * FROM test', [], function(tx, res) { console.log('Rows: ' + res.rows.length); for (var i=0; i<res.rows.length; i++) { console.log('Row ' + i + ': ' + JSON.stringify(res.rows.item(i))); } }); }, function(err) { console.error('Transaction error: ' + err.message); }, function() { console.log('Transaction success'); });

Debug

Known issues

breakingIn upcoming major release, error code will always be 0; actual SQLite3 error code will be in message.

fix

Do not rely on error code for logic; check error.message for details.

affects: <1.0

breakingDrop support for location: 0-2 numeric values; must use 'default' or iosDatabaseLocation.

fix

Replace openDatabase({location: 0}) with {location: 'default'}.

affects: <1.0

gotchaMultiple SQLite corruption problem reported — see https://github.com/xpbrew/cordova-sqlite-storage/issues/626

fix

Ensure only one SQLite plugin is installed; avoid concurrent writes.

affects: *

gotchaandroidDatabaseImplementation: 2 setting may throw an exception or misbehave.

fix

Avoid using androidDatabaseImplementation: 2 unless necessary; use default setting.

affects: *

deprecatedWindows 10 UWP desktop-only support; ARM CPU support removed.

fix

Use Windows 10 x86/x64 only; no ARM support.

affects: >=0.19.0

gotchaThis plugin is GPL v3 licensed; commercial license required for proprietary apps.

fix

Ensure compliance with GPL v3 or obtain commercial license from litehelpers.net.

affects: *

Errors

Common errors & fixes

TypeError: Cannot read property 'openDatabase' of undefined

Plugin not installed or not loaded before script runs.

fix

Install plugin: cordova plugin add cordova-sqlite-evcore-extbuild-free; wait for deviceready event before using.

SQLitePlugin.openDatabase: location setting is required

Missing 'location' parameter in openDatabase call.

fix

Specify location: 'default' or other valid value.

undefined is not an object (evaluating 'res.rows.item')

Accessing results incorrectly using array index instead of .item() method.

fix

Use res.rows.item(i) instead of res.rows[i].

sqlite plugin not found

Plugin not added or cordova plugin variable not set.

fix

Run 'cordova plugin add cordova-sqlite-evcore-extbuild-free' and rebuild.

Upgrade

Version history

0.19.1latest on npm

Audit

Dependencies

No dependency data recorded yet.

Agent activity

13 hits · last 30 days

node

OpenAI (training)

Resources

githubhttps://github.com/storesafe/cordova-sqlite-evcore-extbuild-free ↗

packagecordova-sqlite-evcore-extbuild-free ↗

homepagehttps://github.com/storesafe/cordova-sqlite-evcore-extbuild-free ↗