15 — Database Integration Patterns

Core Concepts

• Connection pooling — reuse database connections (don't open/close per query)
• Repository pattern — abstract database operations behind an interface
• Transactions — group multiple operations into atomic units
• Migrations — version-controlled database schema changes
• Query builder vs raw SQL — tradeoffs in abstraction
• Prepared statements — prevent SQL injection, improve performance