#366: Optimizing PostgreSQL DB Queries with pgMustard

#366: Optimizing PostgreSQL DB Queries with pgMustard

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.

Avsnitt(544)

#497: Outlier Detection with Python

#497: Outlier Detection with Python

Have you ever wondered why certain data points stand out so dramatically? They might hold the key to everything from fraud detection to groundbreaking discoveries. This week on Talk Python to Me, we d...

21 Mars 202555min

#496: Scaf: Complete blueprint for new Python Kubernetes projects

#496: Scaf: Complete blueprint for new Python Kubernetes projects

Today we explore the wild world of Python deployment with my friend, Calvin Hendryx-Parker from Six Feet Up. We’ll tackle some of the biggest challenges in taking a Python app from “it works on my mac...

14 Mars 20251h 19min

#495: OSMnx: Python and OpenStreetMap

#495: OSMnx: Python and OpenStreetMap

On this episode, I'm joined by Dr. Geoff Boeing, an assistant professor at the University of Southern California whose research spans urban planning, spatial analysis, and data science. We explore why...

24 Feb 20251h 1min

#494: Update on Flet: Python + Flutter UIs

#494: Update on Flet: Python + Flutter UIs

As Python developers, we're incredibly lucky to have over half a million packages that we can use to build our applications with over at PyPI. However, when it comes to choosing a UI framework, the op...

21 Feb 20251h

#493: Quarto: Open-source technical publishing

#493: Quarto: Open-source technical publishing

In this episode, I'm joined by JJ Allaire, founder and executive chairman at Posit, and Carlos Scheidegger, a software engineer at Posit, to explore Quarto, an open-source tool revolutionizing technic...

9 Feb 20251h 5min

#492: Great Tables

#492: Great Tables

Join me as I chat with Rich Iannone and Michael Chow from Posit where we explore the transformative power of data tables with the Great Tables library. We'll cover practical applications of Great Tabl...

30 Jan 20251h 4min

#491: DuckDB and Python: Ducks and Snakes living together

#491: DuckDB and Python: Ducks and Snakes living together

Join me for an insightful conversation with Alex Monahan, who works on documentation, tutorials, and training at DuckDB Labs. We explore why DuckDB is gaining momentum among Python and data enthusiast...

27 Dec 20241h 2min

#490: Django Ninja

#490: Django Ninja

If you're a Django developer, I'm sure you've heard so many people raving about FastAPI and Pydantic. But you really love Django and don't want to switch. Then you might want to give Django Ninja a se...

24 Dec 20241h 4min

Populärt inom Teknik

uppgang-och-fall
elbilsveckan
rss-elektrikerpodden
bilar-med-sladd
skogsforum-podcast
rss-uppgang-och-fall
rss-technokratin
market-makers
natets-morka-sida
rss-veckans-ai
rss-laddstationen-med-elbilen-i-sverige
bli-saker-podden
rss-powerboat-sverige-podcast
developers-mer-an-bara-kod
rss-en-ai-till-kaffet
har-vi-akt-till-mars-an
rss-fabriken-2
rss-snacka-om-ai
hej-bruksbil
effekten-digitalisering-kunskap