In LuaSql, how to use a connection pooling?

Asked Feb 10 '16 at 20:03

Active Feb 15 '16 at 22:13

Viewed 485 times

I've been working on Lua / Torch and I've been using LuaSql to connect to a PostgreSQL database. I've reached the maximum number of connections several times, and now I would like to use some sort of connection pooling for my database management system.

I've looked for it online but I did not find anything useful. I read this webpage but it seems that the connection pooling ain't available for LuaSql.

Does anybody know if there is any connection pooling system available for LuaSql? If yes, how could I use it?

edited Jun 20 '20 at 09:12

Community

asked Feb 10 '16 at 20:03

DavideChicco.it

3,318
13
56
84

May be you do not close connection correctly. – moteus Feb 16 '16 at 12:34
I wish that was the problem... I checked them all and they all work properly – DavideChicco.it Feb 16 '16 at 16:49
Have you tried increasing the number of connections in your PostgreSQL or using a tool like Pgpool? – GabrielVa Feb 18 '16 at 17:06
I did not know about Pgpool. How could I implement it in Lua and Torch? Thanks – DavideChicco.it Feb 22 '16 at 21:30
Pgpool is middleware that sits between PostgreSQL server and a PostgreSQL database client - it allows you to reuse connections sharing the same parameters - you can download from here: http://www.pgpool.net/mediawiki/index.php/Downloads – John Wakefield Feb 26 '16 at 05:30
https://github.com/pgbouncer/pgbouncer – jq170727 Sep 07 '17 at 22:00

In LuaSql, how to use a connection pooling?

0 Answers0