Topics covered in this episode:

* 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

Watch on YouTube

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

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

#441 It's Michaels All the Way Down

Python Bytes