postgres

postgres copied to clipboard

Hi, I have a huge application and I'm migrating the code from "brianc/node-postgres" to "porsager/postgres", I have some question. **FIRST QUESTION** I'm replace all query method of "brianc/node-postgres" ([docs](https://node-postgres.com/apis/client#clientquery)) with...

cesco69

I have a dynamic array of conditions ``` const conditions = [ sql`age > 1`, sql`height < 170`, sql`hair_color = 'red'` ] ``` I would like to join al of...

NPrada

Improve `onnotice` to actually not log anything when its config value is `false`

1

This options can also accept false as a value, not only a function

hughcrt

Connect-Timeout Behavior - Include Waiting for Connection Pool

1

We need our data-access code to be within a timeout. Currently, it seems the connect-timeout setting and behavior doesn't account for the time it takes for a connection to be...

nir-bar-zvi

Not available on jsr.io

9

shivajivarma

Error while inserting a JSON array (if object contains the key "type")

2

Hi, everyone，I encountered a strange phenomenon: if the array object contains the key **"type"**, an error occurs during insertion. Reproduction Code --- ```js const postgres = require('postgres'); const sql =...

VxRain

Using `postgres({types: {bigint: postgres.BigInt}})` I am able to read both `int8` and `int8[]` values as `bigint`s. I can also input values using `string[]` parameters for the latter. However, I get...

darkgnotic

I am trying to store tile data to table using postgis-raster type for tile data. ``` const tile_data = Buffer.from(await res.arrayBuffer()) await db`INSERT INTO ${db(sourceSpec.table)} (z, x, y, tile_data) VALUES...

terion-name

Ability to inspect query fragments without database connection

1

Thanks for building this library, it's very impressive and I'm enjoying using it so far. It would be very helpful if I could unit test some of my query-generating functions...

wms

arbitrary stuck queries

16

We have an issue, where the sql client just does not respond. In other words, the promise does not resolve nor reject. The application has peaks with lots of concurrent...

JuHwon