Stenobird

Episode

#458 I will install Linux on your computer

Podcast
Python Bytes
Published
Nov 17, 2025
Duration seconds
1367
Processing state
processed
Canonical source
https://pythonbytes.fm/episodes/show/458/i-will-install-linux-on-your-computer
Audio
https://pythonbytes.fm/episodes/download/458/i-will-install-linux-on-your-computer.mp3
JSON
/v1/public/podcasts/python-bytes/episodes/458-i-will-install-linux-on-your-computer
Markdown
/podcast/python-bytes/458-i-will-install-linux-on-your-computer.md

Actions

  • 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.
  • 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.

Summary

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.

Topics

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

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

Chapters

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