Python Weekly (Issue 726 December 18 2025)

Author

Rahul Chaudhary
December 18, 2025

Welcome to issue 726 of Python Weekly. Let's get straight to the links this week.

Become An AI Expert In Just 5 Minutes

If you’re a decision maker at your company, you need to be on the bleeding edge of, well, everything. But before you go signing up for seminars, conferences, lunch ‘n learns, and all that jazz, just know there’s a far better (and simpler) way: Subscribing to The Deep View.

This daily newsletter condenses everything you need to know about the latest and greatest AI developments into a 5-minute read. Squeeze it into your morning coffee break and before you know it, you’ll be an expert too.

Subscribe right here. It’s totally free, wildly informative, and trusted by 600,000+ readers at Google, Meta, Microsoft, and beyond.


News

New spy boss says officers must master code alongside tradecraft as agency navigates 'space between peace and war'


Articles, Tutorials and Talks

This video demonstrates refactoring a deeply nested, 12-level if/else monster for order approval logic (handling users, discounts, regions, currencies, etc.) into clean Python using characterization tests as a safety net. Step-by-step: flatten with guard clauses, name conditions via helpers, simplify loops/comprehensions, merge duplicates into rule lists, remove broad try/excepts, and externalize rules to data—yielding readable, extensible code that passes all tests.

Learn how to build a blazingly fast Python CI pipeline using uv, pex, and Grog. This post shows how to combine uv's dependency caching with pex's executable bundling to achieve sub-second build times in Python monorepos. We'll explore techniques for dependency resolution, cross-platform builds, and efficient Docker packaging - all while keeping the setup lightweight and maintainable.

In this article, we will add structure to our initial setup and focus on the memory, or state management, level of the app. By the end of this read, our AI Agent will be able to keep track of conversations with the user. We will define the scope of its work, set personality traits, and provide it with the tools to retrieve and save data to a database. We will also create a second agent to help organize these memories.

Your First Steps With the Flet Library for Desktop and Web Python GUIs.

Jubilant is a Python API for Juju, a deployment and operations tool created by Canonical. While Jubilant itself is very simple, this article describes some design choices that might be interesting to other developers: the use of Python’s subprocess.run, code generation to create Python dataclasses from Go structs, and the use of Make and uv.

Transform SQL queries into vector embeddings to cluster, compare, and analyze behaviors in data lakes with precision.

Well placed spaces and line breaks can greatly improve the readability of your Python code.

Through a websocket callback mechanism, agents can execute MCP and tools defined in any language within a single execution environment.

Self Improving Text2Sql Agent with Dynamic Context and Continuous Learning

This post shows how to build a self-improving Text-to-SQL agent using dynamic context and "poor-man's continuous learning".


Interesting Projects, Tools, and Libraries

Production-ready FastAPI infrastructure in one import.

Local-first AI-powered document intelligence platform for investigative journalism.

Minimal CLI coding agent by Mistral.

Turns your research papers, reports, and documents into professional slides & posters in minutes.

A modern desktop framework for Python.

A batteries-included WebSocket framework for Django Channels, FastAPI, and ASGI-based applications.

The lazygit of SQL databases. Connect to Postgres, MySQL, SQL Server, SQLite, Supabase, Turso, and more from your terminal in seconds.

Create beautiful Spotify Wrapped-style visualizations for your WhatsApp group chats!

AIsbom is a specialized security and compliance scanner for Machine Learning artifacts.

Bitwave is a high-fidelity, developer-friendly, future-proof audio format designed for modern sound experiences - including spatial audio, dynamic tempo adjustment, and multi-track support.

An open-source platform to define, organize, and run Agentic AI.


Our Other Newsletters

Programmer Weekly - A free weekly newsletter for programmers.

Founder Weekly - A free weekly newsletter for entrepreneurs featuring best curated content, must read articles, how to guides, tips and tricks, resources, events and more.