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.
You might like
GROUP BY ALL Very popular, not yet standard but set to become standard. Also expected for PostgreSQL 19. modern-sql.com/caniuse/group-…
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.
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.
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
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 :)
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
Would you miss Apache Derby when I would remove it from the charts on modern-sql.com?
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: 💩
United States Trends
- 1. FINALLY DID IT 564K posts
- 2. The BONK 104K posts
- 3. good tuesday 32.2K posts
- 4. US Leading Investment Team 6,824 posts
- 5. #Nifty 11.8K posts
- 6. $FULC 10.3K posts
- 7. Jalen 79.2K posts
- 8. Eagles 121K posts
- 9. #tuesdayvibe 1,732 posts
- 10. #TuesdayFeeling 1,060 posts
- 11. #BAZAARWomenofTheYearXFreen 401K posts
- 12. Israel and Judah 1,777 posts
- 13. Chainers 1,805 posts
- 14. LINGLING BA HAUS64 514K posts
- 15. #Haus64xLingMOME 516K posts
- 16. Piers 90K posts
- 17. Polk County 5,633 posts
- 18. Herbert 34.3K posts
- 19. Chargers 88.5K posts
- 20. Oslo 74.7K posts
You might like
-
PostgreSQL
@PostgreSQL -
Markus Winand
@MarkusWinand -
SQL Performance Tips
@SQLPerfTips -
SQL Daily
@sqldaily -
Planet PostgreSQL
@planetpostgres -
MySQL
@MySQL -
DB-Engines
@DBEngines -
PostgresConf
@postgresconf -
Microsoft SQL Server
@SQLServer -
SQLServerGeeks.com
@SQLServerGeeks -
MySQL Community Team
@mysql_community -
EDB
@EDBPostgres -
Crunchy Data
@crunchydata -
SQLMaestros
@SQLMaestros -
PostgresWorld
@PostgresWorld
Something went wrong.
Something went wrong.