{"_id":"@alt-javascript/jsdbc-pg","_rev":"3-c21aaf6e4d7cc19dc6f7392bccfaafa7","name":"@alt-javascript/jsdbc-pg","dist-tags":{"latest":"1.2.0"},"versions":{"1.0.0":{"name":"@alt-javascript/jsdbc-pg","version":"1.0.0","keywords":["jsdbc","jdbc","database","postgresql","postgres","pg","driver"],"author":{"name":"Craig Parravicini"},"license":"MIT","_id":"@alt-javascript/jsdbc-pg@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/pg#readme","bugs":{"url":"https://github.com/alt-javascript/jsdbc/issues"},"dist":{"shasum":"930917873f43350f71ac8a829eca4b506dd76d73","tarball":"https://registry.npmjs.org/@alt-javascript/jsdbc-pg/-/jsdbc-pg-1.0.0.tgz","fileCount":8,"integrity":"sha512-6NvV5S1N5fE3PBFOwF7rRFIsdJLn7wp8cGQD5kuJeuiZk8KH/5BRSK5UKyPQVk3SXRTlvioXIZjf2o4k7AT8lg==","signatures":[{"sig":"MEQCIFwWn43BiJ7kVl4cwbWMMnCq1oIYBcnVhnhQYlyc83AZAiAG1jadHw7rBTTjOY+nla7x7sHbERn3a/EdXpNsjUmrJw==","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":7663},"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/pg"},"_npmVersion":"11.12.0","description":"JSDBC driver for PostgreSQL via pg","directories":{},"_nodeVersion":"24.14.0","dependencies":{"pg":"^8.13.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-pg_1.0.0_1773967817160_0.15590525069918404","host":"s3://npm-registry-packages-npm-production"}},"1.1.1":{"name":"@alt-javascript/jsdbc-pg","version":"1.1.1","keywords":["jsdbc","jdbc","database","postgresql","postgres","pg","driver"],"author":{"name":"Craig Parravicini"},"license":"MIT","_id":"@alt-javascript/jsdbc-pg@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/pg#readme","bugs":{"url":"https://github.com/alt-javascript/jsdbc/issues"},"dist":{"shasum":"970a07ad6d5c071d7b2fb62bdb04ad23aea4750a","tarball":"https://registry.npmjs.org/@alt-javascript/jsdbc-pg/-/jsdbc-pg-1.1.1.tgz","fileCount":8,"integrity":"sha512-bOU6GkpDB2dCn4RAyrmZRqmq4lZIsaPUZllAn4qUB2NWhT9PcbS2lBOEnzwykAIc/2WQ7pKyy5yuQxOnxbt8QQ==","signatures":[{"sig":"MEYCIQCJzJImJPRagoMQhSEgg/YDSfNdTo1E33S86ghMpLd+8QIhAI+aF8M7RZXLQBlsuZ+xQU9cj5JbVQ1O4qpVL6Yt/ZWO","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":7663},"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/pg"},"_npmVersion":"11.12.0","description":"JSDBC driver for PostgreSQL via pg","directories":{},"_nodeVersion":"24.14.0","dependencies":{"pg":"^8.13.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-pg_1.1.1_1774504400965_0.7255936766164965","host":"s3://npm-registry-packages-npm-production"}},"1.2.0":{"name":"@alt-javascript/jsdbc-pg","version":"1.2.0","description":"JSDBC driver for PostgreSQL via pg","keywords":["jsdbc","jdbc","database","postgresql","postgres","pg","driver"],"publishConfig":{"registry":"https://registry.npmjs.org/","access":"public"},"homepage":"https://github.com/alt-javascript/jsdbc/tree/main/packages/pg#readme","repository":{"type":"git","url":"git+https://github.com/alt-javascript/jsdbc.git","directory":"packages/pg"},"type":"module","main":"index.js","scripts":{"test":"mocha --recursive test/**/*.spec.js"},"dependencies":{"@alt-javascript/jsdbc-core":"*","pg":"^8.13.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-pg@1.2.0","bugs":{"url":"https://github.com/alt-javascript/jsdbc/issues"},"_nodeVersion":"24.14.0","_npmVersion":"11.12.1","dist":{"integrity":"sha512-+2PSilNJC8xeDPNmhmmFwQIDrhAyFEAD18NtZqJeqV4t1GoyC88kGYjyJ1lAeMSPJQZtuLF6bvF3oyQxyEBlfw==","shasum":"833a9f7569e68367e841b91603b98a728982006e","tarball":"https://registry.npmjs.org/@alt-javascript/jsdbc-pg/-/jsdbc-pg-1.2.0.tgz","fileCount":8,"unpackedSize":7663,"signatures":[{"keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U","sig":"MEUCIEVd63wbG2Rj+4jAnzHn8Bx8GKIMIThd01sm7Aum+5b4AiEAwLc5+NyrHKW3YjHOVqwPmukH6GrP/NS645avZrpnvyw="}]},"_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-pg_1.2.0_1774900894974_0.5177478569806817"},"_hasShrinkwrap":false}},"time":{"created":"2026-03-20T00:50:17.043Z","modified":"2026-03-30T20:01:35.413Z","1.0.0":"2026-03-20T00:50:17.311Z","1.1.1":"2026-03-26T05:53:21.104Z","1.2.0":"2026-03-30T20:01:35.297Z"},"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/pg#readme","keywords":["jsdbc","jdbc","database","postgresql","postgres","pg","driver"],"repository":{"type":"git","url":"git+https://github.com/alt-javascript/jsdbc.git","directory":"packages/pg"},"description":"JSDBC driver for PostgreSQL via pg","contributors":[{"name":"Claude","url":"Anthropic"}],"maintainers":[{"name":"craigparra","email":"craigparra@gmail.com"}],"readme":"# @alt-javascript/jsdbc-pg\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-pg)](https://www.npmjs.com/package/@alt-javascript/jsdbc-pg)\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 PostgreSQL via [pg](https://github.com/brianc/node-postgres). Full PostgreSQL support 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-pg\n```\n\n## Usage\n\n```javascript\nimport { DataSource } from '@alt-javascript/jsdbc-core';\nimport '@alt-javascript/jsdbc-pg'; // self-registers with DriverManager\n\nconst ds = new DataSource({\n  url: 'jsdbc:pg://localhost:5432/mydb',\n  username: 'myuser',\n  password: 'mypass',\n});\n\nconst conn = await ds.getConnection();\n\nconst ps = await conn.prepareStatement('SELECT * FROM users WHERE id = ?');\nps.setParameter(1, 42);\nconst rs = await ps.executeQuery();\nconsole.log(rs.getRows());\n\nrs.close();\nawait conn.close();\n```\n\n## URL Scheme\n\n```\njsdbc:pg://<host>:<port>/<database>\n```\n\n| URL | Description |\n|---|---|\n| `jsdbc:pg://localhost:5432/mydb` | Local PostgreSQL on default port |\n| `jsdbc:pg://db.example.com:5432/prod` | Remote PostgreSQL |\n\nCredentials are passed via `DataSource` config (`username`, `password`) or embedded in the URL (`jsdbc:pg://user:pass@host:port/db`).\n\n## Placeholder Conversion\n\nJSDBC uses `?` placeholders (JDBC convention). The driver converts them to PostgreSQL's `$1`, `$2`, ... syntax automatically.\n\n```javascript\n// You write:\nconst ps = await conn.prepareStatement('SELECT * FROM users WHERE name = ? AND age > ?');\n// Driver sends: SELECT * FROM users WHERE name = $1 AND age > $2\n```\n\n## License\n\nMIT\n","readmeFilename":"README.md"}