{"id":44694,"library":"dblink-sqlite","title":"dblink-sqlite","description":"Sqlite handler for Dblink, version 1.3.3, stable release. Provides SQLite database connection and query execution within the Dblink framework. Key differentiator: integrates seamlessly with Dblink's unified database interface for multi-database support. Release cadence is irregular. Minimal dependencies.","status":"active","version":"1.3.3","language":"javascript","source_language":"en","source_url":null,"tags":["javascript","typescript"],"install":[{"cmd":"npm install dblink-sqlite","lang":"bash","label":"npm"},{"cmd":"yarn add dblink-sqlite","lang":"bash","label":"yarn"},{"cmd":"pnpm add dblink-sqlite","lang":"bash","label":"pnpm"}],"dependencies":[],"imports":[{"note":"ESM-only package; CommonJS require will fail. Use import syntax.","wrong":"const DblinkSqlite = require('dblink-sqlite')","symbol":"DblinkSqlite","correct":"import { DblinkSqlite } from 'dblink-sqlite'"},{"note":"Default export available for convenience; still ESM-only.","wrong":"const DblinkSqlite = require('dblink-sqlite')","symbol":"default","correct":"import DblinkSqlite from 'dblink-sqlite'"},{"note":"createConnection is exported from dblink-sqlite, not dblink itself.","wrong":"import { createConnection } from 'dblink'","symbol":"createConnection","correct":"import { createConnection } from 'dblink-sqlite'"}],"quickstart":{"code":"import { DblinkSqlite } from 'dblink-sqlite';\n\nconst db = new DblinkSqlite({ filename: ':memory:' });\nawait db.connect();\nconst rows = await db.query('SELECT 1 AS test');\nconsole.log(rows);\nawait db.close();","lang":"typescript","description":"Demonstrates importing DblinkSqlite, connecting to an in-memory database, running a query, and closing the connection."},"warnings":[{"fix":"Replace require() with import or use await import() if running in CommonJS context.","message":"ESM-only package: CommonJS require() will throw. Use import syntax or dynamic import.","severity":"gotcha","affected_versions":">=1.0.0"},{"fix":"Update constructor options to use 'filename' instead of 'file'.","message":"In v1.1.0, the constructor options changed: 'file' renamed to 'filename'.","severity":"breaking","affected_versions":">=1.1.0"},{"fix":"Enable strict mode in tsconfig.json to avoid inference issues.","message":"TypeScript types are included but require 'strict' mode for full type safety.","severity":"gotcha","affected_versions":">=1.0.0"}],"env_vars":null,"search_vec":"'1.3.3':9 'cadenc':39 'connect':15 'databas':14,31,36 'dblink':2,7,21,28 'dblink-sqlit':1 'depend':43 'differenti':24 'execut':18 'framework':22 'handler':5 'integr':25 'interfac':32 'irregular':41 'javascript':44 'key':23 'minim':42 'multi':35 'multi-databas':34 'provid':12 'queri':17 'releas':11,38 'seamless':26 'sqlite':3,4,13 'stabl':10 'support':37 'typescript':45 'unifi':30 'version':8 'within':19","created_at":"2026-06-07T12:51:22.525140+00:00","updated_at":"2026-06-07T12:51:22.525140+00:00","problems":[{"fix":"Change to import statement: import { DblinkSqlite } from 'dblink-sqlite'","cause":"Using CommonJS require() with an ESM-only package.","error":"TypeError: dblink_sqlite_1.DblinkSqlite is not a constructor"},{"fix":"Run 'npm install dblink-sqlite' and ensure package.json dependency is correct.","cause":"Package not installed or typo in package name.","error":"Error: Cannot find module 'dblink-sqlite'"},{"fix":"Await db.connect() before calling db.query().","cause":"Calling query before connect() resolves.","error":"TypeError: db.query is not a function"}],"ecosystem":"npm","meta_description":null,"install_score":null,"quickstart_score":null,"quickstart_tag":null,"pypi_latest":null,"cli_name":null,"cli_version":null,"type":"library","homepage":null,"github":null,"docs":null,"changelog":null,"pypi":null,"npm":"dblink-sqlite","openapi_spec":null,"status_page":null,"smithery":null,"categories":["database"],"base_url":null,"auth_type":null,"provenance":{"verified_status":null,"verified_at":null,"last_verified":"2026-06-07","next_check":"2026-09-05","install_tag":null}}