Registry / database / modelar-sqlite-adapter

modelar-sqlite-adapter

library3.1.0jsnpmunverified

A database adapter that connects the Modelar ORM to SQLite databases using node-sqlite3. Currently at version 3.1.0, it supports Node.js >=4.0 and ships TypeScript definitions. It wraps the sqlite3 native binding and requires node-pre-gyp for installation. Allows switching between SQLite and other databases via Modelar's adapter system. Key differentiator: seamless integration with Modelar's chainable query builder and migration tools, while retaining full SQLite-specific features.

database

npm install modelar-sqlite-adapter

github ↗package ↗homepage ↗

INSTALL

IMPORT

SIG · MODELAR-SQLITE-ADA

modelar-sqlite-adapter

databasejavascriptv3.1.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.

SqliteAdapter

✓ const { SqliteAdapter } = require('modelar-sqlite-adapter')

✗ import { SqliteAdapter } from 'modelar-sqlite-adapter'

Package does not ship ESM; must use CommonJS require. TypeScript types may allow import syntax but runtime will fail if module resolution is not compatible.

SqliteAdapter (ESM Workaround)

✓ const SqliteAdapter = require('modelar-sqlite-adapter').SqliteAdapter

✗ import SqliteAdapter from 'modelar-sqlite-adapter'

No default export; destructure or use .SqliteAdapter property. ESM imports will not work directly.

DB (from modelar)

✓ const { DB } = require('modelar')

✗ import { DB } from 'modelar'

Modelar also uses CommonJS. Use require() for consistency.

Shows how to register the SqliteAdapter, initialize a SQLite database, and execute a simple query using Modelar's DB class.

const { DB } = require('modelar'); const { SqliteAdapter } = require('modelar-sqlite-adapter'); // Register the adapter DB.setAdapter('sqlite', SqliteAdapter); // Initialize database connection DB.init({ type: 'sqlite', database: './mydb.sqlite' }); // Use the database const db = new DB(); db.table('users').where('id', 1).get().then(row => { console.log(row); }).catch(err => { console.error(err); });

Debug

Known issues

breakingRequires node-pre-gyp to be installed globally (npm i -g node-pre-gyp) before installing this package; otherwise installation fails.

fix

Install node-pre-gyp globally: npm install -g node-pre-gyp, then retry npm install.

affects: >=0.0.0

gotchaThis adapter does not support ESM imports; using import will cause a runtime error or undefined due to CJS-only module format.

fix

Use CommonJS require() instead of ES import; e.g., const { SqliteAdapter } = require('modelar-sqlite-adapter').

affects: >=0.0.0

gotchaThe sqlite3 native binary must be compiled for your platform during installation; pre-built binaries may not be available for all Node.js versions, causing installation to fail.

fix

Ensure you have build tools installed (e.g., python, make, gcc). For Windows, install windows-build-tools.

affects: >=0.0.0

deprecatedNode.js >=4.0 is very outdated; the package may not work correctly on modern Node.js versions due to native addon ABI changes.

fix

Consider using an alternative SQLite adapter for Modelar or updating to a newer ORM that supports modern Node.js versions.

affects: >=0.0.0

Errors

Common errors & fixes

Error: Cannot find module 'modelar-sqlite-adapter'

Package not installed or missing from node_modules.

fix

Run npm install modelar-sqlite-adapter --save

TypeError: SqliteAdapter is not a constructor

Incorrect import: using SqliteAdapter directly instead of destructuring or accessing .SqliteAdapter.

fix

Use: const { SqliteAdapter } = require('modelar-sqlite-adapter');

Error: Cannot find module 'node-pre-gyp'

node-pre-gyp is not installed globally, required by sqlite3 installation.

fix

Install node-pre-gyp globally: npm install -g node-pre-gyp

Error: The specified module could not be found. \\?\\...\\node_sqlite3.node'

Native sqlite3 binary is missing or incompatible with platform/Node.js version.

fix

Rebuild native modules: npm rebuild sqlite3. Or reinstall with npm install --build-from-source.

Upgrade

Version history

3.1.0latest on npm

Audit

Dependencies

modelarrequiredCore ORM library that this adapter extends; must be used together.

sqlite3requiredNative SQLite bindings; this adapter wraps sqlite3 for the Modelar ORM.

Agent activity

10 hits · last 30 days

node

Amazon

Resources

githubhttps://github.com/hyurl/modelar-sqlite-adapter ↗

packagemodelar-sqlite-adapter ↗

homepagehttps://github.com/hyurl/modelar-sqlite-adapter#readme ↗