On Linux, I’d just build my own Python binaries and make them available. But you can also use pyenv for the same thing if you’re ok with it.

Then, using poetry, I have different projects with isolated environments.

This, but, with DatabaseConnection being a singleton, and preventing multiple enter clauses.

You can ensure it’s a singleton by modifying how a new object is built, by overriding the new dunder method. If an instance exists, return that, otherwise create a new one.