u/MarkusWinandin r/Database • Recommends
The Mother of all Query Languages: SQL in Modern Times 15 minutes talk
0:00 / 0:00
The Mother of all Query Languages: SQL in Modern Times | Markus Winand
Data Natives
2.1K subscribers • 1 video on Hallway
- Recommended by 2 people: 2 in engineering communities.
- A classic. People kept recommending it from 2018 to 2026.
- Presented by Markus Winand, Independent Author and Consultant
Intermediate. Assumes working knowledge.
9.1K views7 years ago2 recommendations
Databases and dataHistory and cultureSQLHistory of computing
Markus Winand explains how SQL evolved beyond the purely relational model since SQL:1999 to include non-relational features like JSON.
"The Mother of all Query Languages: SQL in Modern Times" Markus Winand Independent Author, Trainer and Consultant at winand.at You can view the presentation slides here: bit.ly/2QDeXLu Watch more from Data Natives Berlin 2018 here: bit.ly/DN18videos Visit the conference website to learn more: datanatives.io/ Follow Data Natives: facebook.com/DataNativesCon/ twitter.com/DataNativesConf Stay Connected to Data Natives by Email: Subscribe to our newsletter to get the news first about Data Natives 2019: bit.ly/1WMJAqS Abstract of the Talk: Did you know the purely relational dogma of SQL was already abandoned in 1999? The last SQL standard that was limited to the relational idea was SQL-92. From SQL:1999 onwards, the SQL language was extended with non-relational operations and non-relational data structures. As much as this move was discussed at that time, it took decades until database vendors caught up with this idiomatic change. Many SQL users haven’t heard of it until today. The year 2018 finally marks the turning point. With the release of MySQL 8.0, all major SQL dialects finally support the most important non-relational concepts of SQL. This talk provides the big picture on the evolution of the SQL standard and introduces some selected modern SQL features by example. You will see that SQL has changed as much as our requirements have changed over the past decades About the Author: Markus Winand is an independent author, trainer and consultant on SQL. His book "SQL Performance Explained" has been translated into five languages. It can be purchased as a print edition, but can also be read for free on its website use-the-index-luke.com. Under the motto "Since SQL-92 a lot has happened", he is currently working on his second book, which is also available for free online (modern-sql.com ). Markus Winand regularly speaks about SQL at international conferences and user groups .Why it's here
2 people recommend thisWhat people say. Recommended as a great overview of how SQL has evolved beyond the relational model.
u/markwdb3in r/PostgreSQL • Recommends
On “JSONB SQL-NOSQL Schemas”
What is the mixed SQL and NoSQL model you're using? If you mean simply using JSONB types in Postgres alongside with your basic, normalized relational data model, I would just call that...SQL. :)
I say that because JSON has been part of standard SQL for a decade now (since SQL:2016), and more generally speaking, SQL has not been purely one-to-one with the relational model since 1999. See u/markuswinand's great video on the subject.. (It's a few years old but still relevant)