{"_id":"@remix-run/data-table-sqlite","_rev":"13-f092efd88ad31d4d60ce43d74819f521","name":"@remix-run/data-table-sqlite","dist-tags":{"latest":"0.6.3"},"versions":{"0.0.0":{"name":"@remix-run/data-table-sqlite","version":"0.0.0","keywords":["remix","placeholder"],"license":"MIT","_id":"@remix-run/data-table-sqlite@0.0.0","maintainers":[{"name":"mjackson","email":"mjijackson+npm@gmail.com"},{"name":"ryanflorence","email":"rpflorence@gmail.com"}],"homepage":"https://github.com/remix-run/remix/tree/main/packages/data-table-sqlite#readme","bugs":{"url":"https://github.com/remix-run/remix/issues"},"dist":{"shasum":"64c3072bd24db003f37ddef5c2234ea334dd3695","tarball":"https://registry.npmjs.org/@remix-run/data-table-sqlite/-/data-table-sqlite-0.0.0.tgz","fileCount":2,"integrity":"sha512-Icx1IXRdPxW2mh+eGPPge/YqRkXQMVAQ+f2O1P8SHnGTbh1I0+JSheCjDg83zQZhnxamQg/OsQVaF/yJDkdEdw==","signatures":[{"sig":"MEUCIQCZYv1ggJgo51+k7jET4xL08Oc8FauPKjwBRh+d8vwA0wIgLWuRiZXZqtNVMhN3sLngb/dCE/yKTVxilYoh9H+tOpo=","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":635},"gitHead":"ef934f523767154caef1b3ab3c4e536f2e390141","private":false,"_npmUser":{"name":"mjackson","email":"mjijackson+npm@gmail.com"},"repository":{"url":"git+https://github.com/remix-run/remix.git","type":"git","directory":"packages/data-table-sqlite"},"_npmVersion":"11.8.0","description":"Placeholder package for future Remix data-table-sqlite APIs","directories":{},"_nodeVersion":"24.2.0","publishConfig":{"access":"public"},"_hasShrinkwrap":false,"_npmOperationalInternal":{"tmp":"tmp/data-table-sqlite_0.0.0_1770854150715_0.3831785541877317","host":"s3://npm-registry-packages-npm-production"}},"0.1.0":{"name":"@remix-run/data-table-sqlite","version":"0.1.0","keywords":["remix","orm","sqlite","database","sql"],"author":{"name":"Michael Jackson","email":"mjijackson@gmail.com"},"license":"MIT","_id":"@remix-run/data-table-sqlite@0.1.0","maintainers":[{"name":"mjackson","email":"mjijackson+npm@gmail.com"}],"homepage":"https://github.com/remix-run/remix/tree/main/packages/data-table-sqlite#readme","bugs":{"url":"https://github.com/remix-run/remix/issues"},"dist":{"shasum":"4262aab90fc9d02bb8cca17d913b288f01ffc0dc","tarball":"https://registry.npmjs.org/@remix-run/data-table-sqlite/-/data-table-sqlite-0.1.0.tgz","fileCount":15,"integrity":"sha512-hFtmz9haMr3p/aFWL5D1zpJsgAnNdLVCF6HvXBmtK4m3NdLmM1eNhblpB/SfPGNEODsmx4Jvcaof57dfaLuKgA==","signatures":[{"sig":"MEQCIEcHMStf19brCe9LGBwvbUtr91KvGRK3llY6gVmDpph5AiAGHRfK7+PNyWMY4+2nlTH1VYwXz3sex/e8fdDohTTj7A==","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"attestations":{"url":"https://registry.npmjs.org/-/npm/v1/attestations/@remix-run%2fdata-table-sqlite@0.1.0","provenance":{"predicateType":"https://slsa.dev/provenance/v1"}},"unpackedSize":48975},"type":"module","_from":"file:remix-run-data-table-sqlite-0.1.0.tgz","exports":{".":{"types":"./dist/index.d.ts","default":"./dist/index.js"},"./package.json":"./package.json"},"scripts":{"test":"node --disable-warning=ExperimentalWarning --test","build":"tsgo -p tsconfig.build.json","clean":"git clean -fdX","typecheck":"tsgo --noEmit","test:coverage":"node --disable-warning=ExperimentalWarning --experimental-test-coverage --test-coverage-include='src/**/*.ts' --test-coverage-lines=90 --test-coverage-branches=90 --test-coverage-functions=90 --test ./src/lib/adapter.test.ts ./src/lib/sql-compiler.test.ts"},"_npmUser":{"name":"GitHub Actions","email":"npm-oidc-no-reply@github.com","trustedPublisher":{"id":"github","oidcConfigId":"oidc:b6139f89-a088-4ac7-bd12-0ab705d58d72"}},"_resolved":"/tmp/47e651b175e6fb8d100b2f79f0f337e9/remix-run-data-table-sqlite-0.1.0.tgz","_integrity":"sha512-hFtmz9haMr3p/aFWL5D1zpJsgAnNdLVCF6HvXBmtK4m3NdLmM1eNhblpB/SfPGNEODsmx4Jvcaof57dfaLuKgA==","repository":{"url":"git+https://github.com/remix-run/remix.git","type":"git","directory":"packages/data-table-sqlite"},"_npmVersion":"11.10.1","description":"SQLite adapter for @remix-run/data-table","directories":{},"sideEffects":false,"_nodeVersion":"25.7.0","dependencies":{"@remix-run/data-table":"^0.1.0"},"_hasShrinkwrap":false,"devDependencies":{"@types/node":"^24.6.0","better-sqlite3":"^12.4.1","@remix-run/data-table":"0.1.0","@types/better-sqlite3":"^7.6.13","@remix-run/data-schema":"0.1.0","@typescript/native-preview":"7.0.0-dev.20251125.1"},"peerDependencies":{"better-sqlite3":"^12.4.1"},"peerDependenciesMeta":{"better-sqlite3":{"optional":true}},"_npmOperationalInternal":{"tmp":"tmp/data-table-sqlite_0.1.0_1772241715160_0.7447391855019756","host":"s3://npm-registry-packages-npm-production"}},"0.2.0":{"name":"@remix-run/data-table-sqlite","version":"0.2.0","keywords":["remix","orm","sqlite","database","sql"],"author":{"name":"Michael Jackson","email":"mjijackson@gmail.com"},"license":"MIT","_id":"@remix-run/data-table-sqlite@0.2.0","maintainers":[{"name":"mjackson","email":"mjijackson+npm@gmail.com"}],"homepage":"https://github.com/remix-run/remix/tree/main/packages/data-table-sqlite#readme","bugs":{"url":"https://github.com/remix-run/remix/issues"},"dist":{"shasum":"af356f4528d3dbdeb3b4663b70fe169f40652fff","tarball":"https://registry.npmjs.org/@remix-run/data-table-sqlite/-/data-table-sqlite-0.2.0.tgz","fileCount":15,"integrity":"sha512-TAQ0u8YnmO3WdnuZULPhc+fgZbKZZPutXiPLf8c9NDhXSC41FlcvfQHTKUxBPVhqdi9mhGiblHHNp6BsVu11dg==","signatures":[{"sig":"MEUCIAYp3Jff/vYG+/IBHZ7G1Rgat5gVBE7eyT0uRK2EyM+jAiEA+QOy+pumSGZEgcY27chbTPR+KJYXdQg3L5pkUXInXBw=","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"attestations":{"url":"https://registry.npmjs.org/-/npm/v1/attestations/@remix-run%2fdata-table-sqlite@0.2.0","provenance":{"predicateType":"https://slsa.dev/provenance/v1"}},"unpackedSize":85453},"type":"module","_from":"file:remix-run-data-table-sqlite-0.2.0.tgz","exports":{".":{"types":"./dist/index.d.ts","default":"./dist/index.js"},"./package.json":"./package.json"},"scripts":{"test":"node --test","build":"tsgo -p tsconfig.build.json","clean":"git clean -fdX","typecheck":"tsgo --noEmit","test:coverage":"node --experimental-test-coverage --test-coverage-include='src/**/*.ts' --test-coverage-lines=90 --test-coverage-branches=90 --test-coverage-functions=90 --test ./src/lib/adapter.test.ts ./src/lib/sql-compiler.test.ts"},"_npmUser":{"name":"GitHub Actions","email":"npm-oidc-no-reply@github.com","trustedPublisher":{"id":"github","oidcConfigId":"oidc:b6139f89-a088-4ac7-bd12-0ab705d58d72"}},"_resolved":"/tmp/4b740d35474bb618abe467331c0b2189/remix-run-data-table-sqlite-0.2.0.tgz","_integrity":"sha512-TAQ0u8YnmO3WdnuZULPhc+fgZbKZZPutXiPLf8c9NDhXSC41FlcvfQHTKUxBPVhqdi9mhGiblHHNp6BsVu11dg==","repository":{"url":"git+https://github.com/remix-run/remix.git","type":"git","directory":"packages/data-table-sqlite"},"_npmVersion":"11.9.0","description":"SQLite adapter for remix/data-table","directories":{},"sideEffects":false,"_nodeVersion":"24.14.0","dependencies":{"@remix-run/data-table":"^0.2.0"},"_hasShrinkwrap":false,"devDependencies":{"@types/node":"^24.6.0","better-sqlite3":"^12.4.1","@remix-run/data-table":"0.2.0","@types/better-sqlite3":"^7.6.13","@typescript/native-preview":"7.0.0-dev.20251125.1"},"peerDependencies":{"better-sqlite3":"^12.4.1"},"peerDependenciesMeta":{"better-sqlite3":{"optional":true}},"_npmOperationalInternal":{"tmp":"tmp/data-table-sqlite_0.2.0_1774479822151_0.5179268529924259","host":"s3://npm-registry-packages-npm-production"}},"0.3.0":{"name":"@remix-run/data-table-sqlite","version":"0.3.0","keywords":["remix","orm","sqlite","database","sql"],"author":{"name":"Michael Jackson","email":"mjijackson@gmail.com"},"license":"MIT","_id":"@remix-run/data-table-sqlite@0.3.0","maintainers":[{"name":"mjackson","email":"mjijackson+npm@gmail.com"}],"homepage":"https://github.com/remix-run/remix/tree/main/packages/data-table-sqlite#readme","bugs":{"url":"https://github.com/remix-run/remix/issues"},"dist":{"shasum":"239f0fe555048fe19ecf613a37c4d3a90cc27ec2","tarball":"https://registry.npmjs.org/@remix-run/data-table-sqlite/-/data-table-sqlite-0.3.0.tgz","fileCount":15,"integrity":"sha512-KTVYCfmdXdktjewkY88Y2MjQqJCLRdrJ2R5Uw3hg9rKlG5g7Ix6F2ZN7vxSCqT/+kInfVk5ntWFVlTQnZWY5fw==","signatures":[{"sig":"MEQCICI/H0fI8t94VdiL1MOIY7QfmluTfjufgvEhigXXsf+WAiBgEx00hlhOPYWf/zDte5RNdT8yNTlqk/x3t9o3q/kZFg==","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"attestations":{"url":"https://registry.npmjs.org/-/npm/v1/attestations/@remix-run%2fdata-table-sqlite@0.3.0","provenance":{"predicateType":"https://slsa.dev/provenance/v1"}},"unpackedSize":83980},"type":"module","_from":"file:remix-run-data-table-sqlite-0.3.0.tgz","exports":{".":{"types":"./dist/index.d.ts","default":"./dist/index.js"},"./package.json":"./package.json"},"scripts":{"test":"node --test","build":"tsgo -p tsconfig.build.json","clean":"git clean -fdX","typecheck":"tsgo --noEmit","test:coverage":"node --experimental-test-coverage --test-coverage-include='src/**/*.ts' --test-coverage-lines=90 --test-coverage-branches=90 --test-coverage-functions=90 --test ./src/lib/adapter.test.ts ./src/lib/sql-compiler.test.ts"},"_npmUser":{"name":"GitHub Actions","email":"npm-oidc-no-reply@github.com","trustedPublisher":{"id":"github","oidcConfigId":"oidc:b6139f89-a088-4ac7-bd12-0ab705d58d72"}},"_resolved":"/tmp/d5e701952dab3e9ea44ef7baef098847/remix-run-data-table-sqlite-0.3.0.tgz","_integrity":"sha512-KTVYCfmdXdktjewkY88Y2MjQqJCLRdrJ2R5Uw3hg9rKlG5g7Ix6F2ZN7vxSCqT/+kInfVk5ntWFVlTQnZWY5fw==","repository":{"url":"git+https://github.com/remix-run/remix.git","type":"git","directory":"packages/data-table-sqlite"},"_npmVersion":"11.11.0","description":"SQLite adapter for remix/data-table","directories":{},"sideEffects":false,"_nodeVersion":"24.14.1","dependencies":{"@remix-run/data-table":"^0.2.0"},"_hasShrinkwrap":false,"devDependencies":{"@types/node":"^24.6.0","better-sqlite3":"^12.4.1","@remix-run/data-table":"0.2.0","@types/better-sqlite3":"^7.6.13","@typescript/native-preview":"7.0.0-dev.20251125.1"},"peerDependencies":{"better-sqlite3":"^12.4.1"},"peerDependenciesMeta":{"better-sqlite3":{"optional":true}},"_npmOperationalInternal":{"tmp":"tmp/data-table-sqlite_0.3.0_1776904508586_0.8936206375581277","host":"s3://npm-registry-packages-npm-production"}},"0.4.0":{"name":"@remix-run/data-table-sqlite","version":"0.4.0","keywords":["remix","orm","sqlite","database","sql"],"author":{"name":"Michael Jackson","email":"mjijackson@gmail.com"},"license":"MIT","_id":"@remix-run/data-table-sqlite@0.4.0","maintainers":[{"name":"mjackson","email":"mjijackson+npm@gmail.com"}],"homepage":"https://github.com/remix-run/remix/tree/main/packages/data-table-sqlite#readme","bugs":{"url":"https://github.com/remix-run/remix/issues"},"dist":{"shasum":"906edf3067090cfa1b501c0c860d62b7f39daee7","tarball":"https://registry.npmjs.org/@remix-run/data-table-sqlite/-/data-table-sqlite-0.4.0.tgz","fileCount":15,"integrity":"sha512-tNgEuBN/H9UW4J8Zu6Y2uydUVr3rbyYKRgfzFS/Sg6XOxetYDZYp+o6XaeGQEmupACPHJ+CtNtHoyinfU1eOaQ==","signatures":[{"sig":"MEYCIQCOor1Mo2etPtCAsFLnevuqnd/iae1YWXHWuPy5TdZEDAIhAITGRlDipZuG45py/lWiVL2uUE+O6o2xKK5/K4bp3zmO","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"attestations":{"url":"https://registry.npmjs.org/-/npm/v1/attestations/@remix-run%2fdata-table-sqlite@0.4.0","provenance":{"predicateType":"https://slsa.dev/provenance/v1"}},"unpackedSize":87288},"type":"module","_from":"file:remix-run-data-table-sqlite-0.4.0.tgz","exports":{".":{"types":"./dist/index.d.ts","default":"./dist/index.js"},"./package.json":"./package.json"},"scripts":{"test":"remix-test","build":"tsgo -p tsconfig.build.json","clean":"git clean -fdX","test:bun":"bun x --bun remix-test","typecheck":"tsgo --noEmit","test:coverage":"remix-test --coverage"},"_npmUser":{"name":"GitHub Actions","email":"npm-oidc-no-reply@github.com","trustedPublisher":{"id":"github","oidcConfigId":"oidc:b6139f89-a088-4ac7-bd12-0ab705d58d72"}},"_resolved":"/tmp/48a31e3fd5194f17be267f4437d2028d/remix-run-data-table-sqlite-0.4.0.tgz","_integrity":"sha512-tNgEuBN/H9UW4J8Zu6Y2uydUVr3rbyYKRgfzFS/Sg6XOxetYDZYp+o6XaeGQEmupACPHJ+CtNtHoyinfU1eOaQ==","repository":{"url":"git+https://github.com/remix-run/remix.git","type":"git","directory":"packages/data-table-sqlite"},"_npmVersion":"11.11.0","description":"SQLite adapter for remix/data-table","directories":{},"sideEffects":false,"_nodeVersion":"24.14.1","dependencies":{"@remix-run/data-table":"^0.2.0"},"_hasShrinkwrap":false,"devDependencies":{"@types/node":"^24.6.0","@remix-run/test":"0.2.0","@remix-run/assert":"0.1.0","@remix-run/data-table":"0.2.0","@typescript/native-preview":"7.0.0-dev.20251125.1"},"_npmOperationalInternal":{"tmp":"tmp/data-table-sqlite_0.4.0_1777483778056_0.6857046854571853","host":"s3://npm-registry-packages-npm-production"}},"0.4.1":{"name":"@remix-run/data-table-sqlite","version":"0.4.1","keywords":["remix","orm","sqlite","database","sql"],"author":{"name":"Michael Jackson","email":"mjijackson@gmail.com"},"license":"MIT","_id":"@remix-run/data-table-sqlite@0.4.1","maintainers":[{"name":"mjackson","email":"mjijackson+npm@gmail.com"}],"homepage":"https://github.com/remix-run/remix/tree/main/packages/data-table-sqlite#readme","bugs":{"url":"https://github.com/remix-run/remix/issues"},"dist":{"shasum":"c8f68bbdf205b0d6edca565d03c68d6e5e5478bb","tarball":"https://registry.npmjs.org/@remix-run/data-table-sqlite/-/data-table-sqlite-0.4.1.tgz","fileCount":15,"integrity":"sha512-l4ZtPaviYKF/hiDXBbb35lnbye9m+X31B1RcPNUA6DNF0u5jwAFbaUfVRB+CwfJgv+PNZx9FXJbmMW5vK1Giwg==","signatures":[{"sig":"MEUCIQC9HI+vfdoFYI7+LaEFn0WJoQINwYjAXKvumZlIwBQarAIgFrwL2BqW49DrE70dPCh5zyJz04wLVV+Kk+hbxtkc0Mo=","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"attestations":{"url":"https://registry.npmjs.org/-/npm/v1/attestations/@remix-run%2fdata-table-sqlite@0.4.1","provenance":{"predicateType":"https://slsa.dev/provenance/v1"}},"unpackedSize":87730},"type":"module","_from":"file:remix-run-data-table-sqlite-0.4.1.tgz","exports":{".":{"types":"./dist/index.d.ts","default":"./dist/index.js"},"./package.json":"./package.json"},"scripts":{"test":"remix-test","build":"tsgo -p tsconfig.build.json","clean":"git clean -fdX","test:bun":"bun x --bun remix-test","typecheck":"tsgo --noEmit","test:coverage":"remix-test --coverage"},"_npmUser":{"name":"GitHub Actions","email":"npm-oidc-no-reply@github.com","trustedPublisher":{"id":"github","oidcConfigId":"oidc:b6139f89-a088-4ac7-bd12-0ab705d58d72"}},"_resolved":"/tmp/ccb29b4d1eaa1ebb2065dc6c8a44bb6b/remix-run-data-table-sqlite-0.4.1.tgz","_integrity":"sha512-l4ZtPaviYKF/hiDXBbb35lnbye9m+X31B1RcPNUA6DNF0u5jwAFbaUfVRB+CwfJgv+PNZx9FXJbmMW5vK1Giwg==","repository":{"url":"git+https://github.com/remix-run/remix.git","type":"git","directory":"packages/data-table-sqlite"},"_npmVersion":"11.11.0","description":"SQLite adapter for remix/data-table","directories":{},"sideEffects":false,"_nodeVersion":"24.14.1","dependencies":{"@remix-run/data-table":"^0.2.1"},"_hasShrinkwrap":false,"devDependencies":{"@types/node":"^24.6.0","@remix-run/test":"0.3.0","@remix-run/assert":"0.2.0","@remix-run/data-table":"0.2.1","@typescript/native-preview":"7.0.0-dev.20251125.1"},"_npmOperationalInternal":{"tmp":"tmp/data-table-sqlite_0.4.1_1777576276448_0.2504803855228257","host":"s3://npm-registry-packages-npm-production"}},"0.5.0":{"name":"@remix-run/data-table-sqlite","version":"0.5.0","keywords":["remix","orm","sqlite","database","sql"],"author":{"name":"Michael Jackson","email":"mjijackson@gmail.com"},"license":"MIT","_id":"@remix-run/data-table-sqlite@0.5.0","maintainers":[{"name":"mjackson","email":"mjijackson+npm@gmail.com"}],"homepage":"https://github.com/remix-run/remix/tree/main/packages/data-table-sqlite#readme","bugs":{"url":"https://github.com/remix-run/remix/issues"},"dist":{"shasum":"61375b9998a375cd136966cd8dd3ded9f8c7983d","tarball":"https://registry.npmjs.org/@remix-run/data-table-sqlite/-/data-table-sqlite-0.5.0.tgz","fileCount":15,"integrity":"sha512-B8jwMXq1ZVqMo0ZycYTRHjmOYK6drRo4s30IBvZ9VHpjDcNvyEx6/mXLKus+15C53Gnxf2KVh0cDkLi5jVEXyg==","signatures":[{"sig":"MEUCIHEwosueCFhFpM6lHSsFa6YWj0rhYm3McZueLLXUdePiAiEAvbBYdaY4fJy38aK8mf+sieJrcosYn1PzxY1flMqGOm4=","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"attestations":{"url":"https://registry.npmjs.org/-/npm/v1/attestations/@remix-run%2fdata-table-sqlite@0.5.0","provenance":{"predicateType":"https://slsa.dev/provenance/v1"}},"unpackedSize":62312},"type":"module","_from":"file:remix-run-data-table-sqlite-0.5.0.tgz","exports":{".":{"types":"./dist/index.d.ts","default":"./dist/index.js"},"./package.json":"./package.json"},"scripts":{"test":"remix-test","build":"tsgo -p tsconfig.build.json","clean":"git clean -fdX","test:bun":"bun x --bun remix-test","typecheck":"tsgo --noEmit","test:coverage":"remix-test --coverage"},"_npmUser":{"name":"GitHub Actions","email":"npm-oidc-no-reply@github.com","trustedPublisher":{"id":"github","oidcConfigId":"oidc:b6139f89-a088-4ac7-bd12-0ab705d58d72"}},"_resolved":"/tmp/3ed679eec98b879f460b2de3c8cef870/remix-run-data-table-sqlite-0.5.0.tgz","_integrity":"sha512-B8jwMXq1ZVqMo0ZycYTRHjmOYK6drRo4s30IBvZ9VHpjDcNvyEx6/mXLKus+15C53Gnxf2KVh0cDkLi5jVEXyg==","repository":{"url":"git+https://github.com/remix-run/remix.git","type":"git","directory":"packages/data-table-sqlite"},"_npmVersion":"11.12.1","description":"SQLite adapter for remix/data-table","directories":{},"sideEffects":false,"_nodeVersion":"24.15.0","dependencies":{"@remix-run/data-table":"^0.3.0"},"_hasShrinkwrap":false,"devDependencies":{"@types/node":"^24.6.0","@remix-run/test":"0.4.0","@remix-run/assert":"0.2.0","@remix-run/data-table":"0.3.0","@typescript/native-preview":"7.0.0-dev.20251125.1"},"_npmOperationalInternal":{"tmp":"tmp/data-table-sqlite_0.5.0_1779247276988_0.2623483763279353","host":"s3://npm-registry-packages-npm-production"}},"0.5.1":{"name":"@remix-run/data-table-sqlite","version":"0.5.1","keywords":["remix","orm","sqlite","database","sql"],"author":{"name":"Michael Jackson","email":"mjijackson@gmail.com"},"license":"MIT","_id":"@remix-run/data-table-sqlite@0.5.1","maintainers":[{"name":"mjackson","email":"mjijackson+npm@gmail.com"}],"homepage":"https://github.com/remix-run/remix/tree/main/packages/data-table-sqlite#readme","bugs":{"url":"https://github.com/remix-run/remix/issues"},"dist":{"shasum":"84ea2b0b850a6c829f49a0fc53098dd6d052ec59","tarball":"https://registry.npmjs.org/@remix-run/data-table-sqlite/-/data-table-sqlite-0.5.1.tgz","fileCount":15,"integrity":"sha512-YgpUz49eeddYHOY3ebWi4Xeu94KWICRPrmsotkWpTIQdnf/sV+Ddx8BS4kUs+y9JJ/efrjAeHl/LNH6swpvM8g==","signatures":[{"sig":"MEUCIQCJjFZlBO0zE0pKzU/C52absHbNEAOIUmZzSLy0QR5tGgIgLgGEo7cHJ9PWXjE4NOfmoC9hOclffpPpUis3+FJ4j6U=","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"attestations":{"url":"https://registry.npmjs.org/-/npm/v1/attestations/@remix-run%2fdata-table-sqlite@0.5.1","provenance":{"predicateType":"https://slsa.dev/provenance/v1"}},"unpackedSize":62504},"type":"module","_from":"file:remix-run-data-table-sqlite-0.5.1.tgz","exports":{".":{"types":"./dist/index.d.ts","default":"./dist/index.js"},"./package.json":"./package.json"},"scripts":{"test":"remix-test","build":"tsgo -p tsconfig.build.json","clean":"git clean -fdX","test:bun":"bun x --bun remix-test","typecheck":"tsgo --noEmit","test:coverage":"remix-test --coverage"},"_npmUser":{"name":"GitHub Actions","email":"npm-oidc-no-reply@github.com","trustedPublisher":{"id":"github","oidcConfigId":"oidc:b6139f89-a088-4ac7-bd12-0ab705d58d72"}},"_resolved":"/tmp/3744181893aa662735e74a872998d573/remix-run-data-table-sqlite-0.5.1.tgz","_integrity":"sha512-YgpUz49eeddYHOY3ebWi4Xeu94KWICRPrmsotkWpTIQdnf/sV+Ddx8BS4kUs+y9JJ/efrjAeHl/LNH6swpvM8g==","repository":{"url":"git+https://github.com/remix-run/remix.git","type":"git","directory":"packages/data-table-sqlite"},"_npmVersion":"11.13.0","description":"SQLite adapter for remix/data-table","directories":{},"sideEffects":false,"_nodeVersion":"24.16.0","dependencies":{"@remix-run/data-table":"^0.3.0"},"_hasShrinkwrap":false,"devDependencies":{"@types/node":"^24.6.0","@remix-run/test":"0.4.2","@remix-run/assert":"0.2.1","@remix-run/data-table":"0.3.0","@typescript/native-preview":"7.0.0-dev.20251125.1"},"_npmOperationalInternal":{"tmp":"tmp/data-table-sqlite_0.5.1_1780078589959_0.5338465150752427","host":"s3://npm-registry-packages-npm-production"}},"0.6.0":{"name":"@remix-run/data-table-sqlite","version":"0.6.0","keywords":["remix","orm","sqlite","database","sql"],"author":{"name":"Michael Jackson","email":"mjijackson@gmail.com"},"license":"MIT","_id":"@remix-run/data-table-sqlite@0.6.0","maintainers":[{"name":"mjackson","email":"mjijackson+npm@gmail.com"}],"homepage":"https://github.com/remix-run/remix/tree/main/packages/data-table-sqlite#readme","bugs":{"url":"https://github.com/remix-run/remix/issues"},"dist":{"shasum":"42516ed7b32b83e3fbd89d208da677393ba1079a","tarball":"https://registry.npmjs.org/@remix-run/data-table-sqlite/-/data-table-sqlite-0.6.0.tgz","fileCount":19,"integrity":"sha512-h4IcdthAxmCIbWtyWUCaBKxKAYNedHyCwG7tM7OSdrw+liHagQPhl6sFq8NlpI+U1830M8x/fG/w4JmxUkT0HA==","signatures":[{"sig":"MEUCIQDEUmU37XHJd35hpa94GytejreTfGtXFxkklk+1d3SX6gIgPjWr7y+9kyqRM01qMdPvbe40uno6e9Uud0ZrcZ390Pk=","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"attestations":{"url":"https://registry.npmjs.org/-/npm/v1/attestations/@remix-run%2fdata-table-sqlite@0.6.0","provenance":{"predicateType":"https://slsa.dev/provenance/v1"}},"unpackedSize":83441},"type":"module","_from":"file:remix-run-data-table-sqlite-0.6.0.tgz","exports":{".":{"types":"./dist/index.d.ts","default":"./dist/index.js"},"./package.json":"./package.json"},"scripts":{"test":"remix test","build":"tsc -p tsconfig.build.json","clean":"git clean -fdX","test:bun":"bun x --bun remix test","typecheck":"tsc --noEmit","test:coverage":"remix test --coverage"},"_npmUser":{"name":"GitHub Actions","email":"npm-oidc-no-reply@github.com","trustedPublisher":{"id":"github","oidcConfigId":"oidc:b6139f89-a088-4ac7-bd12-0ab705d58d72"}},"_resolved":"/tmp/f1a6a4ad5f17739d90c381f0c7d986ea/remix-run-data-table-sqlite-0.6.0.tgz","_integrity":"sha512-h4IcdthAxmCIbWtyWUCaBKxKAYNedHyCwG7tM7OSdrw+liHagQPhl6sFq8NlpI+U1830M8x/fG/w4JmxUkT0HA==","repository":{"url":"git+https://github.com/remix-run/remix.git","type":"git","directory":"packages/data-table-sqlite"},"_npmVersion":"11.16.0","description":"SQLite database implementation for remix/data-table","directories":{},"sideEffects":false,"_nodeVersion":"24.18.0","dependencies":{"@remix-run/data-table":"^0.4.0"},"_hasShrinkwrap":false,"devDependencies":{"typescript":"^7.0.2","@types/node":"^24.6.0","@remix-run/test":"0.6.0","@remix-run/assert":"0.3.0","@remix-run/data-table":"0.4.0"},"_npmOperationalInternal":{"tmp":"tmp/data-table-sqlite_0.6.0_1786666392707_0.923530035007458","host":"s3://npm-registry-packages-npm-production"}},"0.6.1":{"name":"@remix-run/data-table-sqlite","version":"0.6.1","keywords":["remix","orm","sqlite","database","sql"],"author":{"name":"Michael Jackson","email":"mjijackson@gmail.com"},"license":"MIT","_id":"@remix-run/data-table-sqlite@0.6.1","maintainers":[{"name":"mjackson","email":"mjijackson+npm@gmail.com"}],"homepage":"https://github.com/remix-run/remix/tree/main/packages/data-table-sqlite#readme","bugs":{"url":"https://github.com/remix-run/remix/issues"},"dist":{"shasum":"0c5263375d2a854e64019803073d5c0b2503644c","tarball":"https://registry.npmjs.org/@remix-run/data-table-sqlite/-/data-table-sqlite-0.6.1.tgz","fileCount":19,"integrity":"sha512-CVwHZbsCDa9Sg//GR2orWrh0KL/nVa1e5CvWW/G33flX6sBwv+A5OGZJHe+ZFCTLT9EAfY06+8Cew8AgIB8xCw==","signatures":[{"sig":"MEUCIQC3ZwvDXbTW+LthNb6y4ynRWKC7VevjR7qm0hk9PGfRcQIgPF2obUE4Z5s/z6nT6mOqfmvZab6Abh05Hy1UVLq9bDU=","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"attestations":{"url":"https://registry.npmjs.org/-/npm/v1/attestations/@remix-run%2fdata-table-sqlite@0.6.1","provenance":{"predicateType":"https://slsa.dev/provenance/v1"}},"unpackedSize":83441},"type":"module","_from":"file:/tmp/remix-publish-data-table-sqlite-FVNVJC/remix-run-data-table-sqlite-0.6.1.tgz","exports":{".":{"types":"./dist/index.d.ts","default":"./dist/index.js"},"./package.json":"./package.json"},"scripts":{"test":"remix test","build":"tsc -p tsconfig.build.json","clean":"git clean -fdX","test:bun":"bun x --bun remix test","typecheck":"tsc --noEmit","test:coverage":"remix test --coverage"},"_npmUser":{"name":"GitHub Actions","email":"npm-oidc-no-reply@github.com","trustedPublisher":{"id":"github","oidcConfigId":"oidc:b6139f89-a088-4ac7-bd12-0ab705d58d72"}},"_resolved":"/tmp/remix-publish-data-table-sqlite-FVNVJC/remix-run-data-table-sqlite-0.6.1.tgz","_integrity":"sha512-CVwHZbsCDa9Sg//GR2orWrh0KL/nVa1e5CvWW/G33flX6sBwv+A5OGZJHe+ZFCTLT9EAfY06+8Cew8AgIB8xCw==","repository":{"url":"git+https://github.com/remix-run/remix.git","type":"git","directory":"packages/data-table-sqlite"},"_npmVersion":"11.17.0","description":"SQLite database implementation for remix/data-table","directories":{},"sideEffects":false,"_nodeVersion":"24.19.0","dependencies":{"@remix-run/data-table":"^0.5.0"},"_hasShrinkwrap":false,"devDependencies":{"typescript":"^7.0.2","@types/node":"^24.6.0","@remix-run/test":"0.6.0","@remix-run/assert":"0.3.0","@remix-run/data-table":"0.5.0"},"_npmOperationalInternal":{"tmp":"tmp/data-table-sqlite_0.6.1_1788202643498_0.32159432402093735","host":"s3://npm-registry-packages-npm-production"}},"0.6.2":{"name":"@remix-run/data-table-sqlite","version":"0.6.2","keywords":["remix","orm","sqlite","database","sql"],"author":{"name":"Michael Jackson","email":"mjijackson@gmail.com"},"license":"MIT","_id":"@remix-run/data-table-sqlite@0.6.2","maintainers":[{"name":"mjackson","email":"mjijackson+npm@gmail.com"}],"homepage":"https://github.com/remix-run/remix/tree/main/packages/data-table-sqlite#readme","bugs":{"url":"https://github.com/remix-run/remix/issues"},"dist":{"shasum":"960481b3786c69caee8caa9d3f29bec039cba4a0","tarball":"https://registry.npmjs.org/@remix-run/data-table-sqlite/-/data-table-sqlite-0.6.2.tgz","fileCount":19,"integrity":"sha512-S/sBp7PU3uQMPRCuoyTFLcvZ5XE2jkcASN3VTn1xLW6hdnRI7YWLUMrrcmM9MivpirVmAeZrzUUT7z/TmlNINg==","signatures":[{"sig":"MEUCIBSiy7vHgAMq+4g4Oy6dh1tPyU1kBZcfAJY4CeOw4F6qAiEApDm/AcTR/gwdgN7eV+YYd1gpoFM0gNcV8Eht6GrC67g=","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"attestations":{"url":"https://registry.npmjs.org/-/npm/v1/attestations/@remix-run%2fdata-table-sqlite@0.6.2","provenance":{"predicateType":"https://slsa.dev/provenance/v1"}},"unpackedSize":83441},"type":"module","_from":"file:/tmp/remix-publish-data-table-sqlite-GVxakm/remix-run-data-table-sqlite-0.6.2.tgz","exports":{".":{"types":"./dist/index.d.ts","default":"./dist/index.js"},"./package.json":"./package.json"},"scripts":{"test":"remix test","build":"tsc -p tsconfig.build.json","clean":"git clean -fdX","test:bun":"bun x --bun remix test","typecheck":"tsc --noEmit","test:coverage":"remix test --coverage"},"_npmUser":{"name":"GitHub Actions","email":"npm-oidc-no-reply@github.com","trustedPublisher":{"id":"github","oidcConfigId":"oidc:b6139f89-a088-4ac7-bd12-0ab705d58d72"}},"_resolved":"/tmp/remix-publish-data-table-sqlite-GVxakm/remix-run-data-table-sqlite-0.6.2.tgz","_integrity":"sha512-S/sBp7PU3uQMPRCuoyTFLcvZ5XE2jkcASN3VTn1xLW6hdnRI7YWLUMrrcmM9MivpirVmAeZrzUUT7z/TmlNINg==","repository":{"url":"git+https://github.com/remix-run/remix.git","type":"git","directory":"packages/data-table-sqlite"},"_npmVersion":"11.19.0","description":"SQLite database implementation for remix/data-table","directories":{},"sideEffects":false,"_nodeVersion":"24.20.0","dependencies":{"@remix-run/data-table":"^0.5.1"},"_hasShrinkwrap":false,"devDependencies":{"typescript":"^7.0.2","@types/node":"^24.6.0","@remix-run/test":"0.6.0","@remix-run/assert":"0.3.0","@remix-run/data-table":"0.5.1"},"_npmOperationalInternal":{"tmp":"tmp/data-table-sqlite_0.6.2_1788908592153_0.304186271413454","host":"s3://npm-registry-packages-npm-production"}},"0.6.3":{"_id":"@remix-run/data-table-sqlite@0.6.3","bugs":{"url":"https://github.com/remix-run/remix/issues"},"dist":{"shasum":"d8a0e899b00b662ba33be1f849812852a669ce4e","tarball":"https://registry.npmjs.org/@remix-run/data-table-sqlite/-/data-table-sqlite-0.6.3.tgz","fileCount":19,"integrity":"sha512-v1o+1xVizutsl3ykEYMJYKV0n8CHCMBUarPp59o7Da9tjhpQpXbAQS8iNVbu63KQhM3BneoWdAV8XVApuUCEHA==","signatures":[{"sig":"MEYCIQDPpgAW+ZQIXDhFJkWU2GzDI8K6TI/b9A+oaufR3LX1EgIhAKj247o2h5/5bhm/F6c2qg01KSNA/n/d64YpRFnXDgu4","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"},{"keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U","sig":"MEUCIQDJ8BiglmcBGJcE8SXFiAMcw0zqweekh4DnY6qBM+RLbwIgKG9HzGIl/7w4c+aKArzXxHiMd5qUXPZka9VmcHoteTc="}],"attestations":{"url":"https://registry.npmjs.org/-/npm/v1/attestations/@remix-run%2fdata-table-sqlite@0.6.3","provenance":{"predicateType":"https://slsa.dev/provenance/v1"}},"unpackedSize":83615},"name":"@remix-run/data-table-sqlite","type":"module","_from":"file:/tmp/remix-publish-data-table-sqlite-xB97jL/remix-run-data-table-sqlite-0.6.3.tgz","author":{"name":"Michael Jackson","email":"mjijackson@gmail.com"},"exports":{".":{"types":"./dist/index.d.ts","default":"./dist/index.js"},"./package.json":"./package.json"},"license":"MIT","scripts":{"test":"remix test","build":"tsc -p tsconfig.build.json","clean":"git clean -fdX","test:bun":"bun x --bun remix test","typecheck":"tsc --noEmit","test:coverage":"remix test --coverage"},"version":"0.6.3","_npmUser":{"name":"GitHub Actions","email":"npm-oidc-no-reply@github.com","trustedPublisher":{"id":"github","oidcConfigId":"oidc:b6139f89-a088-4ac7-bd12-0ab705d58d72"}},"homepage":"https://github.com/remix-run/remix/tree/main/packages/data-table-sqlite#readme","keywords":["remix","orm","sqlite","database","sql"],"_resolved":"/tmp/remix-publish-data-table-sqlite-xB97jL/remix-run-data-table-sqlite-0.6.3.tgz","_integrity":"sha512-v1o+1xVizutsl3ykEYMJYKV0n8CHCMBUarPp59o7Da9tjhpQpXbAQS8iNVbu63KQhM3BneoWdAV8XVApuUCEHA==","repository":{"url":"git+https://github.com/remix-run/remix.git","type":"git","directory":"packages/data-table-sqlite"},"_npmVersion":"11.19.0","description":"SQLite database implementation for remix/data-table","directories":{},"maintainers":[{"name":"mjackson","email":"mjijackson+npm@gmail.com"}],"sideEffects":false,"_nodeVersion":"24.20.0","dependencies":{"@remix-run/data-table":"^0.6.0"},"_hasShrinkwrap":false,"devDependencies":{"typescript":"^7.0.2","@types/node":"^24.6.0","@remix-run/test":"0.6.1","@remix-run/assert":"0.3.0","@remix-run/data-table":"0.6.0"},"_npmOperationalInternal":{"host":"s3://npm-registry-packages-npm-production","tmp":"tmp/data-table-sqlite_0.6.3_1789770827149_0.18474987127832487"}}},"time":{"created":"2026-02-11T23:55:50.629Z","modified":"2026-09-18T22:33:47.568Z","0.0.0":"2026-02-11T23:55:50.854Z","0.1.0":"2026-02-28T01:21:55.303Z","0.2.0":"2026-03-25T23:03:42.344Z","0.3.0":"2026-04-23T00:35:08.740Z","0.4.0":"2026-04-29T17:29:38.186Z","0.4.1":"2026-04-30T19:11:16.593Z","0.5.0":"2026-05-20T03:21:17.143Z","0.5.1":"2026-05-29T18:16:30.100Z","0.6.0":"2026-08-14T00:13:12.859Z","0.6.1":"2026-08-31T18:57:23.626Z","0.6.2":"2026-09-08T23:03:12.296Z","0.6.3":"2026-09-18T22:33:47.241Z"},"bugs":{"url":"https://github.com/remix-run/remix/issues"},"author":{"name":"Michael Jackson","email":"mjijackson@gmail.com"},"license":"MIT","homepage":"https://github.com/remix-run/remix/tree/main/packages/data-table-sqlite#readme","keywords":["remix","orm","sqlite","database","sql"],"repository":{"url":"git+https://github.com/remix-run/remix.git","type":"git","directory":"packages/data-table-sqlite"},"description":"SQLite database implementation for remix/data-table","maintainers":[{"name":"mjackson","email":"mjijackson+npm@gmail.com"}],"readme":"# data-table-sqlite\n\nSQLite database driver for [`remix/data-table`](https://github.com/remix-run/remix/tree/main/packages/data-table), backed by a synchronous SQLite client.\n\n## Features\n\n- **Native Runtime SQLite Support**: Opens a configured filename with Node's `node:sqlite` or Bun's `bun:sqlite`, or uses a compatible synchronous SQLite client\n- **Full `data-table` API Support**: Queries, relations, writes, and transactions\n- **SQLite Compiler**: SQL compilation is handled automatically for SQLite\n- **Multi-Statement Migrations**: `executeScript()` runs `up.sql` / `down.sql` files via `Database.exec()`\n- **SQLite Capabilities Enabled By Default**:\n  - `returning: true`\n  - `savepoints: true`\n  - `upsert: true`\n  - `transactionalDdl: true`\n  - `migrationLock: false`\n\n## Installation\n\n```sh\nnpm i remix\n```\n\n## Usage\n\n```ts\nimport { createSqliteDatabase } from 'remix/data-table/sqlite'\n\nlet db = createSqliteDatabase({\n  filename: 'app.db',\n  foreignKeys: true,\n})\n```\n\nThe config-backed database uses `node:sqlite` in Node.js and `bun:sqlite` in Bun. It supports `db.wipe()` and `db.reset()` because it can close and reopen the database file. Call `await db.close()` during application shutdown to release the connection and its file handle.\n\nForeign key enforcement defaults to off on every runtime. When `foreignKeys` is enabled, the database restores foreign key enforcement each time it opens the connection, including after destructive lifecycle operations.\n\nThe database also applies `pragma busy_timeout = 5000` whenever it opens the connection, so writes wait for a locked database instead of failing immediately with `SQLITE_BUSY`. Use `busyTimeout` to override the timeout in milliseconds (`0` disables the wait).\n\nYou may also pass an existing synchronous client when your application owns its lifecycle:\n\n```ts\nimport { Database } from 'bun:sqlite'\nimport { createSqliteDatabase } from 'remix/data-table/sqlite'\n\nlet sqlite = new Database('app.db')\nlet db = createSqliteDatabase(sqlite)\n\n// Leaves the supplied client open.\nawait db.close()\n\n// The application closes the client it owns.\nsqlite.close()\n```\n\nDestructive lifecycle methods are unavailable when you pass an existing client.\n\nThis is a good fit for local development, embedded deployments, and single-node services. Import any driver-specific types you need directly from your runtime's SQLite module.\n\n## Database Capabilities\n\n`data-table-sqlite` reports this capability set by default:\n\n- `returning: true`\n- `savepoints: true`\n- `upsert: true`\n- `transactionalDdl: true`\n- `migrationLock: false`\n\n## Advanced Usage\n\n### Destructive Lifecycle And Locking\n\n`db.wipe()` and `db.reset()` assume a single process owns the database file. Stop other processes before wiping: on POSIX systems another process keeps writing to the deleted inode, and on Windows an open handle blocks deletion entirely. Wiping removes the `-wal`, `-shm`, and `-journal` sidecar files along with the main database file so a freshly created database never associates with stale sidecars.\n\nSQLite migrations run without a cross-process migration lock (`migrationLock: false`), so run migrations from one process at a time.\n\n`filename` resolves against the current working directory — for `remix db` commands, wherever you invoke the CLI. Prefer absolute paths or paths derived from `import.meta.dirname`.\n\n### In-Memory Database For Tests\n\n```ts\nimport { DatabaseSync } from 'node:sqlite'\nimport { createSqliteDatabase } from 'remix/data-table/sqlite'\n\nlet sqlite = new DatabaseSync(':memory:')\nlet db = createSqliteDatabase(sqlite)\n```\n\n## Related Packages\n\n- [`data-table`](https://github.com/remix-run/remix/tree/main/packages/data-table) - Core query/relations API\n- [`data-schema`](https://github.com/remix-run/remix/tree/main/packages/data-schema) - Schema parsing and validation\n- [`data-table-postgres`](https://github.com/remix-run/remix/tree/main/packages/data-table-postgres) - PostgreSQL database driver\n- [`data-table-mysql`](https://github.com/remix-run/remix/tree/main/packages/data-table-mysql) - MySQL database driver\n\n## License\n\nSee [LICENSE](https://github.com/remix-run/remix/blob/main/LICENSE)\n","readmeFilename":"README.md"}