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!

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

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.

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

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.

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

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.

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

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.

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

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

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.

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

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.

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

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.

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

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

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.

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

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.

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

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