{"id":173623987,"number":"0.4.0","published_at":"2026-02-04T18:41:33.258Z","licenses":"MIT","integrity":"sha512-fO6YXVn9qFcfvO6oSpxQ9EVpyDqPDvHnodiBedHEJGitSHi4zeK3lNZQ2Ze8GRIjt5KWGeWAw64Q42qC6oTurQ==","status":null,"download_url":"https://registry.npmjs.org/@photostructure/sqlite/-/sqlite-0.4.0.tgz","registry_url":"https://www.npmjs.com/package/@photostructure/sqlite/v/0.4.0","documentation_url":null,"install_command":"npm install @photostructure/sqlite@0.4.0","immutable":null,"metadata":{"deprecated":null,"_npmUser":{"name":"GitHub Actions","email":"npm-oidc-no-reply@github.com","trustedPublisher":{"id":"github","oidcConfigId":"oidc:796469d8-64a6-4474-bc2e-16e1b052b6df"}},"dist":{"shasum":"7eb8ad45da5b5f671d5aacf81d501fa5d0ffd68e","tarball":"https://registry.npmjs.org/@photostructure/sqlite/-/sqlite-0.4.0.tgz","fileCount":77,"integrity":"sha512-fO6YXVn9qFcfvO6oSpxQ9EVpyDqPDvHnodiBedHEJGitSHi4zeK3lNZQ2Ze8GRIjt5KWGeWAw64Q42qC6oTurQ==","signatures":[{"sig":"MEUCIDZcNXi1O6jpNYQxBiw0Moe4fQLocCdKDjChOMRqPdsGAiEA+cIFr8AaXEQjwtHyJIJRsgNDPzo/zCJA+PltuOeEmjc=","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"attestations":{"url":"https://registry.npmjs.org/-/npm/v1/attestations/@photostructure%2fsqlite@0.4.0","provenance":{"predicateType":"https://slsa.dev/provenance/v1"}},"unpackedSize":28770442},"gitHead":"84b73743974ca2df89796e44cb30be9a4776ff2e","main":"./dist/index.cjs","scripts":{"fmt":"run-p fmt:prettier fmt:native","//ci":"CI and release commands","docs":"typedoc","lint":"run-p lint:ts lint:eslint","sync":"run-s sync:node sync:sqlite sync:tests","test":"npm run build:dist \u0026\u0026 node --expose-gc node_modules/jest/bin/jest.js --no-coverage","//fmt":"code formatting","bench":"cd benchmark \u0026\u0026 npm install \u0026\u0026 npm run bench","build":"run-p build:dist build:native","clean":"run-p clean:dist clean:native","//docs":"documentation","//lint":"'lint' runs everywhere, 'lint:full' adds optional tools","//sync":"sync upstream sources","//test":"'test' is quick dev feedback, 'test:all' is comprehensive","stress":"cd benchmark \u0026\u0026 npm install \u0026\u0026 cd .. \u0026\u0026 tsx scripts/stress-test.ts","//bench":"benchmarks","//build":"build commands","//clean":"cleanup commands","install":"node-gyp-build","lint:ts":"tsc --noEmit","rebuild":"run-s clean build","//memory":"memory analysis tools","//stress":"stress tests","lint:api":"tsx scripts/check-api-compat.ts","security":"run-s security:audit security:osv","test:all":"npm run build \u0026\u0026 run-s test:cjs test:esm","test:api":"jest --config jest.config.api-compat.cjs","test:cjs":"node --expose-gc node_modules/jest/bin/jest.js","test:esm":"cross-env TEST_ESM=1 node --expose-gc --experimental-vm-modules --no-warnings node_modules/jest/bin/jest.js","clean:all":"run-p clean:dist clean:native clean:docker clean:docker:cache","lint:full":"run-s lint lint:native lint:api","precommit":"npx --yes tsx scripts/precommit.ts","stress:ci":"cd benchmark \u0026\u0026 npm install \u0026\u0026 cd .. \u0026\u0026 tsx scripts/stress-test.ts --ci --output-file stress-test-results.json","sync:node":"tsx scripts/sync-from-node.ts","test:node":"node --test test/node-compat/*.js test/node-compat/*.mjs","//security":"security scanning","bench:full":"cd benchmark \u0026\u0026 npm install \u0026\u0026 npm run bench \u0026\u0026 npm run bench:memory","build:dist":"tsup \u0026\u0026 node scripts/post-build.mjs","clean:dist":"del-cli dist \"*.tsbuildinfo\"","fmt:native":"clang-format --style=LLVM -i src/shims/*.h src/*.cpp src/*.h test/fixtures/test-extension/*.c || true","sync:tests":"tsx scripts/sync-node-tests.ts","lint:eslint":"eslint src/ test/ scripts/","lint:native":"tsx scripts/clang-tidy.ts","memory:asan":"bash scripts/sanitizers-test.sh","sync:sqlite":"tsx scripts/sync-from-sqlite.ts","test:memory":"cross-env TEST_MEMORY=1 node --expose-gc node_modules/jest/bin/jest.js --no-coverage test/memory.test.ts","test:serial":"node --expose-gc node_modules/jest/bin/jest.js --runInBand --no-coverage","bench:memory":"cd benchmark \u0026\u0026 npm install \u0026\u0026 npm run bench:memory","build:native":"tsx scripts/build-native.ts","clean:docker":"docker rm -f $(docker ps -aq --filter name=node-sqlite-test 2\u003e/dev/null) 2\u003e/dev/null || true","clean:native":"node-gyp clean \u0026\u0026 del-cli prebuilds","fmt:prettier":"prettier --write .","memory:check":"npx --yes tsx scripts/check-memory.ts","security:osv":"osv-scanner scan --recursive . || true","lint:ts:bench":"cd benchmark \u0026\u0026 npm install \u0026\u0026 tsc --noEmit","lint:ts:build":"tsc -p tsconfig.build.json --noEmit","security:audit":"npm audit --production","test:extension":"cd test/fixtures/test-extension \u0026\u0026 node build.js","update:actions":"pinact run -u","install:actions":"go install github.com/suzuki-shunsuke/pinact/cmd/pinact@latest","lint:ts:scripts":"tsc --noEmit --module esnext --target es2022 --moduleResolution node --project scripts/tsconfig.json","memory:valgrind":"bash scripts/valgrind-test.sh","release:prepare":"npm run build:dist","stress:validate":"node --expose-gc node_modules/jest/bin/jest.js --no-coverage benchmark/stress-test.test.ts","build:native:linux":"bash scripts/prebuild-linux-glibc.sh","clean:docker:cache":"del-cli .cache","security:audit:fix":"npm audit fix --force","test:docker:alpine":"REUSE_BUILD=1 REUSE_CONTAINER=1 bash scripts/test-docker-alpine.sh","test:docker:debian":"REUSE_BUILD=1 REUSE_CONTAINER=1 bash scripts/test-docker-debian.sh","install:osv-scanner":"go install github.com/google/osv-scanner/cmd/osv-scanner@latest","build:native:rebuild":"node-gyp rebuild"},"_npmVersion":"11.9.0","_nodeVersion":"24.13.0","_hasShrinkwrap":false,"directories":{},"engines":{"node":"\u003e=20.0.0"},"exports":{".":{"import":{"types":"./dist/index.d.ts","default":"./dist/index.mjs"},"require":{"types":"./dist/index.d.cts","default":"./dist/index.cjs"}},"./package.json":"./package.json"},"browserify":null},"created_at":"2026-02-19T18:40:53.442Z","updated_at":"2026-02-19T18:40:53.442Z","purl":"pkg:npm/%40photostructure/sqlite@0.4.0","related_tag":{"name":"v0.4.0","sha":"84b73743974ca2df89796e44cb30be9a4776ff2e","kind":"tag","published_at":"2026-02-04T18:41:23.000Z","download_url":"https://codeload.github.com/photostructure/node-sqlite/tar.gz/v0.4.0","html_url":"https://github.com/photostructure/node-sqlite/releases/tag/v0.4.0","dependencies_parsed_at":null,"dependency_job_id":null,"purl":"pkg:github/photostructure/node-sqlite@v0.4.0","tag_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/photostructure%2Fnode-sqlite/tags/v0.4.0","manifests_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/photostructure%2Fnode-sqlite/tags/v0.4.0/manifests"},"latest":false,"version_url":"https://packages.ecosyste.ms/api/v1/registries/npmjs.org/packages/@photostructure%2Fsqlite/versions/0.4.0","codemeta_url":"https://packages.ecosyste.ms/api/v1/registries/npmjs.org/packages/@photostructure%2Fsqlite/versions/0.4.0/codemeta","dependencies":[{"id":1920809395,"ecosystem":"npm","package_name":"node-addon-api","requirements":"^8.5.0","kind":"runtime","optional":false},{"id":1920809396,"ecosystem":"npm","package_name":"node-gyp-build","requirements":"^4.8.4","kind":"runtime","optional":false},{"id":1920809397,"ecosystem":"npm","package_name":"tsx","requirements":"^4.21.0","kind":"Development","optional":false},{"id":1920809398,"ecosystem":"npm","package_name":"jest","requirements":"^30.2.0","kind":"Development","optional":false},{"id":1920809399,"ecosystem":"npm","package_name":"tsup","requirements":"^8.5.1","kind":"Development","optional":false},{"id":1920809400,"ecosystem":"npm","package_name":"eslint","requirements":"^9.39.2","kind":"Development","optional":false},{"id":1920809401,"ecosystem":"npm","package_name":"del-cli","requirements":"^7.0.0","kind":"Development","optional":false},{"id":1920809402,"ecosystem":"npm","package_name":"globals","requirements":"^17.0.0","kind":"Development","optional":false},{"id":1920809403,"ecosystem":"npm","package_name":"ts-jest","requirements":"^29.4.6","kind":"Development","optional":false},{"id":1920809404,"ecosystem":"npm","package_name":"typedoc","requirements":"^0.28.16","kind":"Development","optional":false},{"id":1920809405,"ecosystem":"npm","package_name":"node-gyp","requirements":"^12.2.0","kind":"Development","optional":false},{"id":1920809406,"ecosystem":"npm","package_name":"prettier","requirements":"^3.8.1","kind":"Development","optional":false},{"id":1920809407,"ecosystem":"npm","package_name":"cross-env","requirements":"^10.1.0","kind":"Development","optional":false},{"id":1920809408,"ecosystem":"npm","package_name":"typescript","requirements":"^5.9.3","kind":"Development","optional":false},{"id":1920809409,"ecosystem":"npm","package_name":"@types/jest","requirements":"^30.0.0","kind":"Development","optional":false},{"id":1920809410,"ecosystem":"npm","package_name":"@types/node","requirements":"^25.0.3","kind":"Development","optional":false},{"id":1920809411,"ecosystem":"npm","package_name":"prebuildify","requirements":"^6.0.1","kind":"Development","optional":false},{"id":1920809412,"ecosystem":"npm","package_name":"npm-run-all2","requirements":"8.0.4","kind":"Development","optional":false},{"id":1920809413,"ecosystem":"npm","package_name":"better-sqlite3","requirements":"^12.6.2","kind":"Development","optional":false},{"id":1920809414,"ecosystem":"npm","package_name":"npm-check-updates","requirements":"^19","kind":"Development","optional":false},{"id":1920809415,"ecosystem":"npm","package_name":"typescript-eslint","requirements":"^8.54.0","kind":"Development","optional":false},{"id":1920809416,"ecosystem":"npm","package_name":"@mceachen/sqlite-vec","requirements":"^0.3.2","kind":"Development","optional":false},{"id":1920809417,"ecosystem":"npm","package_name":"eslint-plugin-regexp","requirements":"^3.0.0","kind":"Development","optional":false},{"id":1920809418,"ecosystem":"npm","package_name":"eslint-plugin-security","requirements":"^3.0.1","kind":"Development","optional":false},{"id":1920809419,"ecosystem":"npm","package_name":"prettier-plugin-organize-imports","requirements":"^4.3.0","kind":"Development","optional":false}],"package_url":"https://packages.ecosyste.ms/api/v1/registries/npmjs.org/packages/@photostructure%2Fsqlite"}