| A lot has changed since SQL-92 | https://modern-sql.com |
| A guide to SQL performance for developers | https://use-the-index-luke.com |
Primary keys should be neither surrogate nor natural.
https://modern-sql.com/de/blog/2026-06/strukturierte-primaerschluessel#per-parent-sequences
MariaDB 12.3.2 was released last week.
It is the first "stable" version of the long-term supported (LTS = 3 years) 12.3 branch.
An SQL dialect enhancement is the IS JSON predicate. Also: a bug I reported is fixed (MDEV-38835).
All charts on modern-sql.com are updated.
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 :)
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.
