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 enthusiasts, from its in-process database design to its blazingly fast, columnar architecture. We also dive into indexing strategies, concurrency considerations, and the fascinating way MotherDuck (the cloud companion to DuckDB) handles large-scale data seamlessly. Don’t miss this chance to learn how a single pip install could totally transform your Python data workflow!

Episode sponsors

Sentry Error Monitoring, Code TALKPYTHON
Data Citizens Podcast
Talk Python Courses

Links from the show

Alex on Mastodon: @__Alex__

DuckDB: duckdb.org
MotherDuck: motherduck.com
SQLite: sqlite.org
Moka-Py: github.com
PostgreSQL: www.postgresql.org
MySQL: www.mysql.com
Redis: redis.io
Apache Parquet: parquet.apache.org
Apache Arrow: arrow.apache.org
Pandas: pandas.pydata.org
Polars: pola.rs
Pyodide: pyodide.org
DB-API (PEP 249): peps.python.org/pep-0249
Flask: flask.palletsprojects.com
Gunicorn: gunicorn.org
MinIO: min.io
Amazon S3: aws.amazon.com/s3
Azure Blob Storage: azure.microsoft.com/products/storage
Google Cloud Storage: cloud.google.com/storage
DigitalOcean: www.digitalocean.com
Linode: www.linode.com
Hetzner: www.hetzner.com
BigQuery: cloud.google.com/bigquery
DBT (Data Build Tool): docs.getdbt.com
Mode: mode.com
Hex: hex.tech
Python: www.python.org
Node.js: nodejs.org
Rust: www.rust-lang.org
Go: go.dev
.NET: dotnet.microsoft.com
Watch this episode on YouTube: youtube.com
Episode transcripts: talkpython.fm

--- Stay in touch with us ---
Subscribe to Talk Python on YouTube: youtube.com
Talk Python on Bluesky: @talkpython.fm at bsky.app
Talk Python on Mastodon: talkpython
Michael on Bluesky: @mkennedy.codes at bsky.app
Michael on Mastodon: mkennedy

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 serious look. Django Ninja is highly inspired by FastAPI, but is also deeply integrated into Django itself. We have Vitaliy Kucheryaviy the creator of Django Ninja on this show to tell us all about it.

Episode sponsors

Sentry Error Monitoring, Code TALKPYTHON
Bluehost
Talk Python Courses

Links from the show

Vitaly: github.com/vitalik
Vitaly on X: @vital1k

Top 5 Episodes of 2024: talkpython.fm/blog/posts/top-talk-python-podcast-episodes-of-2024

Django Ninja: django-ninja.dev
Motivation section we talked through: django-ninja.dev/motivation
LLM for Django Ninja: llm.django-ninja.dev
Nano Django: github.com/vitalik/nano-django
Episode transcripts: talkpython.fm

--- Stay in touch with us ---
Subscribe to Talk Python on YouTube: youtube.com
Talk Python on Bluesky: @talkpython.fm at bsky.app
Talk Python on Mastodon: talkpython
Michael on Bluesky: @mkennedy.codes at bsky.app
Michael on Mastodon: mkennedy

Peter Wang has been pushing Python forward since the early days of its data science roots. We're lucky to have him back on the show. We're going to talk about the Anaconda Toolbox for Excel as well as many other trends and topics that are hot in the Python space right now. I'm sure you'll enjoy listening to the two of us exchanging our takes on the topics and trends.

Episode sponsors

Sentry Error Monitoring, Code TALKPYTHON
Bluehost
Talk Python Courses

Links from the show

Peter on BSky: @wang.social
Michael on BSky: @mkennedy.codes
Michael's Curated BSky Starter List: bsky.app
Python Blsky Starter Pack List: blueskydirectory.com

Anaconda Toolbox for Microsoft Excel: anaconda.com
JupyterLite: jupyter.org
8 of the Biggest Excel Mistakes of All Time: blog.hurree.co
The Five Demons of Python Packaging PyBay talk: youtube.com
PEP 759: peps.python.org
TIOBE Index: tiobe.com
pyscript: pyscript.net
Watch this episode on YouTube: youtube.com
Episode transcripts: talkpython.fm

--- Stay in touch with us ---
Subscribe to Talk Python on YouTube: youtube.com
Talk Python on Bluesky: @talkpython.fm at bsky.app
Talk Python on Mastodon: talkpython
Michael on Bluesky: @mkennedy.codes at bsky.app
Michael on Mastodon: mkennedy

LanceDB is a developer-friendly, open source database for AI. It's used by well-known companies such as Midjourney and Character.ai. We have Chang She, the CEO and cofounder of LanceDB on to give us a look at the concept of multi-modal data and how you can use LanceDB in your own Python apps.

Episode sponsors

Sentry Error Monitoring, Code TALKPYTHON
Bluehost
Talk Python Courses

Links from the show

Chang She: @changhiskhan
Chang on Github: github.com

LanceDB: lancedb.com
LanceDB Source: github.com
Embeddings API: github.com
MinIO: min.io
LanceDB Quickstart: github.com
VectorDB-recipes: github.com
Watch this episode on YouTube: youtube.com
Episode transcripts: talkpython.fm

--- Stay in touch with us ---
Subscribe to Talk Python on YouTube: youtube.com
Talk Python on Bluesky: @talkpython.fm at bsky.app
Talk Python on Mastodon: talkpython
Michael on Bluesky: @mkennedy.codes at bsky.app
Michael on Mastodon: mkennedy

There has been a lot of changes in the low-level Python space these days. The biggest has to be how many projects have rewritten core performance-intensive sections in Rust. Or even the wholesale adoption of Rust for newer projects such as uv and ruff. On this episode, we dive into the tools and workflow needed to build these portions of Python apps in Rust with David Seddon and Samuel Colvin.

Episode sponsors

Posit
Data Citizens Podcast
Talk Python Courses

Links from the show

Samuel Colvin: github.com/samuelcolvin
David Seddon: github.com/seddonym
David's blog: seddonym.me

Pydantic: pydantic.dev
PEP 0759: peps.python.org
TypeShed: github.com
Maturin: maturin.rs
rloop: github.com
Install Rust: rust-lang.org
Py03: pyo3.rs
The Rust Programming Language (book): https://doc.rust-lang.org/book/
Grimp: github.com
Grimp Workflows: github.com
White House recommends memory safe languages: whitehouse.gov
Installing Rust: rust-lang.org
jiter: github.com
import-linter: github.com
Logfire: pydantic.dev
Crabs in Snakes, David Seddon, Pycon Italia: youtube.com
Kraken engineering blog: engineering.kraken.tech
Serde: serde.rs
Mypy stub testing: mypy.readthedocs.io
Watch this episode on YouTube: youtube.com
Episode transcripts: talkpython.fm

--- Stay in touch with us ---
Subscribe to Talk Python on YouTube: youtube.com
Talk Python on Bluesky: @talkpython.fm at bsky.app
Talk Python on Mastodon: talkpython
Michael on Bluesky: @mkennedy.codes at bsky.app
Michael on Mastodon: mkennedy

If you are a .NET developer or work in a place that has some of those folks, wouldn't it be great to fully leverage the entirety of PyPI with it's almost 600,000 packages inside your .NET code? But how would you do this? Previous efforts have let you write Python syntax but using the full libraries (especially the C-based ones) has been out of reach, until CSnakes. This project by Anthony Shaw and Aaron Powell unlocks some pretty serious integration between the two languages. We have them both here on the show today to tell us all about it.

Episode sponsors

Posit
Bluehost
Talk Python Courses

Links from the show

Anthony Shaw: github.com
Aaron Powell: github.com

Introducing CSnakes: tonybaloney.github.io
CSnakes: tonybaloney.github.io

Talk Python: We've moved to Hetzner: talkpython.fm/blog
Talk Python: Talk Python rewritten in Quart (async Flask): talkpython.fm/blog

Pyjion - A JIT for Python based upon CoreCLR: github.com
Iron Python: ironpython.net
Python.NET: pythonnet.github.io
The buffer protocol: docs.python.org

Avalonia UI: avaloniaui.net
Watch this episode on YouTube: youtube.com
Episode transcripts: talkpython.fm

--- Stay in touch with us ---
Subscribe to Talk Python on YouTube: youtube.com
Talk Python on Bluesky: @talkpython.fm at bsky.app
Talk Python on Mastodon: talkpython
Michael on Bluesky: @mkennedy.codes at bsky.app
Michael on Mastodon: mkennedy

What do developers need to know about AppSec and building secure software? We have Tanya Janca (AKA SheHacksPurple) on the show to tell us all about it. We talk about what developers should expect from threat modeling events as well as concrete tips for security your apps and services.

Episode sponsors

Posit
Bluehost
Talk Python Courses

Links from the show

Tanya on X: @shehackspurple
She Hacks Purple website: shehackspurple.ca
White House recommends memory safe languages: whitehouse.gov
Python Developer Survey Results: jetbrains.com
Bandit: github.com
Semgrep Academy: academy.semgrep.dev
Watch this episode on YouTube: youtube.com
Episode transcripts: talkpython.fm

--- Stay in touch with us ---
Subscribe to Talk Python on YouTube: youtube.com
Talk Python on Bluesky: @talkpython.fm at bsky.app
Talk Python on Mastodon: talkpython
Michael on Bluesky: @mkennedy.codes at bsky.app
Michael on Mastodon: mkennedy

Have you heard about HTMX? We've discussed it a time or two on this show. We're back with another episode on HTMX, this time with a real-world success story and lessons learned. We have Sheena O'Connell on to tell us how she moved from a React-Django app to pure Django with HTMX.

Episode sponsors

Posit
Bluehost
Talk Python Courses

Links from the show

Sheena O'Connell: sheenaoc.com
An HTMX success story essay: sheenaoc.com
Sheena's HTMX Workshop: prelude.tech - discount code: talk_python

Talk Python's HTMX Courses
HTMX + Flask course: training.talkpython.fm
HTMX + Django course: training.talkpython.fm
Build An Audio AI App course: training.talkpython.fm

HTMX: htmx.org
Playwright: playwright.dev
django-template-partials: github.com
Michael's jinja_partials: github.com
django-guardian: github.com
Talk Python Courses HTMX Example: training.talkpython.fm/courses/all
Alpine.js: alpinejs.dev
David Guillot SaaS video: youtube.com
awesome-htmx: github.com
Guild of Educators: guildofeducators.org
The big rewrite song: youtube.com
Watch this episode on YouTube: youtube.com
Episode transcripts: talkpython.fm

--- Stay in touch with us ---
Subscribe to Talk Python on YouTube: youtube.com
Talk Python on Bluesky: @talkpython.fm at bsky.app
Talk Python on Mastodon: talkpython
Michael on Bluesky: @mkennedy.codes at bsky.app
Michael on Mastodon: mkennedy

Let's say you want to create a web app and you know Python really well. Your first thought might be Flask or Django or even FastAPI? All good choices but there is a lot to get a full web app into production. The framework we'll talk about today, Reflex, allows you to just write Python code and it turns it into a full web app running FastAPI, NextJS, React and more plus it handles the deployment for you. It's a cool idea. Let's talk to Elvis Kahoro and Nikhil Rao from Reflex.dev.

Episode sponsors

Posit
Bluehost
Talk Python Courses

Links from the show

Elvis: github.com
Nikhil: github.com

Reflex Framework: reflex.dev
Reflex source: github.com
Reflex docs: reflex.dev
Reflex Roadmap: github.com
AG Grid: ag-grid.com

Warp terminal: warp.dev
A Stroll Down Startup Lane episode: talkpython.fm
PuePy: Reactive frontend framework in Python episode: talkpython.fm
Watch this episode on YouTube: youtube.com
Episode transcripts: talkpython.fm

--- Stay in touch with us ---
Subscribe to Talk Python on YouTube: youtube.com
Talk Python on Bluesky: @talkpython.fm at bsky.app
Talk Python on Mastodon: talkpython
Michael on Bluesky: @mkennedy.codes at bsky.app
Michael on Mastodon: mkennedy

Do you struggle to make sure your code is always correct before you check it in? What about your team members' code? That one person who never wants to run the linter? Tired of dealing with tons of conflicts and spurious git changes? You need git pre-commit hooks. We're lucky to have Stefanie Molin on this episode who has done a bunch of writing and teaching of git hooks.

Episode sponsors

Sentry Error Monitoring, Code TALKPYTHON
Bluehost
Talk Python Courses

Links from the show

Stefanie Molin: stefaniemolin.com

Talk Python Blog: talkpython.fm/blog

How to Set Up Pre-Commit Hooks: stefaniemolin.com
Common Pre-Commit Errors and How to Solve Them: stefaniemolin.com
A Behind-the-Scenes Look at How Pre-Commit Works: stefaniemolin.com
Pre-Commit Hook Creation Guide: stefaniemolin.com
(Pre-)Commit to Better Code Workshop: stefaniemolin.com
exif-stripper: stefaniemolin.com
exif-stripper on GitHub: github.com
docstring-validation-using-pre-commit-hook: numpydoc.readthedocs.io
Data Morph: Moving Beyond the Datasaurus Dozen: stefaniemolin.com
Data Morph on GitHub: github.com
Watch this episode on YouTube: youtube.com
Episode transcripts: talkpython.fm

--- Stay in touch with us ---
Subscribe to Talk Python on YouTube: youtube.com
Talk Python on Bluesky: @talkpython.fm at bsky.app
Talk Python on Mastodon: talkpython
Michael on Bluesky: @mkennedy.codes at bsky.app
Michael on Mastodon: mkennedy

Hynek has been writing and speaking on some of the most significant topics in the Python space and I've enjoyed his takes. So I invited him on the show to share them with all of us. This episode really epitomizes one of the reasons I launched Talk Python 9 years ago. It's as if we run into each other at a bar during a conference and I ask Hynek, "So what are your thoughts on ..." and we dive down the rabbit hole for an hour. I hope you enjoy it.

Episode sponsors

WorkOS
Bluehost
Talk Python Courses

Links from the show

Hynek Schlawack on Mastodon: @hynek

Why I Still Use Python Virtual Environments in Docker: hynek.me
Production-ready Python Docker Containers with uv: hynek.me
Attrs: github.com
uv: astral.sh
What’s New In Python 4: python.org
BusyBox: busybox.net
Hynek's YouTube Channel: youtube.com
MOPUp for macOS: github.com
Homebrew Python Is Not For You: justinmayer.com
argon2-cffi: Argon2 for Python: github.com
pytest-freethreaded: github.com
LM Studio: lmstudio.ai
StackOverflow Trends Graph: trends.stackoverflow.co
Watch this episode on YouTube: youtube.com
Episode transcripts: talkpython.fm

--- Stay in touch with us ---
Subscribe to Talk Python on YouTube: youtube.com
Talk Python on Bluesky: @talkpython.fm at bsky.app
Talk Python on Mastodon: talkpython
Michael on Bluesky: @mkennedy.codes at bsky.app
Michael on Mastodon: mkennedy