Topics covered in this episode:

<ul>
	<li>Possibility of a new website for Django</li>
<li><a href="https://github.com/slaily/aiosqlitepool?featured_on=pythonbytes">aiosqlitepool</a></li>
<li><a href="https://deptry.com?featured_on=pythonbytes">deptry</a></li>
<li><a href="https://github.com/juftin/browsr?featured_on=pythonbytes">browsr</a></li>
<li>Extras</li>
<li>Joke</li>

</ul><a href='https://www.youtube.com/watch?v=s2HlckfeBCs' style='font-weight: bold;'data-umami-event="Livestream-Past" data-umami-event-episode="458">Watch on YouTube</a>

About the show

Sponsored by us! Support our work through:

<ul>
<li>Our <a href="https://training.talkpython.fm/?featured_on=pythonbytes">courses at Talk Python Training</a></li>
<li><a href="https://courses.pythontest.com/p/the-complete-pytest-course?featured_on=pythonbytes">The Complete pytest Course</a></li>
<li><a href="https://www.patreon.com/pythonbytes">Patreon Supporters</a></li>
</ul>

Connect with the hosts

<ul>
<li>Michael: <a href="https://fosstodon.org/@mkennedy">@mkennedy@fosstodon.org</a> / <a href="https://bsky.app/profile/mkennedy.codes?featured_on=pythonbytes">@mkennedy.codes</a> (bsky)</li>
<li>Brian: <a href="https://fosstodon.org/@brianokken">@brianokken@fosstodon.org</a> / <a href="https://bsky.app/profile/brianokken.bsky.social?featured_on=pythonbytes">@brianokken.bsky.social</a></li>
<li>Show: <a href="https://fosstodon.org/@pythonbytes">@pythonbytes@fosstodon.org</a> / <a href="https://bsky.app/profile/pythonbytes.fm">@pythonbytes.fm</a> (bsky)</li>
</ul>

Join us on YouTube at <a href="https://pythonbytes.fm/stream/live">pythonbytes.fm/live</a> 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 <a href="https://pythonbytes.fm/friends-of-the-show">our friends of the show list</a>, we'll never share it.

Brian #1: Possibility of a new website for Django

<ul>
<li>Current Django site: <a href="https://www.djangoproject.com?featured_on=pythonbytes">djangoproject.com</a></li>
<li>Adam Hill’s in progress redesign idea: <a href="https://django-homepage.adamghill.com?featured_on=pythonbytes">django-homepage.adamghill.com</a></li>
<li>Commentary in the <a href="https://forum.djangoproject.com/t/want-to-work-on-a-homepage-site-redesign/42909/35?featured_on=pythonbytes">Want to work on a homepage site redesign? discussion</a></li>
</ul>

Michael #2: <a href="https://github.com/slaily/aiosqlitepool?featured_on=pythonbytes">aiosqlitepool</a>

<ul>
<li>🛡️A resilient, high-performance asynchronous connection pool layer for SQLite, designed for efficient and scalable database operations.</li>
<li>About 2x better than regular SQLite.</li>
<li>Pairs with <a href="https://github.com/omnilib/aiosqlite?featured_on=pythonbytes">aiosqlite</a></li>
<li><code>aiosqlitepool</code> in three points:
<ul>
<li>Eliminates connection overhead: It avoids repeated database connection setup (syscalls, memory allocation) and teardown (syscalls, deallocation) by reusing long-lived connections.</li>
<li>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.</li>
<li>Maximizes concurrent throughput: Allows your application to process significantly more database queries per second under heavy load.</li>
</ul></li>
</ul>

Brian #3: <a href="https://deptry.com?featured_on=pythonbytes">deptry</a>

<ul>
<li>“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.”</li>
<li>“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.”</li>
<li>Note if you use <code>project.optional-dependencies</code>

<div class="codehilite">
<pre><code>[project.optional-dependencies]
plot = ["matplotlib"]
test = ["pytest"]
</code></pre>
</div></li>
<li>you have to set a config setting to get it to work right:

<div class="codehilite">
<pre><code>[tool.deptry]
pep621_dev_dependency_groups = ["test", "docs"]
</code></pre>
</div></li>
</ul>

Michael #4: <a href="https://github.com/juftin/browsr?featured_on=pythonbytes">browsr</a>

<ul>
<li><code>browsr</code> 🗂️ 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.</li>
<li>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.</li>
<li>View code files with syntax highlighting, format JSON files, render images, convert data files to navigable datatables, and more.</li>
</ul>

Extras

Brian:

<ul>
<li>Understanding the MICRO</li>
<li>TDD chapter coming out later today or maybe tomorrow, but it’s close.</li>
</ul>

Michael:

<ul>
<li><a href="https://marketplace.visualstudio.com/items?itemName=johnpapa.vscode-peacock&featured_on=pythonbytes">Peacock</a> is excellent</li>
</ul>

Joke: <a href="https://x.com/thatstraw/status/1977317574779048171?featured_on=pythonbytes">I will find you</a>

Podurama

Home

Trending

Personal

Your Podcasts

New Episodes

My Files

Favourite Episodes

Tags (Folders)

Recently Played

Bookmarks

Followed Playlists

#458 I will install Linux on your computer

Python Bytes

AI Chapters

AI Insights

Reviews