postgres
postgres copied to clipboard
porsager
Postgres.js - The Fastest full featured PostgreSQL client for Node.js, Deno, Bun and CloudFlare
I am currently doing something like this (https://github.com/porsager/postgres?tab=readme-ov-file#dynamic-column-selection) and is seeing the same issue mentioned in #161. I added https://github.com/porsager/postgres?tab=readme-ov-file#custom-types but can't see how I can make it work with...
if write `const cdb = await sql`INSERT INTO base ${ sql(data, columns) }`` then VS code think this is an error and show the red line How this to correct?...
Hi I am trying to use sql.unsafe with arguments, but I found one issue This works fine ``` const res = await sql.unsafe(`SELECT * from events WHERE id = $1`,...
nothing to do with real postgres transactions but logically it should be great to be able to imbricate transactions inside the code. just add something like ``` transactionSql.begin = (...
Related to but different than #815 ``` const pgsql = postgres({ host: "host1,host2,host3", port: 5432, user: "username", password: "password", database: "app", target_session_attrs: primary, max: 20, connect_timeout: 3 }); ``` when...
I try to set `postgresql://user@localhost/db?host=/run/postgresql` and `postgresql:///db?host=/run/postgresql` but seems it doesn't work. You get replace all query parameters [here](https://github.com/porsager/postgres/blob/master/src/index.js#L540) Specification: https://www.postgresql.org/docs/current/libpq-connect.html#LIBPQ-CONNSTRING-URIS You can use [pg-connection-string](https://github.com/brianc/node-postgres/tree/master/packages/pg-connection-string) package but actually we can...
I'm currently implementing CDC in a web application on top of postgres. I want to: - Fetch the users table - Be notified whenever the users table changes and update...
