Competencies: Databases > ORMs & Access Patterns
ORMs & Access Patterns
Body of Knowledge
| Topic | Description | Relevance | Career Tracks |
|---|---|---|---|
SQLAlchemy |
Core vs ORM, session management, relationships, migrations with Alembic |
High |
Backend Developer, Data Engineer |
Repository Pattern |
Data access abstraction, unit of work, query objects |
High |
Backend Developer, Software Architect |
Active Record Pattern |
Entity-centric ORM, CRUD operations, Django ORM, Rails Active Record |
Medium |
Backend Developer, Full-Stack Developer |
Query Builders |
Fluent interfaces, composable queries, type-safe query construction |
High |
Backend Developer |
Connection Pooling |
Pool configuration, connection lifecycle, connection health checks |
High |
Backend Developer, DBA |
N+1 Query Problem |
Detection, eager loading, lazy loading, query optimization strategies |
High |
Backend Developer |
Database Transactions |
Transaction scopes, nested transactions, savepoints, rollback handling |
High |
Backend Developer |
Read Replicas |
Read/write splitting, replica lag handling, failover strategies |
High |
Backend Developer, DBA, SRE |
Caching Strategies |
Query caching, object caching, cache invalidation, write-through/write-behind |
High |
Backend Developer, SRE |
Raw SQL vs ORM |
When to use raw SQL, performance trade-offs, maintainability considerations |
High |
Backend Developer, Software Architect |
Personal Status
| Topic | Level | Evidence | Active Projects | Gaps |
|---|---|---|---|---|
To be populated |
— |
— |
— |
— |