Rasmus Porsager comments

Results 316 comments of


                                            Rasmus Porsager

add error handler to subscribe

This already seems to be merged, so I don't understand why the PR is still open.

How do I use named Prepared Statements, with variables

Postgres.js implicitly creates prepared statements itself, so I'm not sure you even need to? Can you expand on what the purpose is?

How do I use named Prepared Statements, with variables

No, but why don't you just run the query like: ```js const xs = await sql` select * from db.table where id = ANY(${ ids }) for update skip locked...

How do I use named Prepared Statements, with variables

Search for sql.unsafe 😉

deno: move from std node polyfills to `node:` specifier

I'm thinking a hard cut in v4 where we just remove the deno polyfill completely if possible?

`subscribe` causes WAL bloating when no changes being made on publishing tables.

Hi @Louis-Tian What a nice report! I'm a bit pressed for time, but should hopefully have time to look closer later this week.

sql.join() for building dynamic queries

Yeah, I think it makes sense to add, but I've just been doing this when needed ```js xs.flatMap((x, i) => i ? [sql`, `, x] : x) ``` You can...

Remove FLUSH from CF integration

Interesting. During my initial testing there was a noticeable perf difference directly against PostgreSQL. Even so, the cloudflare code you edited is generated from `src/` (`npm run build:cf`), so this...

Remove FLUSH from CF integration

Yeah, check out https://github.com/porsager/postgres-benchmarks

Remove FLUSH from CF integration

Interesting. Can you check if your PR makes sense on: https://github.com/porsager/postgres/pull/392 ?