{"_id":"@remix-run/data-table-postgres","_rev":"11-2c9a6de9249e2facba63157205374e58","name":"@remix-run/data-table-postgres","dist-tags":{"latest":"0.5.3"},"versions":{"0.0.0":{"name":"@remix-run/data-table-postgres","version":"0.0.0","keywords":["remix","placeholder"],"license":"MIT","_id":"@remix-run/data-table-postgres@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-postgres#readme","bugs":{"url":"https://github.com/remix-run/remix/issues"},"dist":{"shasum":"99b204431346beeacd488b176bb067cda13d3eca","tarball":"https://registry.npmjs.org/@remix-run/data-table-postgres/-/data-table-postgres-0.0.0.tgz","fileCount":2,"integrity":"sha512-Cm+zu0zI82KrEyAuKAC0bZyzCmwkCHqjfuUR8iqWG27nxEvZsVTHEUbYPcguJgAIWS+lbrtwrR9kL5n7guEPPQ==","signatures":[{"sig":"MEYCIQChrtwsFturs/MohFwNJsamefbdGEmb4FjtCY05P5y7vwIhANohwJdcW7qujvuPuiYrUg+q2HlhmAkOJoXPu52CpA5X","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":643},"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-postgres"},"_npmVersion":"11.8.0","description":"Placeholder package for future Remix data-table-postgres APIs","directories":{},"_nodeVersion":"24.2.0","publishConfig":{"access":"public"},"_hasShrinkwrap":false,"_npmOperationalInternal":{"tmp":"tmp/data-table-postgres_0.0.0_1770854147086_0.3828309960964025","host":"s3://npm-registry-packages-npm-production"}},"0.1.0":{"name":"@remix-run/data-table-postgres","version":"0.1.0","keywords":["remix","orm","postgres","database","sql"],"author":{"name":"Michael Jackson","email":"mjijackson@gmail.com"},"license":"MIT","_id":"@remix-run/data-table-postgres@0.1.0","maintainers":[{"name":"mjackson","email":"mjijackson+npm@gmail.com"}],"homepage":"https://github.com/remix-run/remix/tree/main/packages/data-table-postgres#readme","bugs":{"url":"https://github.com/remix-run/remix/issues"},"dist":{"shasum":"ddb73e70ab13c9d86cd0ee02b096d252ed3e37b8","tarball":"https://registry.npmjs.org/@remix-run/data-table-postgres/-/data-table-postgres-0.1.0.tgz","fileCount":15,"integrity":"sha512-mqzARY5tOFVLjFAArryuLQ93M8IdjVnLKnD1VQyJHFbHQF7Zbr8+exv7Hp2hZ1TIGAhZiepGjjC8Re631yJ1Jw==","signatures":[{"sig":"MEQCIBD6q+whLcAc4bBJMcRZYenUZ3i25pTHpgflQxTFVJX3AiBN52IBKjpDJy8jJT3sywQsLwagnPnGk4I/6Nz80OY6qQ==","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"attestations":{"url":"https://registry.npmjs.org/-/npm/v1/attestations/@remix-run%2fdata-table-postgres@0.1.0","provenance":{"predicateType":"https://slsa.dev/provenance/v1"}},"unpackedSize":53295},"type":"module","_from":"file:remix-run-data-table-postgres-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:ebc343a4-e350-4099-b0bc-29f1b553d0e5"}},"_resolved":"/tmp/3ca1610c4195ed34c2ed2cd078ba9853/remix-run-data-table-postgres-0.1.0.tgz","_integrity":"sha512-mqzARY5tOFVLjFAArryuLQ93M8IdjVnLKnD1VQyJHFbHQF7Zbr8+exv7Hp2hZ1TIGAhZiepGjjC8Re631yJ1Jw==","repository":{"url":"git+https://github.com/remix-run/remix.git","type":"git","directory":"packages/data-table-postgres"},"_npmVersion":"11.10.1","description":"PostgreSQL adapter for @remix-run/data-table","directories":{},"sideEffects":false,"_nodeVersion":"25.7.0","dependencies":{"@remix-run/data-table":"^0.1.0"},"_hasShrinkwrap":false,"devDependencies":{"pg":"^8.16.3","@types/pg":"^8.15.6","@types/node":"^24.6.0","@remix-run/data-table":"0.1.0","@remix-run/data-schema":"0.1.0","@typescript/native-preview":"7.0.0-dev.20251125.1"},"peerDependencies":{"pg":"^8.16.3"},"peerDependenciesMeta":{"pg":{"optional":true}},"_npmOperationalInternal":{"tmp":"tmp/data-table-postgres_0.1.0_1772241709806_0.3537948027772482","host":"s3://npm-registry-packages-npm-production"}},"0.2.0":{"name":"@remix-run/data-table-postgres","version":"0.2.0","keywords":["remix","orm","postgres","database","sql"],"author":{"name":"Michael Jackson","email":"mjijackson@gmail.com"},"license":"MIT","_id":"@remix-run/data-table-postgres@0.2.0","maintainers":[{"name":"mjackson","email":"mjijackson+npm@gmail.com"}],"homepage":"https://github.com/remix-run/remix/tree/main/packages/data-table-postgres#readme","bugs":{"url":"https://github.com/remix-run/remix/issues"},"dist":{"shasum":"8efed21fab9c9947dcbae742ab19084652d8d486","tarball":"https://registry.npmjs.org/@remix-run/data-table-postgres/-/data-table-postgres-0.2.0.tgz","fileCount":15,"integrity":"sha512-03v+zpWL4lMJr34PZ76PWFpjIa4K6Uq3NLBqyvN4ojPpm6J7TGsFwPy6sInRm3HjoS4gPSCEmmQ7dUovWa58EA==","signatures":[{"sig":"MEUCIQDLtk/4DN6VTdGrTSJO5RZF38z1s53HKTSV4l70BNKt5gIgUn3q86oa8M5qaKFs/IcPO7UvxVKjtq8UYtaWJjfSmaA=","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"attestations":{"url":"https://registry.npmjs.org/-/npm/v1/attestations/@remix-run%2fdata-table-postgres@0.2.0","provenance":{"predicateType":"https://slsa.dev/provenance/v1"}},"unpackedSize":93544},"type":"module","_from":"file:remix-run-data-table-postgres-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:ebc343a4-e350-4099-b0bc-29f1b553d0e5"}},"_resolved":"/tmp/b12c55cba09f58cb5722a212ff8a9fca/remix-run-data-table-postgres-0.2.0.tgz","_integrity":"sha512-03v+zpWL4lMJr34PZ76PWFpjIa4K6Uq3NLBqyvN4ojPpm6J7TGsFwPy6sInRm3HjoS4gPSCEmmQ7dUovWa58EA==","repository":{"url":"git+https://github.com/remix-run/remix.git","type":"git","directory":"packages/data-table-postgres"},"_npmVersion":"11.9.0","description":"PostgreSQL adapter for remix/data-table","directories":{},"sideEffects":false,"_nodeVersion":"24.14.0","dependencies":{"@remix-run/data-table":"^0.2.0"},"_hasShrinkwrap":false,"devDependencies":{"pg":"^8.16.3","@types/pg":"^8.15.6","@types/node":"^24.6.0","@remix-run/data-table":"0.2.0","@typescript/native-preview":"7.0.0-dev.20251125.1"},"peerDependencies":{"pg":"^8.16.3"},"peerDependenciesMeta":{"pg":{"optional":true}},"_npmOperationalInternal":{"tmp":"tmp/data-table-postgres_0.2.0_1774479818355_0.5814885218109191","host":"s3://npm-registry-packages-npm-production"}},"0.3.0":{"name":"@remix-run/data-table-postgres","version":"0.3.0","keywords":["remix","orm","postgres","database","sql"],"author":{"name":"Michael Jackson","email":"mjijackson@gmail.com"},"license":"MIT","_id":"@remix-run/data-table-postgres@0.3.0","maintainers":[{"name":"mjackson","email":"mjijackson+npm@gmail.com"}],"homepage":"https://github.com/remix-run/remix/tree/main/packages/data-table-postgres#readme","bugs":{"url":"https://github.com/remix-run/remix/issues"},"dist":{"shasum":"7978f48f4fe9cee17711ce08d61f66776d5a2de6","tarball":"https://registry.npmjs.org/@remix-run/data-table-postgres/-/data-table-postgres-0.3.0.tgz","fileCount":15,"integrity":"sha512-YiroJ0y3l4vRZA10bytoMMm5Efn0ndtsHWRnan7LDBfXzibbzLBaTyHvk3Day0MQSnjCwUPNPyveCs5jk+DiSQ==","signatures":[{"sig":"MEQCIH1+Vuvq3EGheALxZzsVpBj0qdUikUqIhl2L/1YIQdlHAiAfILcAex8zi5kKdryLULSesMMeJ0dJaldROnfRS1vWTA==","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"attestations":{"url":"https://registry.npmjs.org/-/npm/v1/attestations/@remix-run%2fdata-table-postgres@0.3.0","provenance":{"predicateType":"https://slsa.dev/provenance/v1"}},"unpackedSize":92183},"type":"module","_from":"file:remix-run-data-table-postgres-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:ebc343a4-e350-4099-b0bc-29f1b553d0e5"}},"_resolved":"/tmp/ebd5fa434a3f0d6371a9a2714e2a1eee/remix-run-data-table-postgres-0.3.0.tgz","_integrity":"sha512-YiroJ0y3l4vRZA10bytoMMm5Efn0ndtsHWRnan7LDBfXzibbzLBaTyHvk3Day0MQSnjCwUPNPyveCs5jk+DiSQ==","repository":{"url":"git+https://github.com/remix-run/remix.git","type":"git","directory":"packages/data-table-postgres"},"_npmVersion":"11.11.0","description":"PostgreSQL adapter for remix/data-table","directories":{},"sideEffects":false,"_nodeVersion":"24.14.1","dependencies":{"@remix-run/data-table":"^0.2.0"},"_hasShrinkwrap":false,"devDependencies":{"pg":"^8.16.3","@types/pg":"^8.15.6","@types/node":"^24.6.0","@remix-run/data-table":"0.2.0","@typescript/native-preview":"7.0.0-dev.20251125.1"},"peerDependencies":{"pg":"^8.16.3"},"peerDependenciesMeta":{"pg":{"optional":true}},"_npmOperationalInternal":{"tmp":"tmp/data-table-postgres_0.3.0_1776904504308_0.44087391620640104","host":"s3://npm-registry-packages-npm-production"}},"0.3.1":{"name":"@remix-run/data-table-postgres","version":"0.3.1","keywords":["remix","orm","postgres","database","sql"],"author":{"name":"Michael Jackson","email":"mjijackson@gmail.com"},"license":"MIT","_id":"@remix-run/data-table-postgres@0.3.1","maintainers":[{"name":"mjackson","email":"mjijackson+npm@gmail.com"}],"homepage":"https://github.com/remix-run/remix/tree/main/packages/data-table-postgres#readme","bugs":{"url":"https://github.com/remix-run/remix/issues"},"dist":{"shasum":"76cf40c42aec6a96307552a4893a4ce1213c9d2c","tarball":"https://registry.npmjs.org/@remix-run/data-table-postgres/-/data-table-postgres-0.3.1.tgz","fileCount":15,"integrity":"sha512-wveXpsPwesuWtNPWrRrWq5XL4y1Jkk6uBfIYCd9twPyDOX5urCjwZzI8muPW+X1Gs3co5NWZK8+TjI0t+uYW6w==","signatures":[{"sig":"MEUCIEzwkY065xLUozuJUrr5ZW63TF56UJpQ1OX7T9RBi5gPAiEA1cIx+F881jbXGcHVsAewMAa8Ig0R/mQeCfwAFEmGVP8=","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"attestations":{"url":"https://registry.npmjs.org/-/npm/v1/attestations/@remix-run%2fdata-table-postgres@0.3.1","provenance":{"predicateType":"https://slsa.dev/provenance/v1"}},"unpackedSize":92094},"type":"module","_from":"file:remix-run-data-table-postgres-0.3.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:ebc343a4-e350-4099-b0bc-29f1b553d0e5"}},"_resolved":"/tmp/a71081155a6ad12f9066e7f2af930c5e/remix-run-data-table-postgres-0.3.1.tgz","_integrity":"sha512-wveXpsPwesuWtNPWrRrWq5XL4y1Jkk6uBfIYCd9twPyDOX5urCjwZzI8muPW+X1Gs3co5NWZK8+TjI0t+uYW6w==","repository":{"url":"git+https://github.com/remix-run/remix.git","type":"git","directory":"packages/data-table-postgres"},"_npmVersion":"11.11.0","description":"PostgreSQL adapter for remix/data-table","directories":{},"sideEffects":false,"_nodeVersion":"24.14.1","dependencies":{"@remix-run/data-table":"^0.2.1"},"_hasShrinkwrap":false,"devDependencies":{"pg":"^8.16.3","@types/pg":"^8.15.6","@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"},"peerDependencies":{"pg":"^8.16.3"},"peerDependenciesMeta":{"pg":{"optional":true}},"_npmOperationalInternal":{"tmp":"tmp/data-table-postgres_0.3.1_1777576271799_0.0016797311001066628","host":"s3://npm-registry-packages-npm-production"}},"0.4.0":{"name":"@remix-run/data-table-postgres","version":"0.4.0","keywords":["remix","orm","postgres","database","sql"],"author":{"name":"Michael Jackson","email":"mjijackson@gmail.com"},"license":"MIT","_id":"@remix-run/data-table-postgres@0.4.0","maintainers":[{"name":"mjackson","email":"mjijackson+npm@gmail.com"}],"homepage":"https://github.com/remix-run/remix/tree/main/packages/data-table-postgres#readme","bugs":{"url":"https://github.com/remix-run/remix/issues"},"dist":{"shasum":"75645a801067e985758bdf663c1f1991919d314d","tarball":"https://registry.npmjs.org/@remix-run/data-table-postgres/-/data-table-postgres-0.4.0.tgz","fileCount":15,"integrity":"sha512-aOcAYhdgJ99J+BUNrgBrD/RapQt43UbzkGUihm5zhK8S0G5I/gd+TBAw1t8vuutvSw0Zjg1cfDCBihkjMJ4uGQ==","signatures":[{"sig":"MEMCH3ZV2XG1iYSWuv2Awt62TawgIJ597GZMz/Az+zrBpnkCIEkP5++Sb/N13Fwrl1IZLqI32kn6QodKtfm+l42loTAL","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"attestations":{"url":"https://registry.npmjs.org/-/npm/v1/attestations/@remix-run%2fdata-table-postgres@0.4.0","provenance":{"predicateType":"https://slsa.dev/provenance/v1"}},"unpackedSize":73444},"type":"module","_from":"file:remix-run-data-table-postgres-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:ebc343a4-e350-4099-b0bc-29f1b553d0e5"}},"_resolved":"/tmp/3ba1c12f00e511f722ca5e09bd894f57/remix-run-data-table-postgres-0.4.0.tgz","_integrity":"sha512-aOcAYhdgJ99J+BUNrgBrD/RapQt43UbzkGUihm5zhK8S0G5I/gd+TBAw1t8vuutvSw0Zjg1cfDCBihkjMJ4uGQ==","repository":{"url":"git+https://github.com/remix-run/remix.git","type":"git","directory":"packages/data-table-postgres"},"_npmVersion":"11.12.1","description":"PostgreSQL adapter for remix/data-table","directories":{},"sideEffects":false,"_nodeVersion":"24.15.0","dependencies":{"@remix-run/data-table":"^0.3.0"},"_hasShrinkwrap":false,"devDependencies":{"pg":"^8.16.3","@types/pg":"^8.15.6","@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"},"peerDependencies":{"pg":"^8.16.3"},"peerDependenciesMeta":{"pg":{"optional":true}},"_npmOperationalInternal":{"tmp":"tmp/data-table-postgres_0.4.0_1779247271771_0.4807116099656834","host":"s3://npm-registry-packages-npm-production"}},"0.5.0":{"name":"@remix-run/data-table-postgres","version":"0.5.0","keywords":["remix","orm","postgres","database","sql"],"author":{"name":"Michael Jackson","email":"mjijackson@gmail.com"},"license":"MIT","_id":"@remix-run/data-table-postgres@0.5.0","maintainers":[{"name":"mjackson","email":"mjijackson+npm@gmail.com"}],"homepage":"https://github.com/remix-run/remix/tree/main/packages/data-table-postgres#readme","bugs":{"url":"https://github.com/remix-run/remix/issues"},"dist":{"shasum":"5122eaa8e5bd1061263fee5c28eda2da39db24d3","tarball":"https://registry.npmjs.org/@remix-run/data-table-postgres/-/data-table-postgres-0.5.0.tgz","fileCount":19,"integrity":"sha512-iQGBkxnzQbkwYB4TMilAftE+RfaJk4SxEG1IUGmSzyNlKvTjHl8mhdPUGSPxUwUl4cTPDGbY5gcqDMtbiBvQHQ==","signatures":[{"sig":"MEUCIGBjurYUTiiRhXc0UPNozX3NJbVaCp6z12XLsqdrkZsHAiEAjghj6ITH4sH2ze4wr5zJE1xF4vtCzx6o57Enf+E6AaE=","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"attestations":{"url":"https://registry.npmjs.org/-/npm/v1/attestations/@remix-run%2fdata-table-postgres@0.5.0","provenance":{"predicateType":"https://slsa.dev/provenance/v1"}},"unpackedSize":98519},"type":"module","_from":"file:remix-run-data-table-postgres-0.5.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:ebc343a4-e350-4099-b0bc-29f1b553d0e5"}},"_resolved":"/tmp/28544a492e4d976dc6edf697a13cfc9c/remix-run-data-table-postgres-0.5.0.tgz","_integrity":"sha512-iQGBkxnzQbkwYB4TMilAftE+RfaJk4SxEG1IUGmSzyNlKvTjHl8mhdPUGSPxUwUl4cTPDGbY5gcqDMtbiBvQHQ==","repository":{"url":"git+https://github.com/remix-run/remix.git","type":"git","directory":"packages/data-table-postgres"},"_npmVersion":"11.16.0","description":"PostgreSQL database implementation for remix/data-table","directories":{},"sideEffects":false,"_nodeVersion":"24.18.0","dependencies":{"@remix-run/data-table":"^0.4.0"},"_hasShrinkwrap":false,"devDependencies":{"pg":"^8.16.3","@types/pg":"^8.15.6","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"},"peerDependencies":{"pg":"^8.16.3"},"peerDependenciesMeta":{"pg":{"optional":true}},"_npmOperationalInternal":{"tmp":"tmp/data-table-postgres_0.5.0_1786666387845_0.69128936643632","host":"s3://npm-registry-packages-npm-production"}},"0.5.1":{"name":"@remix-run/data-table-postgres","version":"0.5.1","keywords":["remix","orm","postgres","database","sql"],"author":{"name":"Michael Jackson","email":"mjijackson@gmail.com"},"license":"MIT","_id":"@remix-run/data-table-postgres@0.5.1","maintainers":[{"name":"mjackson","email":"mjijackson+npm@gmail.com"}],"homepage":"https://github.com/remix-run/remix/tree/main/packages/data-table-postgres#readme","bugs":{"url":"https://github.com/remix-run/remix/issues"},"dist":{"shasum":"8f98709cb9ef111e5873b17a9f5c2ff34b059e4b","tarball":"https://registry.npmjs.org/@remix-run/data-table-postgres/-/data-table-postgres-0.5.1.tgz","fileCount":19,"integrity":"sha512-CsjfpEzgbHau5G3zx8cKdrXtWFraQxxDE3qolkZmRUPWw1Er8IEeURfMQGT22h+a7t5iKDH7YbRaqAAbggXI7g==","signatures":[{"sig":"MEUCIQDp14o3XcYS6oWtlX1bXQV9R4MJUO1qZuj+O378cdwndAIgWHlYaGLOdhxiGMRsqVUdghtsuBYrlVmtiHFlF0COmig=","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"attestations":{"url":"https://registry.npmjs.org/-/npm/v1/attestations/@remix-run%2fdata-table-postgres@0.5.1","provenance":{"predicateType":"https://slsa.dev/provenance/v1"}},"unpackedSize":98519},"type":"module","_from":"file:/tmp/remix-publish-data-table-postgres-xYzI8E/remix-run-data-table-postgres-0.5.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:ebc343a4-e350-4099-b0bc-29f1b553d0e5"}},"_resolved":"/tmp/remix-publish-data-table-postgres-xYzI8E/remix-run-data-table-postgres-0.5.1.tgz","_integrity":"sha512-CsjfpEzgbHau5G3zx8cKdrXtWFraQxxDE3qolkZmRUPWw1Er8IEeURfMQGT22h+a7t5iKDH7YbRaqAAbggXI7g==","repository":{"url":"git+https://github.com/remix-run/remix.git","type":"git","directory":"packages/data-table-postgres"},"_npmVersion":"11.17.0","description":"PostgreSQL database implementation for remix/data-table","directories":{},"sideEffects":false,"_nodeVersion":"24.19.0","dependencies":{"@remix-run/data-table":"^0.5.0"},"_hasShrinkwrap":false,"devDependencies":{"pg":"^8.16.3","@types/pg":"^8.15.6","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"},"peerDependencies":{"pg":"^8.16.3"},"peerDependenciesMeta":{"pg":{"optional":true}},"_npmOperationalInternal":{"tmp":"tmp/data-table-postgres_0.5.1_1788202637116_0.8864673528553166","host":"s3://npm-registry-packages-npm-production"}},"0.5.2":{"name":"@remix-run/data-table-postgres","version":"0.5.2","keywords":["remix","orm","postgres","database","sql"],"author":{"name":"Michael Jackson","email":"mjijackson@gmail.com"},"license":"MIT","_id":"@remix-run/data-table-postgres@0.5.2","maintainers":[{"name":"mjackson","email":"mjijackson+npm@gmail.com"}],"homepage":"https://github.com/remix-run/remix/tree/main/packages/data-table-postgres#readme","bugs":{"url":"https://github.com/remix-run/remix/issues"},"dist":{"shasum":"2d365a2f696bb944be4a02bdf2fd574551e43bf2","tarball":"https://registry.npmjs.org/@remix-run/data-table-postgres/-/data-table-postgres-0.5.2.tgz","fileCount":19,"integrity":"sha512-i31IweRRMVML2CNaAcfv25xcntH/lC1j4Y3Vf7UiCKVKbsxMCvDg9+t7pK8hMIpzlldGdLqNzdQ9B09uCwnajA==","signatures":[{"sig":"MEUCID8/OoBGsCgn0fSy73M1kze4BBAvnkgA1eMWztupfNATAiEAoiGCFKcHfzmQnJQT//aIEqUyFCoiugkONKtVCFs2Izs=","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"attestations":{"url":"https://registry.npmjs.org/-/npm/v1/attestations/@remix-run%2fdata-table-postgres@0.5.2","provenance":{"predicateType":"https://slsa.dev/provenance/v1"}},"unpackedSize":98519},"type":"module","_from":"file:/tmp/remix-publish-data-table-postgres-zgWeoc/remix-run-data-table-postgres-0.5.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:ebc343a4-e350-4099-b0bc-29f1b553d0e5"}},"_resolved":"/tmp/remix-publish-data-table-postgres-zgWeoc/remix-run-data-table-postgres-0.5.2.tgz","_integrity":"sha512-i31IweRRMVML2CNaAcfv25xcntH/lC1j4Y3Vf7UiCKVKbsxMCvDg9+t7pK8hMIpzlldGdLqNzdQ9B09uCwnajA==","repository":{"url":"git+https://github.com/remix-run/remix.git","type":"git","directory":"packages/data-table-postgres"},"_npmVersion":"11.19.0","description":"PostgreSQL database implementation for remix/data-table","directories":{},"sideEffects":false,"_nodeVersion":"24.20.0","dependencies":{"@remix-run/data-table":"^0.5.1"},"_hasShrinkwrap":false,"devDependencies":{"pg":"^8.16.3","@types/pg":"^8.15.6","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"},"peerDependencies":{"pg":"^8.16.3"},"peerDependenciesMeta":{"pg":{"optional":true}},"_npmOperationalInternal":{"tmp":"tmp/data-table-postgres_0.5.2_1788908585090_0.9005502075006295","host":"s3://npm-registry-packages-npm-production"}},"0.5.3":{"_id":"@remix-run/data-table-postgres@0.5.3","bugs":{"url":"https://github.com/remix-run/remix/issues"},"dist":{"shasum":"e48175bee473cf38038f258e8003e3817c58d1ad","tarball":"https://registry.npmjs.org/@remix-run/data-table-postgres/-/data-table-postgres-0.5.3.tgz","fileCount":19,"integrity":"sha512-yJSm3aIuiA3wmg9+idwXq+YLxxkF6DlLwJJCkZ5bjIrW+d2BY00k6pDKFYQucwJrb4ULl54HBof6qYsJ6W3gmw==","signatures":[{"sig":"MEYCIQDrt+ISsUNM5BjzeIITAiAdyxCVBICeKV1SYfRQUuhjaQIhAP1erCbUhB6VbUQfsOOd7FUsYdZ94crwD7seZTn9+C14","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"},{"keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U","sig":"MEUCIEh2eA2SjklkSjteHgflBjqnBbIPX1yaqO/WQVDE+XY2AiEA4FE5R/4Bqxkk9tpwim4AoMcCjP/ljGixFEKPwtJLCk0="}],"attestations":{"url":"https://registry.npmjs.org/-/npm/v1/attestations/@remix-run%2fdata-table-postgres@0.5.3","provenance":{"predicateType":"https://slsa.dev/provenance/v1"}},"unpackedSize":98594},"name":"@remix-run/data-table-postgres","type":"module","_from":"file:/tmp/remix-publish-data-table-postgres-HoxAQN/remix-run-data-table-postgres-0.5.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.5.3","_npmUser":{"name":"GitHub Actions","email":"npm-oidc-no-reply@github.com","trustedPublisher":{"id":"github","oidcConfigId":"oidc:ebc343a4-e350-4099-b0bc-29f1b553d0e5"}},"homepage":"https://github.com/remix-run/remix/tree/main/packages/data-table-postgres#readme","keywords":["remix","orm","postgres","database","sql"],"_resolved":"/tmp/remix-publish-data-table-postgres-HoxAQN/remix-run-data-table-postgres-0.5.3.tgz","_integrity":"sha512-yJSm3aIuiA3wmg9+idwXq+YLxxkF6DlLwJJCkZ5bjIrW+d2BY00k6pDKFYQucwJrb4ULl54HBof6qYsJ6W3gmw==","repository":{"url":"git+https://github.com/remix-run/remix.git","type":"git","directory":"packages/data-table-postgres"},"_npmVersion":"11.19.0","description":"PostgreSQL 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":{"pg":"^8.16.3","@types/pg":"^8.15.6","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"},"peerDependencies":{"pg":"^8.16.3"},"peerDependenciesMeta":{"pg":{"optional":true}},"_npmOperationalInternal":{"host":"s3://npm-registry-packages-npm-production","tmp":"tmp/data-table-postgres_0.5.3_1789770820081_0.9714643738786226"}}},"time":{"created":"2026-02-11T23:55:46.936Z","modified":"2026-09-18T22:33:40.488Z","0.0.0":"2026-02-11T23:55:47.225Z","0.1.0":"2026-02-28T01:21:49.973Z","0.2.0":"2026-03-25T23:03:38.503Z","0.3.0":"2026-04-23T00:35:04.554Z","0.3.1":"2026-04-30T19:11:11.960Z","0.4.0":"2026-05-20T03:21:11.993Z","0.5.0":"2026-08-14T00:13:08.010Z","0.5.1":"2026-08-31T18:57:17.239Z","0.5.2":"2026-09-08T23:03:05.286Z","0.5.3":"2026-09-18T22:33:40.166Z"},"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-postgres#readme","keywords":["remix","orm","postgres","database","sql"],"repository":{"url":"git+https://github.com/remix-run/remix.git","type":"git","directory":"packages/data-table-postgres"},"description":"PostgreSQL database implementation for remix/data-table","maintainers":[{"name":"mjackson","email":"mjijackson+npm@gmail.com"}],"readme":"# data-table-postgres\n\nPostgreSQL database driver for [`remix/data-table`](https://github.com/remix-run/remix/tree/main/packages/data-table), backed by `pg`.\n\n## Features\n\n- **Native `pg` Integration**: Creates a pool from `pg` configuration or uses an existing pool or client\n- **Full `data-table` API Support**: Queries, relations, writes, and transactions\n- **PostgreSQL Compiler**: SQL compilation is handled automatically for PostgreSQL\n- **Multi-Statement Migrations**: `executeScript()` runs `up.sql` / `down.sql` files natively via `pg`\n- **Postgres Capabilities Enabled By Default**:\n  - `returning: true`\n  - `savepoints: true`\n  - `upsert: true`\n  - `transactionalDdl: true`\n  - `migrationLock: true`\n\n## Installation\n\n```sh\nnpm i remix pg\n```\n\n## Usage\n\n```ts\nimport { createPostgresDatabase } from 'remix/data-table/postgres'\n\nlet db = createPostgresDatabase({\n  connectionString: process.env.DATABASE_URL,\n})\n```\n\nUse `db.query(...)`, relation loading, and transactions from `remix/data-table`. Import any driver-specific types you need directly from `pg`.\n\nConfig-backed databases support `db.wipe()` and `db.reset()`. Call `await db.close()` during application shutdown to close the internally created pool. You may pass an existing `pg` pool or client when your application owns the driver lifecycle; `db.close()` leaves supplied clients alone, and destructive lifecycle methods are unavailable in that mode. `db.wipe()` requires a database name resolvable from the connection config (`database`, the path of `connectionString`, or the `PGDATABASE` environment variable) and throws when none is present.\n\nMigration runs reserve one connection for the PostgreSQL advisory lock, migration SQL, and journal updates. Lock acquisition waits up to 60 seconds (via `lock_timeout`) and fails with an error instead of blocking forever. After a successful run the connection is unlocked and returned to the pool; if the migration or unlock fails, the reserved connection is destroyed instead of being reused, so a dirty session can never leak back into the pool. Nested migration lock acquisition throws instead of deadlocking.\n\n## Database Capabilities\n\n`data-table-postgres` reports this capability set by default:\n\n- `returning: true`\n- `savepoints: true`\n- `upsert: true`\n- `transactionalDdl: true`\n- `migrationLock: true`\n\n## Advanced Usage\n\n### Transaction Options\n\nTransaction options are passed through to PostgreSQL as hints.\n\n```ts\nawait db.transaction(async (txDb) => txDb.exec('select 1'), {\n  isolationLevel: 'serializable',\n  readOnly: false,\n})\n```\n\n## Running integration tests locally\n\nTo start a local Postgres container matching CI:\n\n```sh\npodman run --name postgres \\\n  -e POSTGRES_USER=postgres \\\n  -e POSTGRES_PASSWORD=postgres \\\n  -e POSTGRES_DB=remix \\\n  -p 5432:5432 \\\n  -d postgres:16\n```\n\nThen run:\n\n```sh\nREMIX_DATA_TABLE_POSTGRES_TEST_URL=postgres://postgres:postgres@127.0.0.1:5432/remix \\\npnpm test src/lib/driver.integration.test.ts\n```\n\nRemove the container when you are done:\n\n```sh\npodman rm -f postgres\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-mysql`](https://github.com/remix-run/remix/tree/main/packages/data-table-mysql) - MySQL database driver\n- [`data-table-sqlite`](https://github.com/remix-run/remix/tree/main/packages/data-table-sqlite) - SQLite database driver\n\n## License\n\nSee [LICENSE](https://github.com/remix-run/remix/blob/main/LICENSE)\n","readmeFilename":"README.md"}