Results 591 comments of Stephen Haberman

Tracing might be an issue... https://github.com/porsager/postgres/issues/461 https://github.com/DataDog/dd-trace-js/issues/2644 https://github.com/DataDog/dd-trace-js/blob/master/packages/datadog-instrumentations/src/pg.js https://github.com/open-telemetry/opentelemetry-js-contrib/blob/main/plugins/node/opentelemetry-instrumentation-pg/src/instrumentation.ts

More thoughts/cons: * postgres.js maintainer is unresponsive on several key issues like APM support * tbf the node-pg maintainer pays attention in spurts too--that's just open source * postgres.js has...

Every postgres.js query uses these regexes to detect "what query are you doing?" and drive it's magic query building: ![Image](https://github.com/user-attachments/assets/7b040c64-cc53-45b5-be95-57fa30e14473) Which is why this query breaks: ```ts await txn`DELETE FROM...

The initial spike is not going to use postgres.js's prepared statements, b/c we go through `sql.unsafe`, so they don't see the queries as "static". We'll have to rewrite things to...

Another stack trace that doesn't go all the way out: ![Image](https://github.com/user-attachments/assets/e4fb6bf2-5413-4367-8328-5cf070499ba6)

We should try and use a single parameter: ```sql -- 1. Prepare a statement that accepts a single text parameter (JSON): PREPARE my_query (text) AS WITH input_rows AS ( --...

I have things basically working, with the following disclaimers: * postgres.js has several large, annoying bugs, such as: * https://github.com/porsager/postgres/issues/471 which sends `[true, false]` to postgres as always-a-boolean, and breaks...

Running into some array encoding issues with Bun.sql as well: https://github.com/oven-sh/bun/issues/17798

@JakobJingleheimer adding more data points from our use case, our test suite has 1,250 individual test files (`*.test.ts`), the majority of which use a database connection. Today with Jest, we...

Right, the difference is whether the setup cost is once per "change to the migrations/schema" (after which the engineer manually runs `yarn db-setup`) or once for *every single invocation to...