fix: set db connection limits (#140)

1 files changed, 4 insertions, 0 deletions

diff --git a/backend/database/database.go b/backend/database/database.go
index 5a55c21..25570f7 100644
--- a/backend/database/database.go
+++ b/backend/database/database.go
@@ -4,6 +4,7 @@ import (
         "database/sql"
         "fmt"
         "os"
+        "time"
 
         _ "github.com/lib/pq"
 )
@@ -26,6 +27,9 @@ func ConnectDB() {
         if err = db.Ping(); err != nil {
                 panic(err)
         }
+        db.SetMaxOpenConns(50)
+        db.SetMaxIdleConns(2)
+        db.SetConnMaxLifetime(time.Minute * 5)
         DB = db
         fmt.Println("Successfully connected to database!")
 }