# #458 I will install Linux on your computer

Page: https://stenobird.com/podcast/python-bytes/458-i-will-install-linux-on-your-computer
Text version: https://stenobird.com/podcast/python-bytes/458-i-will-install-linux-on-your-computer.md
Podcast: [Python Bytes](https://stenobird.com/podcast/python-bytes)
Published: 2025-11-17T08:00:00+00:00
Episode link: https://pythonbytes.fm/episodes/show/458/i-will-install-linux-on-your-computer
Audio file: https://pythonbytes.fm/episodes/download/458/i-will-install-linux-on-your-computer.mp3
Processing state: processed
JSON: https://stenobird.com/v1/public/podcasts/python-bytes/episodes/458-i-will-install-linux-on-your-computer
Duration seconds: 1367

## Resource

A deep dive into modern Python tooling, covering performance optimizations for SQLite and dependency management. The episode also explores new ways to navigate remote servers and a potential redesign for the Django website.

## Highlights
- Main idea: aiosqlitepool can nearly double throughput for SQLite operations in async Python environments
- Practical takeaway: Use deptry to identify unused or missing dependencies in your Python projects
- Failure mode: Be careful with deptry's handling of optional dependency groups to avoid false positives in your requirements
- Practical takeaway: Jeffin Browser provides a high-syntax-highlighting way to explore files over SSH
- Main idea: Modernizing the Django website through community-driven design mockups

## Topics

Python, Django, SQLite, Asyncio, Dependency Management, Linux, Software Development, DevOps

## Chapters
- 1:00 — Django Website Redesign: A look at Adam Hill's mockup for a modernized Django web interface and how to contribute via PRs.
- 6:00 — Optimizing SQLite with aiosqlitepool: Analyzing the performance gains of using connection pooling in asynchronous Python applications.
- 9:30 — Dependency Auditing with Deptry: How to use deptry to find missing or redundant dependencies, and the pitfalls of managing optional groups.
- 14:35 — Terminal File Browsing with Jeffin Browser: Exploring remote servers more efficiently using a terminal-based browser with syntax highlighting.
- 19:30 — Workspace Syncing and TDD: Brief discussion on syncing project workspaces across machines and upcoming Test Driven Development resources.

## Actions

- request_transcript: `POST https://stenobird.com/v1/public/podcasts/python-bytes/episodes/458-i-will-install-linux-on-your-computer/transcription-requests` — Idempotently request low-priority transcript generation for this episode.
- read_markdown: `GET https://stenobird.com/podcast/python-bytes/458-i-will-install-linux-on-your-computer.md` — Read the agent-friendly Markdown representation of this episode resource.

A page view does not enqueue transcription. Agents should invoke `request_transcript` explicitly when they need this episode processed.

## Transcript

Full transcripts are not published on public pages unless there is a clear rights basis.