Registry / database / jsharmony-db-sqlite

jsharmony-db-sqlite

JSON →
library1.14.0jsnpmunverified

A database connector for SQLite within the jsHarmony framework, version 1.14.0. It provides a driver that integrates with jsharmony-db to enable SQLite database operations. The library wraps the sqlite3 package and supports parameterized queries with types. Release cadence is irregular; no recent updates. Key differentiator: seamless integration with jsHarmony's Recordset API and typed parameters.

database
npm install jsharmony-db-sqlite
github ↗package ↗homepage ↗
INSTALL
IMPORT
SIG · JSHARMONY-DB-SQLIT
J
jsharmony-db-sqlite
databasejavascriptv1.14.0
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.

JSHsqlite
✓ const JSHsqlite = require('jsharmony-db-sqlite')
✗ import JSHsqlite from 'jsharmony-db-sqlite'
This package is CJS-only; ESM import is not supported.
JSHdb
✓ const JSHdb = require('jsharmony-db')
You must also install jsharmony-db separately.
JSHdb.types
✓ const { types } = require('jsharmony-db')
✗ const types = require('jsharmony-db').types
Alternative destructured import works but not recommended by the library.

Create an in-memory SQLite database, run a parameterized query, and log the result.

const JSHsqlite = require('jsharmony-db-sqlite'); const JSHdb = require('jsharmony-db'); const dbconfig = { _driver: new JSHsqlite(), filename: ':memory:' }; const db = new JSHdb(dbconfig); db.Recordset('', 'select ? as hello', [JSHdb.types.String], { '?': 'world' }, (err, rslt) => { if (err) console.error(err); else console.log(rslt); });
Debug
Known issues
gotchaThe package is not compatible with Promises or async/await; all operations use callbacks.
fix
Wrap calls in a Promise manually.
affects: *
gotchaThe DB filename must be absolute or ':memory:'; relative paths may fail silently.
fix
Always provide an absolute path or use ':memory:'.
affects: *
deprecatedThe sqlite3 package version is not pinned; newer versions may break compatibility.
fix
Pin sqlite3 to 5.x in your package.json.
affects: >=1.0.0
Errors
Common errors & fixes
Cannot find module 'jsharmony-db'
jsharmony-db is not installed or not in node_modules
fix
npm install jsharmony-db --save
TypeError: JSHdb is not a constructor
Using incorrect import or older version of jsharmony-db
fix
Ensure jsharmony-db is version 1.x and imported correctly: const JSHdb = require('jsharmony-db')
Upgrade
Version history
1.14.0latest on npm
Audit
Dependencies
jsharmony-dbrequiredRequired for the JSHdb constructor and type definitions
sqlite3requiredUnderlying SQLite driver
Agent activity
11 hits · last 30 days
node
10
Resources
githubhttps://github.com/apHarmony/jsharmony-db-sqlite ↗
packagejsharmony-db-sqlite ↗
homepagehttps://github.com/apHarmony/jsharmony-db-sqlite ↗
jsharmony-db-sqlite — npm install jsharmony-db-sqlite · libregistry