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:

Connect with the hosts

Michael: @mkennedy@fosstodon.org / @mkennedy.codes (bsky)
Brian: @brianokken@fosstodon.org / @brianokken.bsky.social
Show: @pythonbytes@fosstodon.org / @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

#458 I will install Linux on your computer

Python Bytes