postgres

postgres copied to clipboard

I have a load of simple queries to define, each returning one or many models which I have Typescript types for. At present I’m doing something like: ```typescript findById: async...

danhalliday

Feature Request / Idea: PGlite integration?

6

## Description Support [PGLite](https://pglite.dev/docs/) (wasm postgres) ## Motivation Allows user to use this library (postgres) with local version of postgres without needing to install postgres directly on their computer or...

cliffordfajardo

Fails with `Error: The script will never generate a response.` on cloudflare pages

2

This is similar to #865, however unlike in that issue I create the postgres client on each request and still get following error on cloudflare pages with `"compatibility_flags": ["nodejs_compat"]` ```...

abhishiv

Hey, Thanks for making this library, it's very nice! I believe I've found a deadlock when a cursor is used in a transaction and queries are issued on the same...

k0nserv

Interpolated named parameters for function calls

6

Postgres supports calling functions using a "named parameter" notation since (it looks like) version 13: [4.3. Calling Functions](https://www.postgresql.org/docs/17/sql-syntax-calling-funcs.html). This is a feature request to support named parameters in interpolations when...

ferdv

Deadlocked/hung pool when connected to Postgres through Supavisor

4

Hey @porsager, thanks for the package. Creating this issue mostly in hopes that someone else has ran into this issue. We use Supabase for our Postgres DB and connect through...

nikhilro

I have a table with a column of type `smallint[]`. When a value within the array is `NULL`, Postgres.js maps it to `NaN`. I would like it to map to...

adamgreg

Improper handling of `to_timestamp` times

2

Code ``` await sql` INSERT INTO table_name ${sql(inputData)} ` ``` Postgres.js debug output ``` SQL: INSERT INTO table_name ("start_time")values($1) Params: [ 'to_timestamp(3213213210)' ] node:internal/process/promises:289 triggerUncaughtException(err, true /* fromPromise */); ^...

sbussard-inversemetric

Error: Client network socket disconnected before secure TLS connection was established. I guess it's because of `sslmode=require`.

zhang-wenchao

I was trying to get something like the following MERGE statement running: ```js const rows = [ { id: 1, name: "Ana" }, { id: 2, name: "Peter" }, ]...

Sebbones