Keep graph db connection open from web server

[rhys]

Hello.

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.

Thank you in advance.
Rhys

[Cobra]

Hello @rhys

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.

Regards,
Cobra

[michael_hunger · Accepted solution]

Yes your app can hold a driver instance in its state.

See here

GitHub

neo4j-examples/movies-python-bolt

Neo4j Example application with flask backend using the neo4j-python-driver - neo4j-examples/movies-python-bolt

[rhys]

That's exactly what I needed, thank you.