Modern SQL | Postgres.FM 083 |

[ 🇬🇧_🇺🇸 Check out the subtitles - we now edit them, ChatGPT+manually! You can also try TH-cam'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-luke.com
* SQL Performance Explained (book) sql-performance-explained.com
* Our episode on NULLs postgres.fm/episodes/nulls-th...
* IS DISTINCT FROM (null-safe not equals comparison) modern-sql.com/caniuse/is-dis...
* UNIQUE NULLS DISTINCT modern-sql.com/caniuse/unique...
* Modernes SQL ist mehr als SELECT * FROM (a German language podcast Markus was on recently) engineeringkiosk.dev/podcast/...
* 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/people), or on our shared Google doc (docs.google.com/document/d/1P...)
~~~
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/

[@obacht7]

Great insight about json as a data representation towards applications, vs classical normalized storage!
Now have fun everybody with the craziest OVER(PARTITION BY) 😊

[@bigcountry503]

I paused the video and learned about window functions