Mordechai Meisels
Mordechai Meisels
@NelsonMK The code snippet was wrong. I updated the example.
Wow @romeerez , as always you rock!
Curious, what's the benefit of using `row_number()` window function over `distinct(id)`?
If row number doesn't enforce distinctiveness, then why is it there in first place? This was how I interpreted partitioning by id and selecting the first row. I thought it's...
Is this on the agenda? It would be a killer feature. Thank you. (Sorry, I don't like these comments on oss, but I can't contribute myself because the ts code...
Oh, I see multi statement queries are not allowed by the driver. Disregard then. ------ > To clarify, it's for such use case, right? Precisely, I was using the name...
I reread your comment, you are saying that node-pg doesn't allow queries in parallel even if they are separate queries? Does this mean Promise.all has zero effect? This is bad,...
Thank you for your detailed explanation. I did get the warnings when updating many rows with different values inside a single transaction. So this explains it all. Sentry has special...
Btw my initial idea was to batch all queries into a single multi-statement query (separated with semicolons), resulting in a single round trip. But even if this isn't possible at...
I read on the docs, the protocol you're referring to is called pipelining. https://github.com/brianc/node-postgres/issues/2646 There seems to be an open issue in node-pg for several years to support pipelining. Unfortunately...