1 files changed, 6 insertions, 0 deletions

diff --git a/internal/storage/storage.go b/internal/storage/storage.go
index d00d7bf..9ef9956 100644
--- a/internal/storage/storage.go
+++ b/internal/storage/storage.go
@@ -22,6 +22,12 @@ func New(dbPath string) (*Storage, error) {
                 return nil, fmt.Errorf("failed to open database: %w", err)
         }
 
+        // Configure connection pool for SQLite
+        // SQLite works best with a single connection due to single-writer lock
+        db.SetMaxOpenConns(1)    // Single connection (SQLite is single-writer)
+        db.SetMaxIdleConns(1)    // Keep connection alive
+        db.SetConnMaxLifetime(0) // Never close the connection
+
         // Configure SQLite for optimal performance
         pragmas := []string{
                 "PRAGMA journal_mode=WAL",              // Write-Ahead Logging for concurrency