HN Hall of Fame Weekly email

PostgreSQL Exercises

pgexercises.com Books & learning Tutorials & guides Software engineering Candidate
Screenshot of pgexercises.com captured 2026-07-20
Page preview · captured 2026-07-20

Resurfaced independently across 4 calendar years, with breakout response in 2 of them.

submissions
4
submitters
4
observed span
2016–2024
peak thread · 70 comments
576 pts
latest 20+ return · 2017-12-06
420 pts

Submission timeline

2007–2026

One slot for every year since HN launched. Height is that year's peak points; orange marks a 100+ point or 50+ comment breakout. Select a bar to open its strongest thread.

First comments on top threads

HN comment order

Really cool! One suggestion: it would be great to have the schema of the table(s) you need to query against shown above the sandbox for each exercise. The pop-up window is great but I don't have enough screen space to keep it open and refer back to it while writing a solution.

Very impressive! Works well, nice UI, informative. After doing a couple exercises what I don't like is the naming convention. Something like "montlymaintenance" or "recommendedby" are just hard to read and type and I'd much rather use snake-case and/or shorter names. Eg. "monthly_maintenance" or "maintenance_per_month" or just "maintenance" if it's explicit enough that it's always per month. Also to me using shorthands for ids is a bit hmm hmm I mean sure you write them a lot so it's useful…

tekkk·420-point thread·

The first top-level comment from each of the four biggest threads, in HN’s own order. Excerpts are shortened; open a comment for full context.

Breakout years
2

100+ points or 50+ comments

Total points
1001

reference only — not used in Hall rules or ranking

Total comments
116

reference only — not used in Hall rules or ranking

Every submission

DateTitle as submittedByPointsComments
2016-07-02PostgreSQL ExercisesFirst breakout · Best threadtrymas57670
2017-12-06PostgreSQL ExercisesLatest 20+ point returnpvsukale342046
2019-05-03PostgreSQL Exercisesbacondude320
2024-05-13PostgreSQL ExercisesTomte30