leafo / pgmoon

A pure Lua Postgres driver for use in OpenResty & more
MIT License
390 stars 93 forks source link

Connection pooling outside of OpenResty? #143

Open mecampbellsoup opened 1 year ago

mecampbellsoup commented 1 year ago

Hi @leafo - do you know if it would be possible to implement DB connection pooling in a non-OpenResty context? As you may recall, we use HAProxy (not nginx) as our API gateway and so we end up doing a fair amount of DB querying (and asynchronous listening)... would be nice to be able to have "hot" connections ready to go via something like a pool on demand for queries and the like.