I’ve seen two approaches which I’m going to post in the comments to see which one is considered best. Feel free to suggest others.

    • coffeewithalex@lemmy.world
      8·
      1 year ago

      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.