node-postgres
node-postgres copied to clipboard
brianc
PostgreSQL client for node.js.
https://github.com/brianc/node-postgres/blob/master/packages/pg-connection-string/index.js 👆 The code here is not setting anything with respect to `idleTimeoutMillis`. Other parameters such as `user`, `password`, `ssl`, etc are set. Therefore when using connection string usage -...
```javascript const { Pool } = require('pg') const Cursor = require('pg-cursor') const pool = new Pool({ user: 'xxxx', password: 'xxxxx', database: 'xxxxx', host: 'xxxxx', port: 8080, max: 20, //default 10...
I have urges to jsdoc public/exported types in this project - I enjoy the convenience of jsdoc in my IDE because it saves round-trips to documentation (or sometimes inspecting code)....
Hello. I can't configure GSS authorization to connect to the database. Does this library support this authentication method?
LISTEN/NOTIFY seems to work as expected when testing locally: every time NOTIFY is run I get a 'notification' event. However, as soon as I change to a remote DB, the...
I'm using pg v8.12.0, and I'm noticing that in some cases where I'm executing queries a timestamp (with time zone) that's expected to have a value always returns NULL. The...
## Context Closes https://github.com/brianc/node-postgres/issues/3309 Related to https://github.com/sequelize/sequelize/issues/17479 ## Approach The issue seems to be that the `_types` member of `Result` is directly overwritten by `Client.query`: https://github.com/brianc/node-postgres/blob/54eb0fa216aaccd727765641e7d1cf5da2bc483d/packages/pg/lib/client.js#L567 However, in `_checkForMultiRow`, we...
I have a large amount of UPDATE statements to make. The most efficient way I have found, however slow, is: ``` await Promise.all(largeBatchOfQueries.map(async (query) => { const client = await...
PR for Issue #3318 Issue Description: Currently, new Date(undefined) (an invalid date) is serialized as "0NaN-NaN-NaNTNaN:NaN:NaN.NaN+NaN:NaN". It should fail early with a JS error instead of being passed to the...
