aiosqlitepool: Async SQLite Connection Pool Benefits

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

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: @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