Topics covered in this episode:


Possibility of a new website for Django
aiosqlitepool
deptry
browsr
Extras
Joke

Watch on YouTube

About the show

Sponsored by us! Support our work through:


Our courses at Talk Python Training
The Complete pytest Course
Patreon Supporters


Connect with the hosts


Michael: @[email protected] / @mkennedy.codes (bsky)
Brian: @[email protected] / @brianokken.bsky.social
Show: @[email protected] / @pythonbytes.fm (bsky)


Join us on YouTube at pythonbytes.fm/live to be part of the audience. Usually Monday at 10am PT. Older video versions available there too.

Finally, if you want an artisanal, hand-crafted digest of every week of the show notes in email form? Add your name and email to our friends of the show list, we'll never share it.

Brian #1: Possibility of a new website for Django


Current Django site: djangoproject.com
Adam Hill’s in progress redesign idea: django-homepage.adamghill.com
Commentary in the Want to work on a homepage site redesign? discussion


Michael #2: aiosqlitepool


🛡️A resilient, high-performance asynchronous connection pool layer for SQLite, designed for efficient and scalable database operations.
About 2x better than regular SQLite.
Pairs with aiosqlite
aiosqlitepool in three points:

Eliminates connection overhead: It avoids repeated database connection setup (syscalls, memory allocation) and teardown (syscalls, deallocation) by reusing long-lived connections.
Faster queries via "hot" cache: Long-lived connections keep SQLite's in-memory page cache "hot." This serves frequently requested data directly from memory, speeding up repetitive queries and reducing I/O operations.
Maximizes concurrent throughput: Allows your application to process significantly more database queries per second under heavy load.



Brian #3: deptry


“deptry is a command line tool to check for issues with dependencies in a Python project, such as unused or missing dependencies. It supports projects using Poetry, pip, PDM, uv, and more generally any project supporting PEP 621 specification.”
“Dependency issues are detected by scanning for imported modules within all Python files in a directory and its subdirectories, and comparing those to the dependencies listed in the project's requirements.”
Note if you use project.optional-dependencies


[project.optional-dependencies]
plot = ["matplotlib"]
test = ["pytest"]


you have to set a config setting to get it to work right:


[tool.deptry]
pep621_dev_dependency_groups = ["test", "docs"]




Michael #4: browsr


browsr 🗂️ is a pleasant file explorer in your terminal. It's a command line TUI (text-based user interface) application that empowers you to browse the contents of local and remote filesystems with your keyboard or mouse.
You can quickly navigate through directories and peek at files whether they're hosted locally, in GitHub, over SSH, in AWS S3, Google Cloud Storage, or Azure Blob Storage.
View code files with syntax highlighting, format JSON files, render images, convert data files to navigable datatables, and more.


Extras

Brian:


Understanding the MICRO
TDD chapter coming out later today or maybe tomorrow, but it’s close.


Michael:


Peacock is excellent


Joke: I will find you

Ver todos los episodios