Look for any podcast host, guest or anyone
Showing episodes and shows of

Markus Winand

Shows

Data in the HallwayData in the HallwayA History of SQLIn this episode, we talk to Markus Winand (a SQL Renaissance Ambassador) about #sql, its evolution and some of the misconceptions that people have.  Modern SQL: https://modern-sql.com/Markus Winand's home page: https://winand.at/If you have any feedback or suggestions for episodes, you can email us at podcast@pingcap.com. ————————— About PingCAP and TiDB —————————PingCAP is the creator of #TiDB, an advanced, #OpenSource, #DistributedSQL database with #MySQL compatibility. TiDB powers modern applications with a streamlined tech stack, elastic scaling, real-time analytics, and continuous access to data—all in a single database.—————...2025-02-1127 minEngineering KioskEngineering Kiosk#182 Happy Birthday SQL: 50 Jahre AbfragespracheÜber 50 Jahre Queries: Das relationale Datenbankmodell und die Sprache SQL haben Geburtstag!Relationale Datenbanken und die Abfragesprache SQL sind aus der modernen Welt nicht mehr wegzudenken. Egal ob du eine eigene Webseite mit WordPress betreibst, Business Intelligence Analysen für eine Versicherung machst oder die größte Oracle Datenbank der Welt betreibst - In allen Use Cases kommt das relationale Datenbankmodell und die Sprache SQL zum Einsatz.Und SQL ist bei weitem kein neuer heißer Scheiß. SQL ist inzwischen 50 Jahre alt und das relationale Datenbankmodell ist sogar noch 5 Jahre älter als SQL! Welche Technologie fällt d...2025-02-111h 05Postgres FMPostgres FMDenormalizationNikolay and Michael discuss denormalization in Postgres — when and why to denormalize things, and a couple of specific cases Nikolay came across recently.  Here are some links to things they mentioned:Denormalization https://en.wikipedia.org/wiki/DenormalizationOur episode on materialized views https://postgres.fm/episodes/materialized-viewsOur episode on data model trade-offs https://postgres.fm/episodes/data-model-trade-offsOur episode with Markus Winand https://postgres.fm/episodes/modern-sqlUniversal Relation Data Modelling Considered Harmful (blog post by Michael Stonebraker and Álvaro Hernández) https://www.enterprisedb.com/blog/universal-relation-data-modelling-considered-harmfulBoyce–Codd normal form https://en.wikipedia.org/wiki/Boyce%E2%80%93Codd_nor...2024-11-0835 minPostgres FMPostgres FMLIMIT vs PerformanceNikolay and Michael discuss LIMIT in Postgres — what it does, how it can help with performance, and an interesting example where adding it can actually hurt performance(!) Here are some links to things they mentioned:LIMIT considered harmful in PostgreSQL (Twitter thread by Christophe Pettus) https://twitter.com/Xof/status/1413542818673577987 LIMIT and OFFSET (docs) https://www.postgresql.org/docs/current/queries-limit.html No OFFSET (by Markus Winand) https://use-the-index-luke.com/no-offset LIMIT clause (docs) https://www.postgresql.org/docs/current/sql-select.html#SQL-LIMIT ~~~What did you like or not like? What sh...2024-05-0345 minTalking Postgres with Claire GiordanoTalking Postgres with Claire GiordanoBecoming expert at using PostgreSQL with Chris EllisYou have to find what works for you and Chris Ellis has never been the kind of person that could go and sit in a library—for Chris, the most productive Postgres place is in a coffee shop. In this episode of the Path To Citus Con* podcast for developers who love Postgres, Chris Ellis joined Claire and Pino to chat about his path to becoming more (and more) expert at using PostgreSQL. Curiosity may have killed the cat but it’s taken Chris places, beginning as a 5 year old playing with QBASIC. Chris shared his journey to becoming a de...2024-04-051h 09Postgres FMPostgres FMModern SQLMichael 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) https://modern-sql.comUse the index, Luke! (site) https://use-the-index-luke.comSQL Performance Explained (book) https://sql-performance-explained.comOur episode on NULLs https://postgres.fm/episodes/nulls-the-good-the-bad-the-ugly-and-the-unknownIS DISTINCT FROM (null-safe not equals comparison) https://modern-sql.com/caniuse/is-distinct-fromUNIQUE NULLS DISTINCT https://modern-sql.com...2024-02-0232 minEngineering KioskEngineering Kiosk#99 Modernes SQL ist mehr als SELECT * FROM - mit Markus WinandSQL is Dead, Long Live SQL!Fast jede Applikation hat irgendeine Form von persistenter Datenhaltung. Oft in Form einer Datenbank. Der Platzhirsch bei Datenbanken sind Systeme, die sich mit der Structured Query Language (kurz SQL) abfragen lassen. MySQL, PostgreSQL, Oracle, MSSQL Server, sqlite, Google BigQuery und so weiter.Die coolen Kids haben vielleicht irgendeine Form von NoSQL-Datenbank im Einsatz. Aber auch da kommt man nicht um SQL herum.Für die meisten Entwickler*innen ist SQL ein alter Hut. SELECT * FROM Tabelle WHERE foo = bar GROUP BY id. Das haben wohl die meisten g...2023-11-281h 19Talking Postgres with Claire GiordanoTalking Postgres with Claire GiordanoMy favorite ways to learn more about PostgreSQL with Grant Fritchey & Ryan BoozEveryone learns differently. Grant Fritchey and Ryan Booz, database advocates at Redgate focusing on PostgreSQL, talk with Path To Citus Con* co-hosts Claire Giordano and Pino de Candia to explore the learning resources available to developers and users in all the corners of the PostgreSQL world. What drives you to learn: need or curiosity? What can podcasts teach us while we bike to work? Are conference talks good for growing skills, or are they better for networking? What about books? And do older books still have much to offer? It turns out, most people need much more than one...2023-07-141h 18Postgres FMPostgres FMChatGPT x 
PostgreSQLNikolay and Michael discuss using ChatGPT for Postgres tasks — should you, if so what for, and some things to be mindful of! Here are links to a few things we mentioned: ChatGPTNikolay’s polls on Twitter and on LinkedIn The Art of PostgreSQL (book by Dimitri Fontaine)SQL Performance Explained (book by Markus Winand)Nikolay’s YouTube correction about deletes and index amplificationDon’t use ChatGPT to solve problems (blog post by Christophe Pettus)Query optimization session with ChatGPT, Michael, and Nikolay (on YouTube)DBeaver SmartAssistance feature  Depesz anonymization feature~~~What did you like...2023-05-1235 minPostgres FMPostgres FMJSONNikolay and Michael discuss JSON — our options for storing it in Postgres, whether or when we should, as well as a brief intro and some tips for JSON functions available. Here are links to a few things we mentioned: hstoreXML typeXML functionsJSON typesJSON functionsJSONB indexingNULLS episodeWhy Postgres is popular episodePostgreSQL 12 release notesWhat’s New in SQL:2016 (blog post by Markus Winand)SQL/JSON is postponed (blog post by depesz) JSON[b] Roadmap (talk by Oleg Bartunov)Slides, with benchmarksRUM access methodJSON in PostgreSQL: how to use it right (blog post by Laurenz Albe from Cybertec)pg_jsonsch...2023-02-2431 minPostgres FMPostgres FMPostgRESTHere are links to a few things we mentioned: PostgREST documentationSupabaseNo offset (blog post by Markus Winand)JSON functions and operators (PostgreSQL docs)Stored procedures (a previous Postgres FM episode)PostGraphile Hasura Parse, Inc. FirebasePostgresMLPgQ ------------------------What did you like or not like? What should we discuss next time? Let us know by tweeting us on @samokhvalov / @michristofides / @PostgresFM, or by commenting on our Google doc.If you would like to share this episode, here's a good link (and thank you!)Postgres FM is brought to you by:2022-12-0229 minEngineering KioskEngineering Kiosk#37 Mit IT-Büchern Geld verdienen? Wer liest überhaupt noch Bücher?Lohnt es sich ein IT-Fachbuch zu schreiben?Es gibt zu jeder Software und zu jedem IT-Thema mindestens ein Buch. Doch wie ist es eigentlich, ein solches Buch zu schreiben? Was macht ein Verlag und braucht man diesen in der heutigen Zeit eigentlich noch? Wird man dadurch reich oder bleibt es Hungerlohn? Was für ein Tech-Stack steckt hinter einem Buch? Und wie würde man eigentlich starten? All das klären wir in dieser Episode mit Wolfgang, der ein Buch über MySQL im Rheinwerk-Verlag (Galileo Press) publiziert hat.Bonus: Warum Wolfgang eher ein Fan vom Rede...2022-09-201h 00Postgres FMPostgres FMHow to become a DBAAnd few things we mentioned: Topic request on Reddit — thanks HerbyHoover!Haki Benita's blog PostgreSQL documentation (table of contents) Planet PostgreSQL (blog aggregator) MVCC Unmasked (by Bruce Momjian) The Internals of PostgreSQL (by Hironobu SUZUKI)PostgreSQL 14 Internals — parts I and II (by Egor Rogov)Cybertec blogmodern-sql.com (by Markus Winand)use-the-index-luke.com (by Markus Winand)The Art of PostgreSQL (by Dimitri Fontaine) explain.depesz.comexplain.dalibo.com ------------------------What did you like or not like? What should we discuss next time? Let us know by tweeting us on @samokhvalov and @michristofidesIf you would l...2022-08-2632 minPostgres FMPostgres FMNULLs: the good, the bad, the ugly, and the unknownHere are links to a few things we mentioned: Three-valued_logic (Wikipedia)Postgres 15 improves UNIQUE and NULL (blog post by Ryan Lambert) Practical SQL for Data Analysis — Interpolation (blog post by Haki Benita) What is the deal with NULLs? (blog post by Jeff Davis) NULL in SQL: Indicating the Absence of Data (Markus Winand on Modern SQL) The Art of PostgreSQL (book by Dimitri Fontaine) ------------------------What did you like or not like? What should we discuss next time? Let us know by tweeting us on @samokhvalov and @michristofidesIf you w...2022-08-0527 minairhacks.fm podcast with adam bienairhacks.fm podcast with adam bienI don't hate your DTOsAn airhacks.fm conversation with Christian Beikov (@c_beikov) about: Nintendo, then Pentium 3, the rpg maker, blockly - the visual programming language from google, switching to C programming at highschool, starting with Java 1.5 and Swing, Java was really appealing, using NetBeans for development, developing a RPG game in Java, learning programming at HTL, studying software engineering at Vienna University, trying to implement an Operating System in Java, trying to start with Java Maxine, jos the free Java Based Operating System, jnode -"Java New Operating System Design Effort", starting with PHP, trying to port Java "standard" library to PHP, Java...2021-03-111h 07PgDay ParisPgDay ParisBe Inclusive: Welcome Non-Key Columns in B-Tree Indexes — Markus WinandPostgreSQL 11 introduced the INCLUDE clause for b-tree indexes. The main intention of this clause is to enable Index Only Scans without including selected columns into the index key. But the INCLUDE clause has many other interesting capabilities that might be even more useful than the support of Index Only Scans. This talk gives you a brief introduction into b-tree indexes, Index Only Scans and what the INCLUDE clause does. It demonstrates where cases the INCLUDE clause can be beneficial and discusses a few more subtle benefits that are not commonly known. Finally, the talk also shows the...2019-12-2300 minPgDay ParisPgDay ParisBe Inclusive: Welcome Non-Key Columns in B-Tree Indexes — Markus WinandPostgreSQL 11 introduced the INCLUDE clause for b-tree indexes. The main intention of this clause is to enable Index Only Scans without including selected columns into the index key. But the INCLUDE clause has many other interesting capabilities that might be even more useful than the support of Index Only Scans. This talk gives you a brief introduction into b-tree indexes, Index Only Scans and what the INCLUDE clause does. It demonstrates where cases the INCLUDE clause can be beneficial and discusses a few more subtle benefits that are not commonly known. Finally, the talk also shows the...2019-12-2300 minPgDay ParisPgDay ParisBe Inclusive: Welcome Non-Key Columns in B-Tree Indexes — Markus WinandPostgreSQL 11 introduced the INCLUDE clause for b-tree indexes. The main intention of this clause is to enable Index Only Scans without including selected columns into the index key. But the INCLUDE clause has many other interesting capabilities that might be even more useful than the support of Index Only Scans. This talk gives you a brief introduction into b-tree indexes, Index Only Scans and what the INCLUDE clause does. It demonstrates where cases the INCLUDE clause can be beneficial and discusses a few more subtle benefits that are not commonly known. Finally, the talk also shows the...2019-12-2300 minPgDay ParisPgDay ParisBe Inclusive: Welcome Non-Key Columns in B-Tree Indexes — Markus WinandPostgreSQL 11 introduced the INCLUDE clause for b-tree indexes. The main intention of this clause is to enable Index Only Scans without including selected columns into the index key. But the INCLUDE clause has many other interesting capabilities that might be even more useful than the support of Index Only Scans. This talk gives you a brief introduction into b-tree indexes, Index Only Scans and what the INCLUDE clause does. It demonstrates where cases the INCLUDE clause can be beneficial and discusses a few more subtle benefits that are not commonly known. Finally, the talk also shows the...2019-12-2300 minPgDay ParisPgDay ParisBe Inclusive: Welcome Non-Key Columns in B-Tree Indexes — Markus WinandPostgreSQL 11 introduced the INCLUDE clause for b-tree indexes. The main intention of this clause is to enable Index Only Scans without including selected columns into the index key. But the INCLUDE clause has many other interesting capabilities t... 2019-12-2300 minPodcast proConfPodcast proConf#41 International PHP Conference Spring 2019 | тесты PHP миф | Symfony как и все | SQL | TLS | КВНTimeline: 14:05 Hansel and Gretel do TLS | Marcus Bointon - https://youtu.be/9RO-cFv5Lzs 27:23 Tools of the Trade | Sebastian Bergmann - https://youtu.be/tFZaan9HjVo 42:05 Symfony 4: A new Way to develop Applications | Antonio Peric-Mazar - https://youtu.be/8Hv65sWYIxk 51:31 Migrating from bare Metal Machines to AWS ECS | Sebastian Struß - https://youtu.be/ET99vmlKC34 55:22 Modern SQL: Evolution of a Dinosaur | Markus Winand - https://youtu.be/nZ8IBJtaPIs 01:08:00 The future of Authentication - WebAuthn with PHP | Arne Blankerts - https://youtu.be/mDXZhOUe9hA 01:17:05 How To Make Loveliness: an HTML treasure hunt | Bruce Lawson - https://youtu.b...2019-12-081h 40Aua-uff-Code!Aua-uff-Code!Assembler = From Nand to Tetris, Teil 6 C64 Weihnachtsdemo Wikipediaseite zu Lot SQL Buch SQL Performance Explained von Markus Winand Podcast Episode mit Markus Winand SPARQL SparQL Tutorial Wikidata Wikidata Query Service z.B.: Die größten Städte mit Bürgermeisterin Ergebnis eingebettet: Stefans minimales Notebook derselben Abfrage Project Jupyter Jupyter Notebooks with Elixir and RDF JupyterLab is Ready for Users Elixir Kernel für Jupyter: IElixir Wolfram Alpha Kotlin Buch Kotlin Big Nerd Ranch Guide Buch Android Programming: The Big Nerd Ranch Guide Udacity Kurs Developing Android Apps with Kotlin GPS Tracking Garmin Forerunner 235 Tracker: Stefan Tracker im Qu...2018-11-2100 minAua-uff-Code!Aua-uff-Code!DatenbankenShow Notes und Links RVM = Ruby version manager .gitignore SQLite DBMS DSL SQL MySQL PostgreSQL DB2 Microsoft SQL Server Oracle (Database) Relationale Datenbank Apache Cassandra CouchDB MongoDB Elastic Search Apache Solr Apache Lucene Redis Key Value Store UFW - einfach zu installierende und konfigurierende Firewall Kibana Logstash (primary) Key UUID Postgres Trigrams Postgres Full Text Search Postgis ist die Extension, nicht Postgeo! InnoDB Tablespace Resizing Map Reduce Layer8 Episode mit Markus Winand Normalisierung XML-Datenbanken objektorientierte Datenbank Serialisierung Neo4J Lern Ruby On Rails 5, das Buch von...2017-03-1500 minGreatest Hits Archives - Software Engineering DailyGreatest Hits Archives - Software Engineering DailyDatabase Choices and Uber with Markus Winand When Uber’s engineering team published a blog post about moving to MySQL from Postgres, Markus Winand started receiving lots of email. Markus writes about databases on his blog “Use The Index, Luke,” a guide to database performance for developers. The people emailing Markus wanted to know–if Postgres doesn’t work well for Uber, is it safe to use for anyone? Markus wrote a detailed blog post that was a response to Uber’s discussion of Postgres, and in today’s episode Markus explains why Postgres is perfectly fine for most applications. Most developer...2016-10-2447 min