Talk Python to Me is a weekly podcast hosted by developer and entrepreneur Michael Kennedy. We dive deep into the popular packages and software developers, data scientists, and incredible hobbyists doing amazing things with Python. If you're new to Python, you'll quickly learn the ins and outs of the community by hearing from the leaders. And if you've been Pythoning for years, you'll learn about your favorite packages and the hot new ones coming out of open source.
#366: Optimizing PostgreSQL DB Queries with pgMustard
May 20, 2022
01:14:06
62.52 MB
Downloads: 0
Does your app have a database? Does that database play an important role in how the app operations and users perceive its quality? Most of you probably said yes to the first, and definitely to the second. But what if your DB isn't doing as well as it should? How would you know? And once you know, what do you do about it?
On this episode, we're joined by Michael Christofides, co-creator of pgMustard, to discuss and explore the EXPLAIN command for Postgres and other databases as well as all the recommendations you might dig into as a result of understanding exactly what's happening with you queries.
Links from the show
Michael Christofides: @michristofides
Datagrip: jetbrains.com
pgMustard: pgmustard.com
pgMustard example 1: app.pgmustard.com
pgMustard example 2: app.pgmustard.com
pgMustard example 3: app.pgmustard.com
Arctype: arctype.com
Postico: eggerapps.at/postico
Laetitia Avrot Secrets of 'psql'— Video: youtube.com
Beekeeper Studio: beekeeperstudio.io
DBeaver: dbeaver.io
SQLite Browser: sqlitebrowser.org
Michael's new Up and Running with Git course: talkpython.fm/git
Watch this episode on YouTube: youtube.com
Episode transcripts: talkpython.fm
--- Stay in touch with us ---
Subscribe to us on YouTube: youtube.com
Follow Talk Python on Twitter: @talkpython
Follow Michael on Twitter: @mkennedy
Sponsors
Sentry Error Monitoring, Code TALKPYTHON
Talk Python Training
AssemblyAI
On this episode, we're joined by Michael Christofides, co-creator of pgMustard, to discuss and explore the EXPLAIN command for Postgres and other databases as well as all the recommendations you might dig into as a result of understanding exactly what's happening with you queries.
Links from the show
Michael Christofides: @michristofides
Datagrip: jetbrains.com
pgMustard: pgmustard.com
pgMustard example 1: app.pgmustard.com
pgMustard example 2: app.pgmustard.com
pgMustard example 3: app.pgmustard.com
Arctype: arctype.com
Postico: eggerapps.at/postico
Laetitia Avrot Secrets of 'psql'— Video: youtube.com
Beekeeper Studio: beekeeperstudio.io
DBeaver: dbeaver.io
SQLite Browser: sqlitebrowser.org
Michael's new Up and Running with Git course: talkpython.fm/git
Watch this episode on YouTube: youtube.com
Episode transcripts: talkpython.fm
--- Stay in touch with us ---
Subscribe to us on YouTube: youtube.com
Follow Talk Python on Twitter: @talkpython
Follow Michael on Twitter: @mkennedy
Sponsors
Sentry Error Monitoring, Code TALKPYTHON
Talk Python Training
AssemblyAI