Optimizing PostgreSQL DB Queries with pgMustard - Talk Python to Me Ep.366
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.
▬▬▬▬ About the podcast ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
This video is the uncut, live recording of the Talk Python To Me podcast ( https://talkpython.fm ). We cover Python-focused topics every week and publish the edited and polished version in audio form. Subscribe in your podcast player of choice (100% free) at https://talkpython.fm/subscribe.
▬▬▬▬ Guests ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Michael Christofides: / michristofides
▬▬▬▬ Links and resources from the show ▬▬▬▬▬▬▬▬▬▬▬▬
Datagrip: https://www.jetbrains.com/datagrip/
pgMustard: https://pgmustard.com/
pgMustard example 1: https://app.pgmustard.com/#/explore/e...
pgMustard example 2: https://app.pgmustard.com/#/explore/e...
pgMustard example 3: https://app.pgmustard.com/#/explore/e...
Arctype: https://www.arctype.com/
Postico: https://eggerapps.at/postico/
Laetitia Avrot Secrets of 'psql'— • Secrets of 'psql'—a Great Tool!
Beekeeper Studio: https://www.beekeeperstudio.io/
DBeaver: https://dbeaver.io/
SQLite Browser: https://sqlitebrowser.org/
Michael's new Up and Running with Git course: https://talkpython.fm/git
Listen this episode on Talk Python: https://talkpython.fm/episodes/show/3...
Episode transcripts: https://talkpython.fm/episodes/transc...
▬▬▬▬ Dive deeper ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Listen to the Talk Python To Me podcast at https://talkpython.fm Over 250 hours of Python courses at https://training.talkpython.fm/courses Follow us on on Mastodon. Michael: https://fosstodon.org/@mkennedy & Talk Python https://fosstodon.org/@talkpython