Latest episode:
#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.
Full details »
Beginners
Effective PyCharm
HMTX + Flask
Upcoming episodes
Despite Python being overwhelmingly popular and positive, there are major areas of computing where Python is not present. Most notably on mobile and on the frontend side of the web. PyScript, a new project launched by Fabio Pliger from Anaconda, just might change that. It was made public and announced at PyCon just two weeks ago by Peter Wang and now has over 10,000 GitHub stars. But what is hype vs. reality vs. projected hopes and dreams? We're going to find out on this episode. Fabio is here to tell us all about his new project.
How do you test whether your web sites are working well? Unit tests are great. But for web apps, the number of pieces that have to click together "just so" are many. You have databases, server code (such as a Flask app), server templates (Jinja for example), CSS, Javascript, and even deployment topologies (think nginx + uvicorn). Unit tests won't cover all of that integration. But Playwright does. Playwright is a modern, Pythonic take on testing webs apps using code driving a browser core to interact with web apps the way real users and API clients do. I think you'll find a lot to like there. And we have Pandy Knight from Automation Panda here to break it down for us.
What listeners think
The best python podcast I’ve ever encounteredThank you for the deepest python podcast I’ve ever met! I’m learning a lot by just listening to it! Cheers.
One of my go-to podcasts for commutes!Whether your just taking an interest in Python or are an experienced developer, this podcast seems to cater equally well to both types. Consistency engaging and interesting topics and really helps you stay connected to what is going on in the Python world. Thanks Michael!
Great additionFinally, a great python podcast. Highly informative.
Python Bytes Podcast
Python Bytes:
Python headlines delivered directly to your earbuds
If you are looking for a 15 minute conversation on the topical items of the week in the Python ecosystem, be sure to jump over to Python Bytes and subscribe.
Talk Python Merchandise
Sponsor or support the show
More about Talk Python to Me
Talk Python to Me is a weekly podcast hosted by
Michael Kennedy.
The show covers a wide array of Python topics as well as
many related topics.
The format is a casual 1-hour conversation with industry
experts.
Have feedback for the show? Send it to
contact@talkpython.fm.
We'd love to hear from you.
Suggest a show or guest
We are always on the look out for exciting topics to bring
to you on Talk Python To Me. We could use your help!
Do you have a great idea for a show? Do know a dynamic Python
personality who we should be speaking to? Send us an email!
