Innovative Data Management Solutions: Terso Cloud and Lightstream.io

• * Distributed sqlite follow up: Turso and Litestream*
• * PEP 792 – Project status markers in the simple index*
• Run coverage on tests
• docker2exe: Convert a Docker image to an executable
• Extras
• Joke

About the show

Sponsored by Digital Ocean: pythonbytes.fm/digitalocean-gen-ai Use code DO4BYTES and get $200 in free credit

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.

Michael #1: Distributed sqlite follow up: Turso and Litestream

• Michael Booth:
  • Turso marries the familiarity and simplicity of SQLite with modern, scalable, and distributed features.
  • Seems to me that Turso is to SQLite what MotherDuck is to DuckDB.
• Mike Fiedler
  • Continue to use the SQLite you love and care about (even the one inside Python runtime) and launch a daemon that watches the db for changes and replicates changes to an S3-type object store.
  • Deeper dive: Litestream: Revamped

Brian #2: PEP 792 – Project status markers in the simple index

• Currently 3 status markers for packages
  • Trove Classifier status
  • Indices can be yanked
  • PyPI projects - admins can quarantine a project, owners can archive a project
• Proposal is to have something that can have only one state
  • active
  • archived
  • quarantined
  • deprecated
• This has been Approved, but not Implemented yet.

Brian #3: Run coverage on tests

• Hugo van Kemenade
• And apparently, run Ruff with at least F811 turned on
• Helps with copy/paste/modify mistakes, but also subtler bugs like consumed generators being reused.

Michael #4: docker2exe: Convert a Docker image to an executable

• This tool can be used to convert a Docker image to an executable that you can send to your friends.
• Build with a simple command: $ docker2exe --name alpine --image alpine:3.9
• Requires docker on the client device
• Probably doesn’t map volumes/ports/etc, though could potentially be exposed in the dockerfile.

Extras

Brian:

• Back catalog of Test & Code is now on YouTube under @TestAndCodePodcast
  • So far 106 of 234 episodes are up. The rest are going up according to daily limits.
  • Ordering is rather chaotic, according to upload time, not release ordering.
• There will be a new episode this week
  • pytest-django with Adam Johnson

Joke: If programmers were doctors