Python Weekly (Issue 716 October 2 2025)

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

UN-Limited Limit Orders

Why pay gas for limit orders that never execute? With CoW Swap, you can set an unlimited number of limit orders – more than your wallet balance – then cancel them all at no cost to you. Try Limit Orders.


Articles, Tutorials and Talks

The video explores applying the SOLID design principles to improve Python code quality by refactoring a messy sales report script into both a clean class-based and a lean functional version. It discusses the relevance of SOLID principles in Python, showing how they enhance code modularity, testability, and maintainability while highlighting when they might lead to overengineering.

How to implement a single AI agent with an LLM API and no frameworks.

The video explains how marimo, a modern Python notebook, enhances productivity in Django projects by integrating SQL support, coding agents, and interactivity beyond the traditional Django shell. It demonstrates using marimo for database connections, asynchronous Django ORM operations, custom admin interfaces, and reactive, interactive notebooks that combine SQL, Python, and UI elements for a smoother workflow.

The article summarizes a talk and discussions from the 2025 CPython Core Dev Sprint focusing on CPython's new tracing JIT, which shares similarities with PyPy's tracing JIT but faces unique challenges. Key issues include handling trace blockers (calls to C extensions), exponential tracing due to data-driven control flow, and generator overhead, all of which complicate optimizing real-world Python code with a tracing JIT approach. The article emphasizes that CPython's JIT is new and evolving, with hopes to address these challenges for better performance in the future.

Every developer knows the pain of getting stuck in code. Blackbox is built to keep you moving. With powerful autocomplete, instant explanations, and lightning-fast code search, it is like having a senior engineer on call. Already trusted by 30M+ users worldwide. SPONSOR

The article emphasizes that DuckDB and Polars are not direct competitors but complementary tools in the Modern Data Stack, with each excelling in different contexts: DuckDB is best for SQL-heavy analytics and embedding as a query engine, while Polars suits end-to-end ETL pipelines and DataFrame-centric workflows. The choice depends on your problem context, team comfort, and use case rather than raw speed benchmarks, advocating for strategic use of both tools rather than choosing one over the other.

Context is a critical but finite resource for AI agents. In this post, we explore strategies for effectively curating and managing the context that powers them.

The article introduces context manager support in the mssql-python driver, allowing Python applications to manage SQL Server and Azure SQL resources more safely and efficiently using Python's "with" statement. This feature automates opening and closing of connections and cursors, as well as commit and rollback of transactions, reducing boilerplate code, preventing resource leaks, and ensuring consistent transaction handling in a Pythonic and readable way.


Books

A comprehensive, beginner-friendly resource covering fundamental topics from vectors and matrices to linear transformations, eigenvalues, orthogonality, and applications in computation. It provides clear explanations of concepts like vector spaces, determinants, least squares, and PCA, structured across ten detailed chapters aimed at building deep intuition and practical skills in linear algebra.


Interesting Projects, Tools, and Libraries

Private, fast, and honest web browser.

Onyx is a feature-rich, self-hostable Chat UI that works with any LLM. It is easy to deploy and can run in a completely airgapped environment.

Create large-scale synthetic training data for model distillation and evaluation.

Batteries-included eval framework for search APIs.

Web development framework that brings the Next.js developer experience to Python, built on FastAPI, htmy, and FastHX.

Video-based AI memory library. Store millions of text chunks in MP4 files with lightning-fast semantic search. No database needed.

Logly is a Rust-powered, Loguru-like logging library for Python that combines the familiarity of Python’s standard logging API with high-performance logging capabilities.


New Releases

The Django team issued security releases for versions 5.2.7, 5.1.13, and 4.2.25 to address two vulnerabilities: a high-severity potential SQL injection in QuerySet methods on MySQL and MariaDB, and a low-severity partial directory-traversal issue in the archive.extract() function. These patches have been applied across the main, 6.0 (alpha), 5.2, 5.1, and 4.2 branches, and users are encouraged to upgrade promptly.


Upcoming Events and Webinars

There will be following talks

  • Large-scale JAX Development with JAX-Toolbox

  • GaaS Station: An In-House Framework for Prod-Ready AI Agents

  • Advanced Data Science for Credit Risk Modeling: The Good, The Bad, and The Defaulted

Conveying meaning using data, Dave will walk through the importance and key features of dashboards. He will also showcase a dashboard he made for a hobby of his.

There will be following talks

  • "Get me answers, Data Monkey!": how can we navigate management who don't get data?

  • Measuring the dynamics of healthcare accessibility by public transport in England: a comparison of scheduled and observed travel time

There will be following talks

  • Build Your Own AI Agent

  • What Happens Inside an MCP Server?

There will be a talk, Vibe Coding: Is It Right For Data Science?


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.