Database Operations

Golden Rule

Data goes in the database. No random CSVs/JSON outside data/ directory.

• JSON/CSV = raw, unclean, not for production
• PostgreSQL = production data storage

DBManager Interface

from db_manager import DBManager, default_db

# Use default connection
df = default_db.fetch_df("SELECT * FROM unified_games WHERE sport = 'nba'")

# Or create custom connection
db = DBManager(connection_string="postgresql://user:pass@host:5432/db")