[ 🇬🇧_🇺🇸 Check out the subtitles - we now edit them, ChatGPT+manually! You can also try RU-vid's auto-translation of them from English to your language; try it and share it with people interested in Postgres!]
Michael is joined by Markus Winand, creator of use-the-index-luke.com and modern-sql.com, and author of SQL Performance Explained, to discuss Modern SQL - what Markus means by it, why it's important, some benefits, some examples, and at least one phrase that should be on a t-shirt.
Here are some links to things they mentioned:
Modern SQL (site) modern-sql.com
Use the index, Luke! (site) use-the-index-...
SQL Performance Explained (book) sql-performanc...
Our episode on NULLs postgres.fm/ep...
IS DISTINCT FROM (null-safe not equals comparison) modern-sql.com...
UNIQUE NULLS DISTINCT modern-sql.com...
Modernes SQL ist mehr als SELECT * FROM (a German language podcast Markus was on recently) engineeringkio...
Markus’ website winand.at
~~~
What did you like or not like? What should we discuss next time? Let us know in the comments, on social media (postgres.fm/pe..., or on our shared Google doc (docs.google.co...)
~~~
Postgres FM is produced by:
Nikolay Samokhvalov, founder of Postgres.ai postgres.ai/
Michael Christofides, founder of pgMustard pgmustard.com/
With special thanks to
Jessie Draws for the artwork jessiedraws.com/
11 окт 2024
