Top all-time · #7008
SQL Blog on LearnSQL.com
Company blog · learnsql.com/blogprogrammingdata
SQL Blog on LearnSQL.com is the company blog at learnsql.com, writing about programming and data. Since 2020, 11 different Hacker News readers have linked it 11 times. It is still writing: the last post was on 2026-06-30, and you can follow it by feed.
Too few sampled comments (7) to say how often HN recommends it.?
Why HN links it
HN readers link LearnSQL's blog as a reference for SQL concepts such as views, CTEs, NULL handling, order of operations and the history of SQL standards. One commenter used it to train a junior developer.
Summarised by Claude from a sample of 7 HN comments that link here. Each comment is marked recommending, critical or neutral (citing without judging); how this works.
Learn the SQL standard and other SQL dialects comprehensively or simply upskill yourself with our interactive online SQL courses.
What Hacker News says?
Or you could have views with `deleted_at` filtered out: https://learnsql.com/blog/sql-view/
Comment linking /blog/sql-view/
on “You might as well timestamp it”Submitted How to Calculate the Difference Between Two Timestamps in SQLite as a story · 3 points
HN discussionYes, I think so, at least according to: https://learnsql.com/blog/history-of-sql-standards/ What makes you think otherwise?
Comment linking /blog/history-of-sql-standards/
on “SQL language proposal: JOIN FOREIGN”Submitted History of SQL (2020) as a story · 2 points
HN discussionI recently had to train my new junior to level his SQL skills and I found this resource pretty helpful to make sense of this mess. https://learnsql.com/blog/sql-order-of-operations/ However I do also see the point of "SELECT first" just like a header you can infer the output data structure of a sub-expression without necessarily dive into the meat of it. It require a some brain training, but once you get there it of…
Comment linking /blog/sql-order-of-operations/
on “How and why the Relational Model works for databases”Submitted SQL Window Functions Cheat Sheet as a story · 2 points
HN discussionHere's an article with some examples: https://learnsql.com/blog/sql-subquery-cte-difference/ You can think of CTEs as a way to save an intermediate query as a sort of temp variable/table that can be used in the final statement following `WITH something AS (...)`. They are great for flattening your queries and giving descriptive names to subqueries, and you can chain multiple WITHs together as well.
Comment linking /blog/sql-subquery-cte-difference/
on “Challenges students face when learning to work with relational databases and SQL”Submitted The History of Slonik, the PostgreSQL Elephant Logo as a story · 1 points
HN discussionI learned SQL on a need to know basis. For me, recursive queries were the ones that needed the most time to click. Another one that caught me by surprise was NULL vs unknown[1]. That bit me in a couple of queries. [1]: https://learnsql.com/blog/understanding-use-null-sql/
Comment linking /blog/understanding-use-null-sql/
on “Challenges students face when learning to work with relational databases and SQL”> What's PostgreSQL comparable list? I'm sure that others can comment on that, but in my experience PL/pgSQL is the killer feature that's hard to beat in PostgreSQL, for those cases where you want to store some amount of logic in the database itself (MySQL stored procedures feel a bit more limited). That said, it's not even the only procedural language that is available: https://www.postgresql.org/docs/current/xplan…
Comment linking /blog/companies-that-use-postgresql-in-business/
on “MySQL for Developers”CTE = common table expression, i.e. a WITH clause (possibly recursive) before your SELECT (or other) statement. https://learnsql.com/blog/what-is-common-table-expression/
Comment linking /blog/what-is-common-table-expression/
on “Ask HN: How do you test SQL?”