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!

Claude's C Compiler vs. GCC | Discussion

SQL Comments, Please! modern-sql.com/caniuse/comm...

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)

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 :) 🧵

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

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. 🧵

Charts on modern-sql.com updated for MySQL 9.6.0. The functions MD5, SHA and SHA1 were "removed". That is (not very prominently) mentioned in the security section of the release notes. You can get them back via INSTALL COMPONENT 'file://component_classic_hashing' dev.mysql.com/doc/refman/9...

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. 🧵

I genuinely think SQL might be the best bit of technology ever. I'm not very good at it, but it just works, for so many things, and if it doesn't work, it's probably because you're wrong

Mankind completely lost the gut feeling for how long a task on a computer should reasonably take. When a simple something like inserting three rows takes 700ms, we should fix that. Implementing a scale-out architecture to cope with that is just plain wrong.

SQL’s access rights are often ignored. In context of MCP, they are essential I’d say.

Database management is more than persistence. Beyond persistence, a DBMS also provides access rights (GRANT), schema enforcement (types, constaints), schema evolution (ALTER), concurrency control (TX isolation, deferred constraints), a query language… Persistence is simple, DB managemant is hard.

On Tuesday 30 December 2025 at 20:00 CEST I will do a live coding stream comparing both approaches. youtube.com/live/3tnpb88... #LiveCoding #SoftwareEngineering

Without Overlaps Constraints modern-sql.com/caniuse/with... New in PostreSQL 18. Since 9.2, EXCLUDE constraints can be used for the same purpose.

Veggie-Burger verboten, Verbrenner erlaubt: EU gut gerüstet für 19. Jahrhundert dietagespresse.com/veggie-burge...

Trivia: To run modern-sql.com I've currently 195 SQL systems in my lab and 60000+ test cases.

Adieu Apache Derby, Welcome DuckDB modern-sql.com/blog/2025-12...

clever deflock solutions abound.

modern-sql.com now covers DuckDB.

modern-sql.com now covers DuckDB.

Picard engineering tip: Use the metric system.

Another look into PostgreSQL CTE materialization and non-idempotent subqueries www.shayon.dev/post/2025/12...

From the announcement of SQL Server 2025: "SQL Server 2025 (did you notice our new icon!) [...]" Microsoft is focusing on the important things again ;) www.sqlservercentral.com/articles/sql...

Find yourself someone who will look at you the way I look at modern SQL modern-sql.com

“Early in our company’s life, we built everything around modern data frameworks — until we realized the simplest, most reliable tool had been in front of us all along” blog.sturdystatistics.com/posts/sql/

"Die typische SQL-Erfahrung ist 25 Jahre hinterher. Ich bringe Entwicklern das aktuelle SQL-Know-how bei, damit Ihr Unternehmen die bestehende Infrastruktur besser nutzen kann." Alter... @winand.at nailed it in seinem XING Profil

GROUP BY ALL Very popular, not yet standard but set to become standard. Also expected for PostgreSQL 19. modern-sql.com/caniuse/grou...

Derby DB to be retired! #apache #database #java issues.apache.org/jira/...

Oracle 26ai¹ was released yesterday. From the SQL standpoint it's worth mentioning that is has got the QUALIFY clause: I bet this starts an avalanche (there are already PostgreSQL patches). modern-sql.com/caniuse/qual... ¹ 26ai is the marketing version, 23.26.0 is the technical version.

The best thing is how they “solved” the problem ;)

After being « gone fishin' » during summertime I just updated my website for the releases that happened during that time: * MariaDB 11.8 and 12.0 * Oracle 23.9 * Db2 12.1.2 All charts on modern-sql.com and use-the-index-luke.com are updated.

After being « gone fishin' » during summertime I just updated my website for the releases that happened during that time: * MariaDB 11.8 and 12.0 * Oracle 23.9 * Db2 12.1.2 All charts on modern-sql.com and use-the-index-luke.com are updated.

💯

Index your database with caution. Every new index causes: (a) Increased storage overhead (and in turn, data duplication) (b) Increased write over head for INSERTs The general principle here is that indexing improves read performance but hurts write performance.

Reading “SQL Performance Explained” and I’m taking this as an excuse to draw tree/squirrel shaped Pokémons

SQL is the biggest gift to humankind, sliced bread would come in second place

Do you still manually write SQL queries or rely entirely on ORMs?

Test whether a value is valid #JSON or not with WHERE val IS JSON You can also use this to test if the value is a JSON Object Array And check if there are duplicate key names @winand.at‬ investigates

Hallo Wien! Das ViennaDB Meetup findet im klimatisierten Office statt ;) Spannende Vorträge über Datenbanken, wie man sie loswird und wie man selbst eine macht. Heute ab 18:30, nähe Praterstern. www.meetup.com/viennadb-the...