Modern SQL

@ModernSQL

Still using Windows 3.1? So why stick to SQL-92? A lot has changed in 30 years. We embrace the standard.

Vienna, Austria

modern-sql.com

Joined February 2015

1KPosts 11KFollowers 5Following

You might like

@PostgreSQL

@MarkusWinand

@SQLPerfTips

@sqldaily

@planetpostgres

@MySQL

@postgresql_007

@DBEngines

@mssqltips

@postgresconf

@SQLServer

@SQLServerGeeks

@mysql_community

@EDBPostgres

@crunchydata

Modern SQL reposted

Markus Winand

@MarkusWinand

Oct 15

Oracle 26ai¹ was released yesterday. Noteworthy SQL addition: QUALIFY. modern-sql.com/caniuse/qualify I bet this starts an avalanche (there are already PostgreSQL patches). ¹ 26ai is the marketing version, 23.26.0 is the technical version.

MarkusWinand's tweet card. QUALIFY: filter rows based on window functions

QUALIFY clause (window functions)

Source: modern-sql.com

Modern SQL reposted

Markus Winand

@MarkusWinand

Sep 5

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.

Modern SQL

@ModernSQL

Mar 11

Just updated modern-sql.com and use-the-index-luke.com for MariaDB 11.7. One enhancement is the FROM-clause column renaming, as described in this article: modern-sql.com/caniuse/E051-09

ModernSQL's tweet card. Rename(alias) columns in the SQL FROM clause

E051-09, “Rename columns in the FROM clause”

Source: modern-sql.com

Modern SQL reposted

Markus Winand

@MarkusWinand

Dec 20

A Christmas present for SQL standard lovers? Part 1 is available for free again. standards.iso.org/ittf/PubliclyA… The last edition that was available for free was 2011, AFAIK. And that disappeared when 2016 was released. Merry Christmas :)

Modern SQL reposted

Markus Winand

@MarkusWinand

Dec 9

The scraping of content for AI training makes some changes required. I'll publish less on my website and RSS feed. The mailing lists will probably stay the same for the time being. If you want to still get everything, subscribe here: winand.at/lists

Modern SQL reposted

Markus Winand

@MarkusWinand

Nov 29

Would you miss Apache Derby when I would remove it from the charts on modern-sql.com?

Modern SQL reposted

Modern SQL

@ModernSQL

Nov 13

While the BMP covers the need of most living languages, it lacks support for symbols that made it into informal language (emojis). Always test your code & engine with non-BPM characters. Ideally one which needs four bytes in the UTF-8 encoding. Here is one for easy c&p: 💩

Modern SQL reposted

Modern SQL

@ModernSQL

Nov 13

SQL's data types CHAR and VARCHAR are about characters. Sounds like a no-brainer, doesn't it? Well, a consequence is that the number in the parenthesis refer to characters, not bytes. Unfortunately, some SQL engines don't get that right—causing major confusion among users.