1201737 - Close Zenko Postgres connection after each query

Status: RESOLVED FIXED

(Content Services Graveyard :: Tiles: Administration Front-End, defect)

Description

[Matthew Ruttley [:mruttley]]

najiang has requested that the connection to the database in zenko be closed after each request as it is causing problems on the backend. 

This was mentioned in a github issue here:
https://github.com/matthewruttley/zenko/issues/1

He says "In Zenko, all database queries are executed via two global connections/cursors. That might unnecessarily hold the connection resources and prevent other applications from accessing the database.

Better localize the connection usage, like create a new connection while executing a new query, and close it immediately once you're done using this connection. "

I think this can be fixed by abstracting all queries to a specific querying function.

Comment 1

[Matthew Ruttley [:mruttley]]

Fixed https://github.com/matthewruttley/zenko/commit/e47023800380f53ede1e6db2cce35cdfaec4155e