Nos78 / MrData

Discord Bot providing some simple scoring using postgres
GNU General Public License v3.0
3 stars 1 forks source link

Database is limited to 5 concurrent connections #14

Open Nos78 opened 4 years ago

Nos78 commented 4 years ago

When debugging MrData, the console is littered with warnings and failures - the database has reached its connection limit of 5.

Firstly: why is the bot needing more than 5? Since it uses asynchronous promises, it should be able to reuse the one it has, else close it.

Perhaps their are multiple forks and so each one needs a new connection.

Secondly: this connection limit is stupidly low, but it is a limit specified by our current database host, elephantsql.com - maybe we should migrate to a new host? The Bot Factory company websites have been using an Amazon AWS host for the last couple of months without hiccup - maybe we should be migrating over to here.