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 
 
<a href='https://talkpython.fm/sentry'>Sentry Error Monitoring, Code TALKPYTHON</a>
<a href='https://talkpython.fm/citizens'>Data Citizens Podcast</a>
<a href='https://talkpython.fm/training'>Talk Python Courses</a> 
 
<h2>Links from the show</h2>
<div>Alex on Mastodon: <a href="https://data-folks.masto.host/@__Alex__?featured_on=talkpython" target="_blank" >@__Alex__</a> 
 
DuckDB: <a href="https://duckdb.org/?featured_on=talkpython" target="_blank" >duckdb.org</a> 
MotherDuck: <a href="https://motherduck.com/?featured_on=talkpython" target="_blank" >motherduck.com</a> 
SQLite: <a href="https://sqlite.org/?featured_on=talkpython" target="_blank" >sqlite.org</a> 
Moka-Py: <a href="https://github.com/deliro/moka-py?featured_on=talkpython" target="_blank" >github.com</a> 
PostgreSQL: <a href="https://www.postgresql.org/?featured_on=talkpython" target="_blank" >www.postgresql.org</a> 
MySQL: <a href="https://www.mysql.com/?featured_on=talkpython" target="_blank" >www.mysql.com</a> 
Redis: <a href="https://redis.io/?featured_on=talkpython" target="_blank" >redis.io</a> 
Apache Parquet: <a href="https://parquet.apache.org/?featured_on=talkpython" target="_blank" >parquet.apache.org</a> 
Apache Arrow: <a href="https://arrow.apache.org/?featured_on=talkpython" target="_blank" >arrow.apache.org</a> 
Pandas: <a href="https://pandas.pydata.org/?featured_on=talkpython" target="_blank" >pandas.pydata.org</a> 
Polars: <a href="https://pola.rs/?featured_on=talkpython" target="_blank" >pola.rs</a> 
Pyodide: <a href="https://pyodide.org/?featured_on=talkpython" target="_blank" >pyodide.org</a> 
DB-API (PEP 249): <a href="https://peps.python.org/pep-0249/?featured_on=talkpython" target="_blank" >peps.python.org/pep-0249</a> 
Flask: <a href="https://flask.palletsprojects.com/?featured_on=talkpython" target="_blank" >flask.palletsprojects.com</a> 
Gunicorn: <a href="https://gunicorn.org/?featured_on=talkpython" target="_blank" >gunicorn.org</a> 
MinIO: <a href="https://min.io/?featured_on=talkpython" target="_blank" >min.io</a> 
Amazon S3: <a href="https://aws.amazon.com/s3/?featured_on=talkpython" target="_blank" >aws.amazon.com/s3</a> 
Azure Blob Storage: <a href="https://azure.microsoft.com/products/storage/?featured_on=talkpython" target="_blank" >azure.microsoft.com/products/storage</a> 
Google Cloud Storage: <a href="https://cloud.google.com/storage?featured_on=talkpython" target="_blank" >cloud.google.com/storage</a> 
DigitalOcean: <a href="https://www.digitalocean.com/?featured_on=talkpython" target="_blank" >www.digitalocean.com</a> 
Linode: <a href="https://www.linode.com/?featured_on=talkpython" target="_blank" >www.linode.com</a> 
Hetzner: <a href="https://www.hetzner.com/?featured_on=talkpython" target="_blank" >www.hetzner.com</a> 
BigQuery: <a href="https://cloud.google.com/bigquery?featured_on=talkpython" target="_blank" >cloud.google.com/bigquery</a> 
DBT (Data Build Tool): <a href="https://docs.getdbt.com/?featured_on=talkpython" target="_blank" >docs.getdbt.com</a> 
Mode: <a href="https://mode.com/?featured_on=talkpython" target="_blank" >mode.com</a> 
Hex: <a href="https://hex.tech/?featured_on=talkpython" target="_blank" >hex.tech</a> 
Python: <a href="https://www.python.org/?featured_on=talkpython" target="_blank" >www.python.org</a> 
Node.js: <a href="https://nodejs.org/?featured_on=talkpython" target="_blank" >nodejs.org</a> 
Rust: <a href="https://www.rust-lang.org/?featured_on=talkpython" target="_blank" >www.rust-lang.org</a> 
Go: <a href="https://go.dev/?featured_on=talkpython" target="_blank" >go.dev</a> 
.NET: <a href="https://dotnet.microsoft.com/?featured_on=talkpython" target="_blank" >dotnet.microsoft.com</a> 
Watch this episode on YouTube: <a href="https://www.youtube.com/watch?v=3wGeadcKens" target="_blank" >youtube.com</a> 
Episode transcripts: <a href="https://talkpython.fm/episodes/transcript/491/duckdb-and-python-ducks-and-snakes-living-together" target="_blank" >talkpython.fm</a> 
 
--- Stay in touch with us --- 
Subscribe to Talk Python on YouTube: <a href="https://talkpython.fm/youtube" target="_blank" >youtube.com</a> 
Talk Python on Bluesky: <a href="https://bsky.app/profile/talkpython.fm" target="_blank" >@talkpython.fm at bsky.app</a> 
Talk Python on Mastodon: <a href="https://fosstodon.org/web/@talkpython" target="_blank" >talkpython</a> 
Michael on Bluesky: <a href="https://bsky.app/profile/mkennedy.codes?featured_on=talkpython" target="_blank" >@mkennedy.codes at bsky.app</a> 
Michael on Mastodon: <a href="https://fosstodon.org/web/@mkennedy" target="_blank" >mkennedy</a> </div>

Podurama

Home

Trending

Personal

Your Podcasts

New Episodes

My Files

Favourite Episodes

Tags (Folders)

Recently Played

Bookmarks

Followed Playlists

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

Talk Python To Me

AI Chapters

AI Insights

Reviews