The Real Python Podcast

Are you looking for a fast database that can handle large datasets in Python? What’s the difference between a Python expression and a statement? Christopher Trudeau is back on the show this week, bringing another batch of PyCoder’s Weekly articles and projects. We cover a Real Python article that explores DuckDB and discuss creating a database by reading data from multiple file formats. When building queries, DuckDB uses standard SQL syntax, or for an object-oriented approach, you can chain methods together using the Python API. We also explore the advantages of lazy evaluation using DuckDB relations. Christopher digs into another Real Python tutorial that covers the differences between expressions and statements in Python. The piece goes beyond definitions to answer questions about where and when to use them in your code. We also share several other articles and projects from the Python community, including a news roundup, an investigation into the lack of security in MCP, a discussion on the differences between staff engineer and engineering manager roles, guidance on creating and modifying Word documents with Python, and a project to go beyond print for debugging your code. Check out realpython.com/workshops [https://realpython.com/workshops] to join the upcoming cohort of the Intermediate Python Deep Dive course. Course Spotlight: Creating a Python Dice Roll Application [https://realpython.com/courses/creating-dice-roll-application/] In this step-by-step video course, you’ll build a dice-rolling simulator app with a minimal text-based user interface using Python. The app will simulate the rolling of up to six dice. Each individual die will have six sides. Topics: * 00:00:00 – Introduction * 00:02:24 – Python 3.14.0a7, 3.13.3, 3.12.10, 3.11.12, 3.10.17 and 3.9.22 are now available * 00:02:47 – PEP 768: Safe External Debugger Interface for CPython (Accepted) * 00:03:16 – PEP 781: Make TYPE_CHECKING a Built-in Constant * 00:03:43 – PEP 750: Template Strings (Accepted) * 00:04:15 – PEP 751: A file format to record Python dependencies for installation reproducibility (Accepted) * 00:05:20 – EuroPython July 14th-20th Prague, Tickets Available * 00:05:42 – Django 5.2 Released * 00:05:59 – Django security releases issued: 5.1.8 and 5.0.14 * 00:06:19 – Introducing DuckDB * 00:12:19 – Expression vs Statement in Python: What’s the Difference? * 00:17:11 – Video Course Spotlight * 00:18:33 – The “S” in MCP Stands for Security * 00:28:08 – Real Python Workshops * 00:30:26 – Staff Engineer vs Engineering Manager * 00:44:48 – python-docx: Create and modify Word documents with Python * 00:47:28 – peek: like print, but easy * 00:50:32 – Thanks and goodbye News: * Python 3.14.0a7, 3.13.3, 3.12.10, 3.11.12, 3.10.17 and 3.9.22 are now available [https://pythoninsider.blogspot.com/2025/04/python-3140a7-3133-31210-31112-31017.html] * PEP 768: Safe External Debugger Interface for CPython (Accepted) [https://peps.python.org/pep-0768/] * PEP 781: Make TYPE_CHECKING a Built-in Constant [https://peps.python.org/pep-0781/] – This PEP proposes adding a new built-in variable, TYPE_CHECKING, which is True when the code is being analyzed by a static type checker, and False during normal runtime. * PEP 750: Template Strings (Accepted) [https://peps.python.org/pep-0750/] – This PEP introduces template strings for custom string processing. * PEP 751: A file format to record Python dependencies for installation reproducibility (Accepted) [https://peps.python.org/pep-0751/] * EuroPython July 14th-20th Prague, Tickets Available [https://ep2025.europython.eu/tickets/] * Django 5.2 Released [https://www.djangoproject.com/weblog/2025/apr/02/django-52-released/] * Django security releases issued: 5.1.8 and 5.0.14 [https://www.djangoproject.com/weblog/2025/apr/02/security-releases/] Topics: * Introducing DuckDB [https://realpython.com/python-duckdb/] – In this showcase tutorial, you’ll be introduced to a library that allows you to use a database in your code. DuckDB provides an efficient relational database that supports many features you may already be familiar with from more traditional relational database systems. * Expression vs Statement in Python: What’s the Difference? [https://realpython.com/python-expression-vs-statement/] – In this tutorial, you’ll explore the differences between an expression and a statement in Python. You’ll learn how expressions evaluate to values, while statements can cause side effects. You’ll also explore the gray areas between them, which will enhance your Python programming skills. * The “S” in MCP Stands for Security - Elena Cross [https://elenacross7.medium.com/%EF%B8%8F-the-s-in-mcp-stands-for-security-91407b33ed6b] – Model Context Protocol is a new standard behind how Large Language Models integrate with tools and data. Unfortunately, MCP is not secure by default. * Staff Engineer vs Engineering Manager - Alex Ewerlöf Notes [https://blog.alexewerlof.com/p/staff-engineer-vs-engineering-manager] – When do you need a Staff Engineers? What’s the difference between Staff Engineer and Engineering Manager? This article covers these questions and more. Projects: * python-docx: Create and modify Word documents with Python [https://github.com/python-openxml/python-docx] * peek: like print, but easy [https://salabim.org/peek/] Additional Links: * Intermediate Python Deep Dive Course – Real Python [https://realpython.com/workshops/intermediate-deep-dive/] * Episode #227: New PEPs: Template Strings & External Wheel Hosting [https://realpython.com/podcasts/rpp/227/] * DuckDB – An in-process SQL OLAP database management system [https://duckdb.org/] * Online analytical processing - Wikipedia [https://en.wikipedia.org/wiki/Online_analytical_processing] * Model Context Protocol has prompt injection security problems [https://simonwillison.net/2025/Apr/9/mcp-prompt-injection/] * Model Context Protocol - Documentation [https://modelcontextprotocol.io/introduction] * modelcontextprotocol/python-sdk: The official Python SDK for Model Context Protocol servers and clients [https://github.com/modelcontextprotocol/python-sdk] * “Biggest commitment to a 3 second joke I’ve ever seen” — Bluesky [https://bsky.app/profile/oregonthedm.bsky.social/post/3lmeenfu6r22x] Level up your Python skills with our expert-led courses: * Creating a Python Dice Roll Application [https://realpython.com/courses/creating-dice-roll-application/] * Python Assignment Expressions and Using the Walrus Operator [https://realpython.com/courses/python-assignment-expressions-walrus-operator/] * Debugging in Python With pdb [https://realpython.com/courses/python-debugging-pdb/] Support the podcast & join our community of Pythonistas [https://realpython.com/join]

Do you want to learn deeper concepts in Python? Would the accountability of scheduled group classes help you get past the basics? This week, five Real Python Intermediate Deep Dive workshop members discuss their experiences. We discuss the struggles of learning Python independently and the barriers to moving beyond the basics. We also explore the advantages of having a curated collection of both written tutorials and video courses. The cohort members also talk about filling in the gaps in their knowledge, using their new skills at work, and building confidence in their Python journey. Check out realpython.com/workshops [https://realpython.com/workshops] to join the upcoming cohort of the Intermediate Python Deep Dive course. Course Spotlight: Efficient Iterations With Python Iterators and Iterables [https://realpython.com/courses/efficient-iterations-iterators-iterables/] In this video course, you’ll learn what iterators and iterables are in Python. You’ll learn how they differ and when to use them in your code. You’ll also learn how to create your own iterators and iterables to make data processing more efficient. Topics: * 00:00:00 – Introduction * 00:02:04 – Matt’s background * 00:03:17 – Chris’ background * 00:05:55 – Jerry’s background * 00:07:40 – Akhil’s background * 00:09:25 – Rich’s background * 00:10:35 – What skills didn’t translate from the previous language? * 00:11:54 – Learning deeper concepts about OOP in Python * 00:15:42 – Moving beyond scripts and ability to read code * 00:19:41 – How accountability helps with learning * 00:23:41 – Challenges with self-paced learning * 00:28:11 – Having a curated collection of written and video materials * 00:33:28 – Video Course Spotlight * 00:34:56 – What were surprising discoveries? * 00:36:32 – Working on a project * 00:37:27 – Using these new skills at work * 00:45:01 – Refining existing skills * 00:46:41 – Do you feel more confident to learn even further? * 00:49:26 – What are other Python projects you work on? * 00:55:17 – Thanks and goodbyes Show Links: * Intermediate Python Deep Dive Course – Real Python [https://realpython.com/workshops/intermediate-deep-dive/] * Object-Oriented Programming (OOP) in Python – Real Python [https://realpython.com/python3-object-oriented-programming/] * Flipped classroom - Wikipedia [https://en.wikipedia.org/wiki/Flipped_classroom] * itertools — Functions creating iterators for efficient looping — Python 3.13.3 documentation [https://docs.python.org/3/library/itertools.html] * Primer on Python Decorators – Real Python [https://realpython.com/primer-on-python-decorators/] * Pointers in Python: What’s the Point? Intern Objects – Real Python [https://realpython.com/pointers-in-python/#a-note-on-intern-objects-in-python] * Data Classes in Python – Real Python [https://realpython.com/python-data-classes/] Level up your Python skills with our expert-led courses: * Efficient Iterations With Python Iterators and Iterables [https://realpython.com/courses/efficient-iterations-iterators-iterables/] * Python's map() Function: Transforming Iterables [https://realpython.com/courses/map-function-transform-iterables/] * Python Decorators 101 [https://realpython.com/courses/python-decorators-101/] Support the podcast & join our community of Pythonistas [https://realpython.com/join]

What are the current Python graphical user interface libraries? Should you build everything in the terminal and create a text-based user interface instead? Christopher Trudeau is back on the show this week, bringing another batch of PyCoder’s Weekly articles and projects. We cover a Real Python article that explores the Textual library. Textual is a Python toolkit and framework for creating attractive and functional text-based user interface (TUI) applications that run in the user’s terminal. The tutorial covers organizing layouts of widgets, styling components, and handling events and user actions within an application. We continue our exploration of user interface options for your projects by discussing a recent article about Python GUI libraries. The piece compares the frameworks, showing a quick preview of how they look and sample code for a simple application. We share our thoughts and experiences with several of the libraries as we go through the collection. We also share several other articles and projects from the Python community, including a news roundup, handling binary data in Python, exploring the rules terminal programs follow, using Microsoft Edge’s online text-to-speech service from Python, and a project for reading and writing compressed JSON. Course Spotlight: Building a Code Image Generator With Python [https://realpython.com/courses/code-image-generator/] In this step-by-step video course, you’ll build a code image generator that creates nice-looking images of your code snippets to share on social media. Your code image generator will be powered by the Flask web framework and include exciting packages like Pygments and Playwright. Topics: * 00:00:00 – Introduction * 00:02:16 – PyCon US: Travel Grants & Refund Policy * 00:02:57 – PyCon US 2025 travel guidance? * 00:03:32 – Faster Branch Coverage Measurement * 00:04:11 – Python Release Python 3.14.0a6 * 00:04:21 – Django 5.2 Release Candidate 1 Released * 00:04:30 – PyOhio July 26-27, Call for Papers * 00:04:59 – PEP 779: Criteria for Supported Status for Free-Threaded Python * 00:05:45 – Python Textual: Build Beautiful UIs in the Terminal * 00:11:32 – Bytes Objects: Handling Binary Data in Python * 00:16:41 – Video Course Spotlight * 00:18:01 – Which Python GUI Library Should You Use in 2025? * 00:32:08 – Real Python Workshops * 00:34:23 – “Rules” That Terminal Programs Follow * 00:40:29 – edge-tts: Use Microsoft Edge’s online text-to-speech service from Python * 00:44:07 – compress_json: Read and Write Compressed JSON * 00:45:34 – Thanks and goodbye News: * PyCon US: Travel Grants & Refund Policy [https://pycon.blogspot.com/2025/03/travelgrants2025.html] – PyCon US offers travel grants to visitors. This post explains how they’re decided. Also, with changing border requirements in the US, you may also be interested in the Refund Policy for International Attendees [https://pycon.blogspot.com/2025/03/refund-policy-for-international.html]. * PyCon US 2025 travel guidance? - PSF / Ask the staff! - Discussions on Python.org [https://discuss.python.org/t/pycon-us-2025-travel-guidance/85196] * Faster Branch Coverage Measurement [https://nedbatchelder.com/blog/202503/faster_branch_coverage_measurement.html] – After nearly two years, Ned thinks this is finally ready: coverage.py can use sys.monitoring to more efficiently measure branch coverage. * Python Release Python 3.14.0a6 [https://www.python.org/downloads/release/python-3140a6/] * Django 5.2 Release Candidate 1 Released [https://www.djangoproject.com/weblog/2025/mar/19/django-52-rc1/] * PyOhio July 26-27, Call for Papers [https://pretalx.com/pyohio-2025/cfp] * PEP 779: Criteria for Supported Status for Free-Threaded Python [https://peps.python.org/pep-0779/] – PEP 703 (Making the Global Interpreter Lock Optional in CPython), described three phases of development. This PEP outlines the criteria to move between phases. Show Links: * Python Textual: Build Beautiful UIs in the Terminal [https://realpython.com/python-textual/] – Textual is a Python library for building text-based user interfaces (TUIs) that support rich text, advanced layouts, and event-driven interactivity in the terminal. This tutorial showcases some of the ways you can design an appealing and engaging UI using Textual. * Bytes Objects: Handling Binary Data in Python [https://realpython.com/python-bytes/] – In this tutorial, you’ll learn about Python’s bytes objects, which help you process low-level binary data. You’ll explore how to create and manipulate byte sequences in Python and how to convert between bytes and strings. Additionally, you’ll practice this knowledge by coding a few fun examples. * Which Python GUI Library Should You Use in 2025? [https://www.pythonguis.com/faq/which-python-gui-library/] – This post compares the Python GUI libraries available in 2025, including PyQT, PySide, TKinter, and Kivy. * “Rules” That Terminal Programs Follow [https://jvns.ca/blog/2024/11/26/terminal-rules/] – The conventions that most terminal programs follow mean that you can more easily know how to control them. Julia’s post talks about “rules” that terminal programs tend to follow, and so should yours. Projects: * edge-tts: Use Microsoft Edge’s online text-to-speech service from Python WITHOUT needing Microsoft Edge or Windows or an API key [https://github.com/rany2/edge-tts] * compress_json: Read and Write Compressed JSON [https://github.com/LucaCappelletti94/compress_json] Additional Links: * Intermediate Python Deep Dive Course – Real Python [https://realpython.com/workshops/intermediate-deep-dive/] * Episode #80: Make Your Python App Interactive With a Text User Interface (TUI) [https://realpython.com/podcasts/rpp/80/] * Build a Contact Book App With Python, Textual, and SQLite [https://realpython.com/contact-book-python-textual/] * Binary, Bytes, and Bitwise Operators in Python – Video Course [https://realpython.com/courses/binary-bytes-bitwise-operators/] * Nibble (magazine) - Wikipedia [https://en.wikipedia.org/wiki/Nibble_(magazine)] * Python GUI Programming – Real Python [https://realpython.com/tutorials/gui/] * Python GUI Programming With Tkinter – Tutorial [https://realpython.com/python-gui-tkinter/] * Python and PyQt: Building a GUI Desktop Calculator – Tutorial [https://realpython.com/python-pyqt-gui-calculator/] * Build Cross-Platform GUI Apps With Kivy – Tutorial [https://realpython.com/courses/cross-platform-gui-apps-kivy/] * How to Build a Python GUI Application With wxPython – Tutorial [https://realpython.com/python-gui-with-wxpython/] * Episode #182: Building a Python JSON Parser & Discussing Ideas for PEPs [https://realpython.com/podcasts/rpp/182/] * Speech Synthesis Markup Language (SSML) overview - Speech service - Azure AI services | Microsoft Learn [https://learn.microsoft.com/en-us/azure/ai-services/speech-service/speech-synthesis-markup] Level up your Python skills with our expert-led courses: * Building a Python GUI Application With Tkinter [https://realpython.com/courses/building-gui-application-tkinter/] * Build a GUI Calculator With PyQt and Python [https://realpython.com/courses/build-gui-calculator-pyqt/] * Building a Code Image Generator With Python [https://realpython.com/courses/code-image-generator/] Support the podcast & join our community of Pythonistas [https://realpython.com/join]

What goes into updating one of the most popular books about working with Python? After a decade of changes in the Python landscape, what projects, libraries, and skills are relevant to an office worker? This week on the show, we speak with previous guest Al Sweigart about the third edition of “Automate the Boring Stuff With Python.” Al shares his thoughts on teaching Python and writing books over the past decade. In this third edition, he shares several new projects and updates to existing ones. We discuss Python tools for transcription, text-to-speech, notifications, and data storage. We talk about the importance of debugging and improvements to Python error messages. He also shares a collection of resources, including conference talks, small projects, and Python libraries. Course Spotlight: Exploring Scopes and Closures in Python [https://realpython.com/courses/exploring-scopes-and-closures-in-python/] In this Code Conversation video course, you’ll take a deep dive into how scopes and closures work in Python. To do this, you’ll use a debugger to walk through some sample code, and then you’ll take a peek under the hood to see how Python holds variables internally. Topics: * 00:00:00 – Introduction * 00:01:46 – The Recurse Center and scrollart.org * 00:05:11 – Third Edition of Automate the Boring Stuff With Python * 00:07:32 – The types of projects covered in the new edition * 00:09:44 – What was the original page count? * 00:11:00 – Learning Python and it being perceived as magic * 00:12:00 – PyCon US 2025 - Make Python Talk and Listen * 00:14:22 – Text-to-speech with pyttsx3 * 00:19:31 – Generating notifications and messages with ntfy.sh * 00:22:09 – Exploring SQLite * 00:28:26 – Teaching enough to start building * 00:31:03 – The Recursive Book of Recursion * 00:32:45 – Do you see a change in the audience of Python learners * 00:35:36 – Expectations put upon a new Python learner * 00:40:28 – What changes has 10 years inspired for the book? * 00:43:40 – Teaching things in a new order and debugging * 00:47:31 – Video Course Spotlight * 00:48:56 – Including simple projects * 00:54:12 – Book release timeframe and pre-orders * 00:58:26 – In-line metadata for Python script sharing * 00:59:33 – What are you excited about in the world of Python? * 01:01:56 – What do you want to learn next? * 01:04:34 – How can people follow your work online? * 01:05:19 – Thanks and goodbye Show Links: * Automate the Boring Stuff with Python, 3rd Edition - No Starch Press [https://nostarch.com/automate-boring-stuff-python-3rd-edition] * The Recurse Center [https://www.recurse.com/] * scrollart.org [https://scrollart.org/] * 20 GOTO 10: How to Make Scrolling ASCII Art - PyTexas 2024 - YouTube [https://www.youtube.com/watch?v=SyKUBXJLL50] * Episode #26: 5 Years Podcasting Python With Michael Kennedy: Growth, GIL, Async, and More [https://realpython.com/podcasts/rpp/26/] * whisper: Robust Speech Recognition via Large-Scale Weak Supervision [https://github.com/openai/whisper] * PyVideo.org - Al Sweigart [https://pyvideo.org/speaker/al-sweigart.html] * pyttsx3: Offline Text To Speech Synthesis for Python [https://github.com/nateshmbhat/pyttsx3] * pyttsx3 - PyPI [https://pypi.org/project/pyttsx3/] * tesseract: Tesseract Open Source OCR Engine [https://github.com/tesseract-ocr/tesseract] * Make Python Talk, Make Python Listen - PyCon US 2025 [https://us.pycon.org/2025/schedule/presentation/114/] * yt-dlp: A feature-rich command-line audio/video downloader [https://github.com/yt-dlp/yt-dlp] * ntfy.sh - Send push notifications to your phone via PUT/POST [https://ntfy.sh/#free-software] * SQLite Home Page [https://www.sqlite.org/] * SQLite and SQLAlchemy in Python: Move Your Data Beyond Flat Files – video course [https://realpython.com/courses/sqlite-sqlalchemy-python-beyond-flat-files/] * The Recursive Book of Recursion - No Starch Press [https://nostarch.com/recursive-book-recursion] * Al Sweigart: The Amazing Mutable, Immutable Tuple - YouTube [https://www.youtube.com/watch?v=argy7dRB_LI] * Python Developers Survey 2023 Results [https://lp.jetbrains.com/python-developers-survey-2023/] * Inline script metadata - Python Packaging User Guide [https://packaging.python.org/en/latest/specifications/inline-script-metadata/#inline-script-metadata] * PyCon US 2025 [https://us.pycon.org/2025/] * Rust Programming Language [https://www.rust-lang.org/] * Al Sweigart (@AlSweigart@mastodon.social) - Fosstodon [https://fosstodon.org/@AlSweigart@mastodon.social] * Al Sweigart (@alsweigart.bsky.social) — Bluesky [https://bsky.app/profile/alsweigart.bsky.social] * Invent with Python [https://inventwithpython.com/] Level up your Python skills with our expert-led courses: * Debugging in Python With pdb [https://realpython.com/courses/python-debugging-pdb/] * Exploring Scopes and Closures in Python [https://realpython.com/courses/exploring-scopes-and-closures-in-python/] * SQLite and SQLAlchemy in Python: Move Your Data Beyond Flat Files [https://realpython.com/courses/sqlite-sqlalchemy-python-beyond-flat-files/] Support the podcast & join our community of Pythonistas [https://realpython.com/join]

How can you simplify the management of your Python projects with one file? What are the advantages of using LazyFrames in Polars? Christopher Trudeau is back on the show this week, bringing another batch of PyCoder’s Weekly articles and projects. We share a recent Real Python tutorial by Ian Currie about managing projects with a pyproject.toml file. This file simplifies Python project configuration by unifying package setup, managing dependencies, and streamlining builds. Christopher continues his exploration of the Polars library by covering another Real Python tutorial about working with LazyFrames. He describes how LazyFrames don’t contain data but instead store a set of instructions known as a query plan. We also share several other articles and projects from the Python community, including a news roundup, building a to-do app with Python and Kivy, working with DuckDB directly instead of using a DataFrame library, a discussion on fiction and nonfiction books about computer science, a terminal visual effects engine, and a full-stack platform for interactive data apps. Course Spotlight: Everyday Project Packaging With pyproject.toml [https://realpython.com/courses/packaging-with-pyproject-toml/] In this Code Conversation video course, you’ll learn how to package your everyday projects with pyproject.toml. Playing on the same team as the import system means you can call your project from anywhere, ensure consistent imports, and have one file that’ll work for many build systems. Topics: * 00:00:00 – Introduction * 00:02:00 – Happy Pi Day! * 00:02:15 – Follow-up: Is BDD Dying? * 00:03:32 – Django security releases issued: 5.1.7, 5.0.13 and 4.2.20 * 00:04:01 – Django 5.2 Beta 1 Released * 00:04:11 – DjangoCon Africa Aug 2025 CFP * 00:04:29 – Launching the PyCon US 2025 Schedule * 00:04:48 – PyPy v7.3.19 Release * 00:05:06 – Poetry 2.0.0 Released * 00:05:34 – How to Manage Python Projects With pyproject.toml * 00:12:10 – Build a To-Do App With Python and Kivy * 00:16:22 – Mastering DuckDB When You’re Used to pandas or Polars * 00:21:08 – Video Course Spotlight * 00:22:42 – How to Work With Polars LazyFrames * 00:27:41 – Fiction/Non-Fiction Books on the Topic of CS? * 00:42:28 – preswald: Full-Stack Platform for Interactive Data Apps * 00:45:52 – terminaltexteffects: Terminal Visual Effects Engine * 00:47:59 – Thanks and goodbye Follow-up: * Episode #239: Behavior-Driven vs Test-Driven Development & Using Regex in Python [https://realpython.com/podcasts/rpp/239/] * Is BDD Dying? - Automation Panda [https://automationpanda.com/2025/03/06/is-bdd-dying/] News: * Django security releases issued: 5.1.7, 5.0.13 and 4.2.20 | Weblog | Django [https://www.djangoproject.com/weblog/2025/mar/06/security-releases/] * Django 5.2 Beta 1 Released [https://www.djangoproject.com/weblog/2025/feb/19/django-52-beta-1-released/] * DjangoCon Africa Aug 2025, Arusha, Tanzania, (Call for Proposals) [https://pretalx.com/djangocon-africa-2025/cfp] * Launching the PyCon US 2025 Schedule [https://pycon.blogspot.com/2025/02/launching-pycon-us-2025-schedule.html] – This post summarizes the schedule for PyConUS, including a summary of the keynote speakers, and updates on conference swag. * PyPy v7.3.19 Release [https://pypy.org/posts/2025/02/pypy-v7319-release.html] * Poetry 2.0.0 Released [https://python-poetry.org/blog/announcing-poetry-2.0.0] Show Links: * How to Manage Python Projects With pyproject.toml [https://realpython.com/python-pyproject-toml/] – Learn how to manage Python projects with the pyproject.toml configuration file. In this tutorial, you’ll explore key use cases of the pyproject.toml file, including configuring your build, installing your package locally, managing dependencies, and publishing your package to PyPI. * Build a To-Do App With Python and Kivy [https://www.pythonguis.com/examples/kivy-to-do-app/] – “In this tutorial, you’ll go through a series of steps to build a basic To-Do app with Python, SQLite, and Kivy.” * Mastering DuckDB When You’re Used to pandas or Polars [https://labs.quansight.org/blog/duckdb-when-used-to-frames] – Why use DuckDB / SQL at all if you’re used to DataFrames? This article makes the case for some reasons why, and shows how to perform some operations which in DataFrames are basic but in SQL aren’t necessarily obvious. * How to Work With Polars LazyFrames [https://realpython.com/polars-lazyframe/] – In this tutorial, you’ll gain an understanding of the principles behind Polars LazyFrames. You’ll also learn why using LazyFrames is often the preferred option over more traditional DataFrames. Discussion: * Fiction/Non-Fiction Books on the Topic of CS? [https://news.ycombinator.com/item?id=43084739] * Christopher Trudeau’s most recommended books (picked by super fans) [https://shepherd.com/search/author/57674] * ctrudeau - LibraryThing [https://www.librarything.com/profile/ctrudeau] Project: * preswald: Full-Stack Platform for Interactive Data Apps [https://github.com/StructuredLabs/preswald] * terminaltexteffects: Terminal Visual Effects Engine [https://github.com/ChrisBuilds/terminaltexteffects] Additional Links: * Pi Day - Celebrate Mathematics on March 14th [https://www.piday.org/] * What’s new in Python 3.14 — Python 3.14.0a5 documentation [https://docs.python.org/3.14/whatsnew/3.14.html] * Mark Litwintschik - Tech Blog [https://tech.marksblogg.com/] * Episode #224: Narwhals: Expanding DataFrame Compatibility Between Libraries [https://realpython.com/podcasts/rpp/224/] * Working With Python Polars - Video Course [https://realpython.com/courses/working-with-python-polars/] * How to Deal With Missing Data in Polars – Tutorial [https://realpython.com/polars-missing-data/] * Book Review: The Little Schemer - The Invent with Python Blog [https://inventwithpython.com/blog/2018/12/09/book-review-the-little-schemer/] Books Mentioned by Mr. Trudeau: * “The Cuckoo’s Egg” by Clifford Stoll * “Mythical Man Month” by Frederick Brooks * “Phoenix Project” by Gene Kim * “Dreaming in Code” by Scott Rosenberg * “Digital Fortress” by Dan Brown * “Godel Escher, Bach” by Douglas Hofstadlter * “A Philosophy of Software Design” by John Ousterhout’s * “I Hate The Internet” by Jarret Kobek * “Snow Crash” by Neal Stephenson * “Automate the Boring Stuff with Python” by Al Sweigart * “Django In Action” by Christopher Trudeau * “Refactoring Databases” by Scott W Ambler and Pramod J Sadalage * “The C Programming Language” by Dennis M. Ritchie and Brian W. Kernighan * “Open Source Licensing” by Lawrence Rosen * “The Quick Python Book” by Naomi R. Ceder * “Learn to Code By Solving Problems: A Python Programming Primer” by Daniel Zingaro * “Python Automation Cookbook” by Jaime Buelta Books Mentioned by Mr. Bailey: * “The Little Schemer” by Daniel P. Friedman * “Zen and the Art of Motorcycle Maintenance” by Robert M. Pirsig * “Shop Class as Soulcraft: An Inquiry into the Value of Work” by Matthew B. Crawford * “Django for Beginners, APIs, and Professionals” by William S. Vincent * “Python Crash Course” by Eric Matthes * “Automate the Boring Stuff With Python” by Al Sweigart * “Fluent Python” by Luciano Ramalho * “Practices of the Python Pro” by Dane Hillard * “Daemon and Freedom™” by Daniel Suarez Level up your Python skills with our expert-led courses: * Everyday Project Packaging With pyproject.toml [https://realpython.com/courses/packaging-with-pyproject-toml/] * Working With Python Polars [https://realpython.com/courses/working-with-python-polars/] * Publishing Python Packages to PyPI [https://realpython.com/courses/pypi-publish-python-package/] Support the podcast & join our community of Pythonistas [https://realpython.com/join]