I will be creating various Python programs running over NGINX. I'll be connection from Python to my Aura instance. For each Python script, I have to open and close the database...as we know, the most expensive request you can make.
I would love to know if there's a way to keep a connection open or if I can install a daemon that keeps a connection open and shares the connection with Python.
Did you try to create a REST API in Python? You could create several endpoints to access your database while the connection will stay open since it will be up when the API will be online.