pg_yregress
Dev tools
testing framework
SHOW HN2023
How HN took it
5 positive, 3 neutral or asking, 0 mixed, 0 critical, out of 8 comments about the project. Thread score +0.46.
Design: 3 for, 0 againstIdea: 1 for, 0 against
The thread, comment by comment
Each row is a top-level comment and its replies, in HN's order. Select a cell to open that comment on HN.
positive neutral or mixed critical about another commenter or something else the maker
What HN said
What people liked
Reusable queries and no need to dump full SQL output into results
From 1 comment
This is such an interesting project. Having written SQL based tests with MTR, I really love the reusable queries and not having to dump the full SQL output into test results.
rxrog on HN
YAML is a good fit for this test format
From 2 comments
As much as I don’t prefer YAML, this is a very good use case for it.
vira28 on HNThis is great. Good to see standardized testing improvements to the pg_regress add-on. YAML does better than JSON when it comes to readability. To an extent, TOML as well.
vkaku on HN
IntelliJ embedded SQL support could help test authoring
From 1 comment
Fun fact: IJ has "embedded language" support, meaning it understands that some parts of yaml (and any other source code) are another source code and thus offers both syntax…
mdaniel on HN
Objections
YAML readability and type ambiguity concerns
From 2 comments
I couldn't disagree more about YAML. Semantic whitespace is unreadable, as are all the optional language elements. I've been using YAML for years and still can't read it quickly.…
smt88 on HNIt's readable, it just desperately needs type safety: https://github.com/crdoconnor/strictyaml When I read "gbq enabled: yes" I don't worry about whether it's a string or a…
hitchstory on HN
Unclear how it differs from TAP and pgTAP
From 2 comments
I am fairly newbie to the Postgres ecosystem. Explain me like I am 5 how this is better than TAP - what pains precisely this addresses
Deipayan on HNHow does this compares to pgTAP? I've been using pgTAP for a long time, how is this better?
pilotdeveloper on HN
Requests
Add IntelliJ YAML language injection helper
From 1 comment
This is incredibly useful and it'd be great to add this helper to pg_yregress to improve the experience for IntelliJ users!
yrashk on HN
Questions
How does it compare to pgTAP
From 1 comment
How does this compares to pgTAP? I've been using pgTAP for a long time, how is this better?
pilotdeveloper on HN
What pains does it address compared to TAP
From 1 comment
I am fairly newbie to the Postgres ecosystem. Explain me like I am 5 how this is better than TAP - what pains precisely this addresses
Deipayan on HN
Alternatives named
pgTAP
From 1 comment
How does this compares to pgTAP? I've been using pgTAP for a long time, how is this better?
pilotdeveloper on HN
pg_regress
From 1 comment
This is not "better than TAP" but rather better than implementing tests as captures of psql outputs as done in pg_regress. Besides that, there are other features that are harder…
yrashk on HN
MTR
From 1 comment
This is such an interesting project. Having written SQL based tests with MTR, I really love the reusable queries and not having to dump the full SQL output into test results.
rxrog on HN