#458 I will install Linux on your computer

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: @[e-mail] / @mkennedy.codes (bsky)
• Brian: @[e-mail] / @brianokken.bsky.social
• Show: @[e-mail] / @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 = [