| 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
New post:
Structured Primary Keys
For consistency and performance.
#duckdb ist eines der elegantesten Stücke Software-Design der letzten Jahre. In-Process, kein zusätzlicher Server, sehr performant. Die Analyse läuft dort, wo dein Code läuft: #python #go #java #Node #rust oder direkt im #cli.
Das Elegante daran ist die Vektorisierung. Wer große Datenmengen lokal analysieren will, sollte sich DuckDB unbedingt mal anschauen.
@truls46 there are: https://modern-sql.com/caniuse/without-overlaps-constraints
But exclusion constraints are even more powerful :)
The SQL/JSON Path item-method .keyvalue() has an interesting history in the Oracle Database.
https://modern-sql.com/caniuse/keyvalue-json-path
In 23.26.2 it works, but not in ?( filter ) context.
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.
Andreas Schmidt
jcarnu 🐘🐧