Order-equivalent OVER clauses
modern-sql.com/blog/2026-03...
About an important but rarely appreciated aspect when using multiple OVER clauses in a single query.
AI is the future?
Well, if we cannot buy computers anymore, it sounds like stone age to me.
i love databases i love databases i love databases writing sql is fun writing sql is fun writing sql is fun
a single SQL class has brought immeasurable peace and happiness in my professional life. who knew?
Reading about LLM's accuracy to produce SQL queries I ran into llm-benchmark.tinybird.live.
According to their study, the average accuracy/exactness is ~50%. So half of the time models returns a query than runs but returns a wrong answer.
How are people using this in production?
I wonder when we see the first OpenClaw worm, if there isn't one already.
Switching off your Mac Mini won't stop it.
Think you know about #SQL performance?
Take this 3-minute indexing quiz by @winand.at
A simple test that 60% fail!
buff.ly/5C4XZ7N
Did you pass? Let us know how you did!
Which was wrong?
Thanks. It's fixed. I did indeed not understand your first comment ;)
What is random, but actually useful, things you wish you had a SQL interface for?
Infinite Recursion Guards
modern-sql.com/caniuse/with...
With recursive is the only SQL construct that is not guaranteed to terminate, eventually. As the DBMS is typically a very crucial system, infinite loops must be prevented at all times. See how various SQL systems help you.
Time to re-watch The Terminator (1984)
If 26ai means 23.26.1 but not 23.26.0, then yes :)
Oh, BTW, I’m also ecstatic about ASSERTION, but I’ll need some time to cover it on modern-sql.com.
FILTER was the first feature I covered on modern-sql.com, only supported by PostgreSQL at the time. In the meanwhile, half the system I cover support FILTER. Frankly speaking, I cannot understand why there are still systems not support such a simple, easy to understand and useful feature.
Infographic showing that PostgreSQL supports FILTER since 2015, followed by H2 and SQLite in 2019, DuckDB 2024 (first tested release) and now Oracle in 2026.
I’m a simple man.
While Oracle people are ecstatic about ASSERTION in the just released version 23.26.1 of the Oracle Database, I’m happy to see something as simple as FILTER :)
🧵
Permission granted ;) Go ahead.
I’d expect that the app should use prepared statements when it is designed to executes the same query often.
Latencies are often
misunderstood. Also the IO latency in cloud environments, which are often many factors higher as on local discs (during development).
Probably coming in PostgreSQL 19, btw.
LEAD(x) IGNORE NULLS OVER(ORDER BY n)
Not very often, but when I need IGNORE NULLS, then I really miss it in PostgreSQL.
modern-sql.com/caniuse/T616
From the license perspective a tarball would be fine.
But I think open source is more than that. For me it is a spectrum where MySQL is pretty close to the least openness.
Quelle: Der Standard
Recent posts made the point that MySQL is dying. One of the arguments was that there are no Git commits in the past months. This particular argument is totally misleading.
🧵
The linked manual says
INSTALL COMPONENT 'file://classic_hashing'
but for me only
INSTALL COMPONENT 'file://component_classic_hashing'
works.
