node-postgres
node-postgres copied to clipboard
brianc
PostgreSQL client for node.js.
To reproduce: ```js const assert = require("assert"); const { Client } = require("pg"); const pg = new Client("postgres://prisma:prisma@localhost:5432/tests"); async function main() { await pg.connect(); try { const result = await...
improve example with parsing connection string for pg-pool, use URL constructor, available since node 10 https://developer.mozilla.org/en-US/docs/Web/API/URL/URL
I'm setting the Node-Postgres Pool parameter ssl.mode to disabled via an environment variable. However I'm get the error: ```sh "name":"Error","message":"The server does not support SSL connections","stack":"Error: The server does not...
Hey there and thank you for you time! I have a question about using connection pool. The idea is to pass some configuration to all clients inside that pool, specifically...
I try end a connection when end all tasks, by example: ``` const { Client } = require('pg'); const client = new Client({ .... }); client.connect() .then(() => client.query('SELECT 1'))...
Obviously the pool is great when you're trying to limit concurrent connections to a single database. But in the scenario where your app is simultaneously reaching out to multiple databases...
Node.js version: 14.17.0 pg version: 8.6.0 other related packages: ``` "pg-connection-string": "^2.5.0", "pg-pool": "^3.3.0", "pg-protocol": "^1.5.0", ``` code: ``` const options = { connectionString: 'postgres://username:password@host:port/dbname?sslmode=verify-full', connectionTimeoutMillis: 50000, query_timeout: 50000, ssl:...
Fix for #1674, alternative to https://github.com/brianc/node-postgres/pull/2832.
It would be useful, for example, to enforce that clients connect using UTC. Currently I believe you'd have to pass the string argument, and even then I think it might...
Cherry-picks https://github.com/iceddev/pg-connection-string/pull/39 to this monorepo.
