Top all-time · #23943
Andrew Bender
Personal blog · bender.ioprogrammingdata
Andrew Bender's personal blog at bender.io covers programming and data. Since 2014, 3 different Hacker News readers have linked it 3 times. The last post was in 2016, but the archive is still widely read.
Too few sampled comments (1) to say how often HN recommends it.?
Why HN links it
Andrew Bender's Modern SQL post on WITH clauses for organizing complex queries. The one comment uses the thread to ask about returning one-to-many joined arrays alongside scalars in a single SELECT, citing Postgres JSON.
Summarised by Claude from a sample of 1 HN comments that link here. Each comment is marked recommending, critical or neutral (citing without judging); how this works.
The personal technology blog of Andrew Bender
What Hacker News says?
What I really want from SQL is the ability to do a single select with one or more parts of each returned record being an array (defined by a one-to-many join) and others simple scalars. It looks like Postgres can do it [1] with its JSON capabilities, and to be honest its being a little while since I've dug into it, so things might have changed (I'm actually not even sure I'm phrasing the question correctly), but the…
Comment linking /2013/09/22/returning-hierarchical-data-in-a-single-sql-query/
on “Modern SQL: With – Organize Complex Queries”Submitted Paying Off Our Technical Debt as a story · 3 points
HN discussionSubmitted Returning Hierarchical (JSON) Data in a Single (Postgre)SQL Query[2013] as a story · 3 points
HN discussion