From c4d93c99a1692f4eec066e9797b076e7d980973d Mon Sep 17 00:00:00 2001
From: Arda Serdar Pektezol <1669855+pektezol@users.noreply.github.com>
Date: Fri, 15 Dec 2023 11:24:07 +0300
Subject: fix: set db connection limits (#140)

---
 backend/database/database.go | 4 ++++
 1 file changed, 4 insertions(+)

(limited to 'backend/database')

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!")
 }
-- 
cgit v1.2.3