PostgreSQL
Workflow
- Model entities, constraints, and relationships explicitly.
- Write parameterized queries and avoid dynamic SQL concatenation.
- Add indexes based on query patterns and validate with EXPLAIN ANALYZE.
- Keep migrations forward-only, reversible where possible, and tested on staging data.
- Monitor slow queries, connection usage, and lock contention.