{"_id":"@alt-javascript/jsdbc-sqlite","_rev":"3-24a07125473602ae3ae88ba5956b632d","name":"@alt-javascript/jsdbc-sqlite","dist-tags":{"latest":"1.2.0"},"versions":{"1.0.0":{"name":"@alt-javascript/jsdbc-sqlite","version":"1.0.0","keywords":["jsdbc","jdbc","database","sqlite","better-sqlite3","driver"],"author":{"name":"Craig Parravicini"},"license":"MIT","_id":"@alt-javascript/jsdbc-sqlite@1.0.0","maintainers":[{"name":"craigparra","email":"craigparra@gmail.com"}],"contributors":[{"url":"Anthropic","name":"Claude"}],"homepage":"https://github.com/alt-javascript/jsdbc/tree/main/packages/sqlite#readme","bugs":{"url":"https://github.com/alt-javascript/jsdbc/issues"},"dist":{"shasum":"aa206ba2ec17f347bfe6748b01e94ccd3844bc26","tarball":"https://registry.npmjs.org/@alt-javascript/jsdbc-sqlite/-/jsdbc-sqlite-1.0.0.tgz","fileCount":8,"integrity":"sha512-8lsonbvgOtVXZIvfr5hVXWdtysrhUzd2/QyKjxOz+jipFbMB0TJQzEM3gc3EA+3uflZ3/TdtfSQK2JRtno9OEw==","signatures":[{"sig":"MEQCIF3TPQ5Yvml6ZiRGY/3mya9dCw97EndWGjA+Tq3aJOnrAiAlJC2/z+xvobOqdVpSgyjmQAXh3KdxIBVcGWTB+0lEOw==","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":8309},"main":"index.js","type":"module","gitHead":"cb11bcfac234e6e38e0dafe1b3cd6be438404c03","scripts":{"test":"mocha --recursive test/**/*.spec.js"},"_npmUser":{"name":"craigparra","email":"craigparra@gmail.com"},"repository":{"url":"git+https://github.com/alt-javascript/jsdbc.git","type":"git","directory":"packages/sqlite"},"_npmVersion":"11.12.0","description":"JSDBC driver for SQLite via better-sqlite3","directories":{},"_nodeVersion":"24.14.0","dependencies":{"better-sqlite3":"^11.0.0","@alt-javascript/jsdbc-core":"*"},"publishConfig":{"access":"public","registry":"https://registry.npmjs.org/"},"_hasShrinkwrap":false,"devDependencies":{"chai":"^4.3.7","mocha":"^10.2.0"},"_npmOperationalInternal":{"tmp":"tmp/jsdbc-sqlite_1.0.0_1773967818983_0.6720017811652352","host":"s3://npm-registry-packages-npm-production"}},"1.1.1":{"name":"@alt-javascript/jsdbc-sqlite","version":"1.1.1","keywords":["jsdbc","jdbc","database","sqlite","better-sqlite3","driver"],"author":{"name":"Craig Parravicini"},"license":"MIT","_id":"@alt-javascript/jsdbc-sqlite@1.1.1","maintainers":[{"name":"craigparra","email":"craigparra@gmail.com"}],"contributors":[{"url":"Anthropic","name":"Claude"}],"homepage":"https://github.com/alt-javascript/jsdbc/tree/main/packages/sqlite#readme","bugs":{"url":"https://github.com/alt-javascript/jsdbc/issues"},"dist":{"shasum":"d342d9b775c11ebb01da989bef3354be4b9ef447","tarball":"https://registry.npmjs.org/@alt-javascript/jsdbc-sqlite/-/jsdbc-sqlite-1.1.1.tgz","fileCount":8,"integrity":"sha512-2kWr5pkdY4hrbYhYBvSysHgNYEbKy2NECs01hkEjWZJ5m/OdwPKwU9NDlZmBcyH2E/2Q5gqHbt7mlHgd8Fb/Gg==","signatures":[{"sig":"MEYCIQDFMV300hWpY8p1VgnHkUYMmBjBZklDEG874rKnXQI+fwIhAJ4BhMl/FKdwqLoie0jWWJ4ReeMtm2KmcykKNqdvZ/nI","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":8309},"main":"index.js","type":"module","gitHead":"0769b436f75d65bb153cdb9cf00186f464416cff","scripts":{"test":"mocha --recursive test/**/*.spec.js"},"_npmUser":{"name":"craigparra","email":"craigparra@gmail.com"},"repository":{"url":"git+https://github.com/alt-javascript/jsdbc.git","type":"git","directory":"packages/sqlite"},"_npmVersion":"11.12.0","description":"JSDBC driver for SQLite via better-sqlite3","directories":{},"_nodeVersion":"24.14.0","dependencies":{"better-sqlite3":"^11.0.0","@alt-javascript/jsdbc-core":"*"},"publishConfig":{"access":"public","registry":"https://registry.npmjs.org/"},"_hasShrinkwrap":false,"devDependencies":{"chai":"^4.3.7","mocha":"^10.2.0"},"_npmOperationalInternal":{"tmp":"tmp/jsdbc-sqlite_1.1.1_1774504402947_0.730867011731849","host":"s3://npm-registry-packages-npm-production"}},"1.2.0":{"name":"@alt-javascript/jsdbc-sqlite","version":"1.2.0","description":"JSDBC driver for SQLite via better-sqlite3","keywords":["jsdbc","jdbc","database","sqlite","better-sqlite3","driver"],"publishConfig":{"registry":"https://registry.npmjs.org/","access":"public"},"homepage":"https://github.com/alt-javascript/jsdbc/tree/main/packages/sqlite#readme","repository":{"type":"git","url":"git+https://github.com/alt-javascript/jsdbc.git","directory":"packages/sqlite"},"type":"module","main":"index.js","scripts":{"test":"mocha --recursive test/**/*.spec.js"},"dependencies":{"@alt-javascript/jsdbc-core":"*","better-sqlite3":"^11.0.0"},"devDependencies":{"chai":"^4.3.7","mocha":"^10.2.0"},"author":{"name":"Craig Parravicini"},"contributors":[{"name":"Claude","url":"Anthropic"}],"license":"MIT","gitHead":"29c62c831f3b9c6007b21904aba69c61281ffd41","_id":"@alt-javascript/jsdbc-sqlite@1.2.0","bugs":{"url":"https://github.com/alt-javascript/jsdbc/issues"},"_nodeVersion":"24.14.0","_npmVersion":"11.12.1","dist":{"integrity":"sha512-6eifU3O7v5pLX8fCmiANnQVHvlwu4+vaNiPe4vVKqd4CHdN0+BNNXl/jpoJ5PEGmflBOFY3cIIjmWmDb9rwbJA==","shasum":"d0c3441ecd5a33394d3c9142fe3d64f394bb4332","tarball":"https://registry.npmjs.org/@alt-javascript/jsdbc-sqlite/-/jsdbc-sqlite-1.2.0.tgz","fileCount":8,"unpackedSize":8309,"signatures":[{"keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U","sig":"MEYCIQD8TqkQdb29G/tX0Qy1fup65WeFn03szQSxIMwwjXAJVQIhAP4+qKeit2qeYwTaqgGhGomQwyzeKmQUfNM72BRiWYKV"}]},"_npmUser":{"name":"craigparra","email":"craigparra@gmail.com"},"directories":{},"maintainers":[{"name":"craigparra","email":"craigparra@gmail.com"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages-npm-production","tmp":"tmp/jsdbc-sqlite_1.2.0_1774900896718_0.2428090670323293"},"_hasShrinkwrap":false}},"time":{"created":"2026-03-20T00:50:18.901Z","modified":"2026-03-30T20:01:37.009Z","1.0.0":"2026-03-20T00:50:19.135Z","1.1.1":"2026-03-26T05:53:23.108Z","1.2.0":"2026-03-30T20:01:36.878Z"},"bugs":{"url":"https://github.com/alt-javascript/jsdbc/issues"},"author":{"name":"Craig Parravicini"},"license":"MIT","homepage":"https://github.com/alt-javascript/jsdbc/tree/main/packages/sqlite#readme","keywords":["jsdbc","jdbc","database","sqlite","better-sqlite3","driver"],"repository":{"type":"git","url":"git+https://github.com/alt-javascript/jsdbc.git","directory":"packages/sqlite"},"description":"JSDBC driver for SQLite via better-sqlite3","contributors":[{"name":"Claude","url":"Anthropic"}],"maintainers":[{"name":"craigparra","email":"craigparra@gmail.com"}],"readme":"# @alt-javascript/jsdbc-sqlite\n\n[![Language](https://img.shields.io/badge/language-JavaScript-yellow.svg)](https://developer.mozilla.org/en-US/docs/Web/JavaScript)\n[![npm version](https://img.shields.io/npm/v/%40alt-javascript%2Fjsdbc-sqlite)](https://www.npmjs.com/package/@alt-javascript/jsdbc-sqlite)\n[![License: MIT](https://img.shields.io/badge/license-MIT-blue.svg)](https://opensource.org/licenses/MIT)\n[![CI](https://github.com/alt-javascript/jsdbc/actions/workflows/node.js.yml/badge.svg)](https://github.com/alt-javascript/jsdbc/actions/workflows/node.js.yml)\n\nJSDBC driver for SQLite via [better-sqlite3](https://github.com/WiseLibs/better-sqlite3). Provides high-performance, synchronous SQLite access through the async JSDBC interface.\n\n**Part of the [@alt-javascript/jsdbc](https://github.com/alt-javascript/jsdbc) monorepo.**\n\n## Install\n\n```bash\nnpm install @alt-javascript/jsdbc-core @alt-javascript/jsdbc-sqlite\n```\n\n> **Note:** `better-sqlite3` includes a native C++ addon. Prebuilt binaries are available for most platforms. If none match, a C++ compiler is required.\n\n## Usage\n\n```javascript\nimport { DataSource } from '@alt-javascript/jsdbc-core';\nimport '@alt-javascript/jsdbc-sqlite'; // self-registers with DriverManager\n\n// File-based database\nconst ds = new DataSource({ url: 'jsdbc:sqlite:./myapp.db' });\n\n// In-memory database\nconst ds = new DataSource({ url: 'jsdbc:sqlite::memory:' });\n\nconst conn = await ds.getConnection();\nconst stmt = await conn.createStatement();\nawait stmt.executeUpdate('CREATE TABLE items (id INTEGER PRIMARY KEY, name TEXT)');\n\nconst ps = await conn.prepareStatement('INSERT INTO items (name) VALUES (?)');\nps.setParameter(1, 'Widget');\nawait ps.executeUpdate();\n\nawait conn.close();\n```\n\n## URL Scheme\n\n```\njsdbc:sqlite:<path-or-memory>\n```\n\n| URL | Description |\n|---|---|\n| `jsdbc:sqlite:./data/app.db` | File-based database at relative path |\n| `jsdbc:sqlite:/var/lib/app.db` | File-based database at absolute path |\n| `jsdbc:sqlite::memory:` | In-memory database (lost when connection closes) |\n\n## When to Use\n\n- **Node.js server applications** needing embedded SQL without a separate database server\n- **CLI tools and scripts** with local data storage\n- **Testing** with disposable in-memory databases\n\nFor browser environments, use [`@alt-javascript/jsdbc-sqljs`](https://www.npmjs.com/package/@alt-javascript/jsdbc-sqljs) instead.\n\n## License\n\nMIT\n","readmeFilename":"README.md"}