Skip to content
HN On Hacker News ↗

Learn SQL Once, Use It for 30 Years

▲ 321 points 230 comments by karakoram 1w ago HN discussion ↗

Pangram verdict · v3.3

We believe that this document is fully AI-generated

99 %

AI likelihood · overall

AI
0% human-written 100% AI-generated
SEGMENTS · HUMAN 0 of 2
SEGMENTS · AI 2 of 2
WORD COUNT 517
PEAK AI % 99% · §1
Analyzed
Jun 4
backend: pangram/v3.3
Segments scanned
2 windows
avg 259 words each
Distribution
0 / 100%
human / AI fraction
Verdict
AI
Pangram v3.3

Article text · 517 words · 2 segments analyzed

Human AI-generated
§1 AI · 99%

The Only Programming Language Built on Mathematics, Not Fashion3 min readMay 13, 2026--A cross-section of rock strata where the upper layers are cracked and crumbling, each labeled with the names of old web technologies like jQuery, Backbone, Flash, and CoffeeScript. Beneath them sits a single solid slab of bedrock with SQL carved into it alongside the mathematical symbols of relational algebra.SQL is the only programming language a working developer can learn once and use for 30 years without rewriting their mental model. That claim sounds like nostalgia, but it rests on something more durable.Open any SQL textbook from 1995. Find the example query:SELECT department, COUNT(*) AS headcountFROM employeesWHERE hire_date > '1994-01-01'GROUP BY departmentHAVING COUNT(*) > 5ORDER BY headcount DESC;Paste it into PostgreSQL 18 in 2026. It runs. Same syntax, same result, same mental model. Thirty-one years, zero changes.Now try this experiment with the JavaScript ecosystem. Take a React component from 2015. React.createClass, mixins, componentWillMount. It doesn't just look old, it throws TypeError: React.createClass is not a functionthe moment it loads. You rewrite it from scratch to ship it today. Ten years passed, and the framework cycled through three different mental models in that time.Get Fayner Brack’s stories in your inboxJoin Medium for free to get updates from this writer.Remember me for faster sign inI have used SQL at five companies across fifteen years. The query patterns I learned at the first one still work at the current one. I cannot say that about any other language in my stack.SQL endures because relational algebra is mathematics, and mathematics does not have release cycles.Edgar Codd formalised relational algebra in 1970. SQL sits on top of it as a declarative interface. You describe what you want. The database engine decides how to get it. The engine improves every year. Your query stays the same.JavaScript is an imperative language that browser wars, framework trends, and open-source maintainer preferences reshaped every few years. It rewards you for keeping up.SQL rewards you for sitting still.

§2 AI · 99%

If you are a junior developer, “learn SQL properly” is the most valuable 40 hours you can spend. Not a tutorial. Not an ORM. Actual SQL: joins, subqueries, window functions, query plans. That investment pays you back at every job, in every stack, for decades. Almost nothing else in software has that half-life.If you are a senior developer, you already know the cost of this stability. SQL has accumulated forty years of warts it cannot easily shed.NULL is a three-valued logic trap that breaks the intuition of most new users. GROUP BY forces you to repeat column lists for no good reason. Date handling is a vendor-specific mess. Each database has its own dialect, and the "standard" is a 4,000-page document that no single implementation fully follows.These are the costs of backwards compatibility chosen over elegance. SQL locked itself into that tradeoff decades ago. Your 1995 textbook still works because the language refused to break old queries. That same stubbornness means the warts are here to stay.Most languages reward you for chasing what comes next.SQL is the rare one that rewards you for learning what is already there.