Index: db.py
===================================================================
--- db.py	(revision 527c0976508c7d2fad14e9180bcf1a211d5f18af)
+++ db.py	(revision 95cf703d2ef8f7abf8a3684935be560cdf73467f)
@@ -1,6 +1,4 @@
 import datetime
 import psycopg2
-from psycopg2 import pool
-from contextlib import contextmanager
 
 DB_CONFIG = {
@@ -13,60 +11,7 @@
 }
 
-# -- Connection Pool ----------------------------------------------------------
-# Reuses database connections instead of opening a new one per query.
-# SimpleConnectionPool maintains between minconn and maxconn connections.
 
-_pool = None
-
-
-def _get_pool():
-    global _pool
-    if _pool is None:
-        _pool = pool.SimpleConnectionPool(minconn=2, maxconn=10, **DB_CONFIG)
-    return _pool
-
-
-@contextmanager
 def get_connection():
-    """Get a read-only connection from the pool.
-    Autocommit is enabled so SELECTs don't need explicit commit.
-    Connection is returned to the pool on exit."""
-    p = _get_pool()
-    conn = p.getconn()
-    try:
-        conn.autocommit = True
-        yield conn
-    finally:
-        conn.autocommit = False
-        p.putconn(conn)
-
-
-@contextmanager
-def get_transaction():
-    """Get a connection with explicit transaction management.
-    Commits on successful exit, rolls back on exception.
-    Connection is returned to the pool in both cases."""
-    p = _get_pool()
-    conn = p.getconn()
-    try:
-        conn.autocommit = False
-        yield conn
-        conn.commit()
-    except Exception:
-        conn.rollback()
-        raise
-    finally:
-        p.putconn(conn)
-
-
-def close_pool():
-    """Close all connections in the pool."""
-    global _pool
-    if _pool is not None:
-        _pool.closeall()
-        _pool = None
-
-
-# -- UI Helpers ---------------------------------------------------------------
+    return psycopg2.connect(**DB_CONFIG)