Replace "borg" connection manager with thread safe db pool

orchestracities / ngsi-timeseries-api

QuantumLeap: a FIWARE Generic Enabler to support the usage of NGSIv2 (and NGSI-LD experimentally) data in time-series databases

https://quantumleap.rtfd.io/

MIT License

38 stars 49 forks source link

Replace "borg" connection manager with thread safe db pool #397

Open chicco785 opened 3 years ago

chicco785 commented 3 years ago

Pools are not offered in the basic driver of crate and psql. It would be good to explore a proper db pool.

_Originally posted by @chicco785 in https://github.com/smartsdk/ngsi-timeseries-api/pull/373#discussion_r521366412_

github-actions[bot] commented 3 years ago

Stale issue message

daminichopra commented 2 years ago

Hi @chicco785 @c0c0n3 , Please assign this issue to me if no one is working on it. Also , Shall I take reference of this comment for further fix of this issue?

Thank You.

c0c0n3 commented 2 years ago

Hi @daminichopra thanks for offering to work on this. Please read through the comments to crate/crate-python#407. I think one option we should consider is to swap out pg8000 for Psycopg in the Postgres translator. Then see if Psycopg would work with Crate too, since it looks like Crate should support the PG wire protocol quite well these days?