
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.
내가 좋아할 만한 콘텐츠
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: 💩
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.

United States 트렌드
- 1. D’Angelo 353K posts
- 2. Young Republicans 28.8K posts
- 3. Charlie 678K posts
- 4. Erika Kirk 78.5K posts
- 5. Politico 217K posts
- 6. #AriZZona N/A
- 7. #PortfolioDay 23.1K posts
- 8. Jason Kelce 5,037 posts
- 9. Pentagon 112K posts
- 10. Presidential Medal of Freedom 94.9K posts
- 11. Harkey N/A
- 12. George Strait 5,401 posts
- 13. Burl Ives 1,048 posts
- 14. NHRA N/A
- 15. #LightningStrikes N/A
- 16. Milei 334K posts
- 17. All in the Family 20.3K posts
- 18. Big 12 14.5K posts
- 19. George Floyd 22.2K posts
- 20. Edith 2,681 posts
내가 좋아할 만한 콘텐츠
-
PostgreSQL
@PostgreSQL -
Markus Winand
@MarkusWinand -
SQL Performance Tips
@SQLPerfTips -
SQL Daily
@sqldaily -
Planet PostgreSQL
@planetpostgres -
MySQL
@MySQL -
Hans-Jürgen Schönig
@postgresql_007 -
DB-Engines
@DBEngines -
MSSQLTips - Free Daily #SQLServer Tips
@mssqltips -
Microsoft SQL Server
@SQLServer -
SQLServerGeeks.com
@SQLServerGeeks -
MySQL Community Team
@mysql_community -
EDB
@EDBPostgres -
Crunchy Data
@crunchydata -
SQLMaestros
@SQLMaestros
Something went wrong.
Something went wrong.