Database Testing

<default_to_action> When testing database operations:

1. VALIDATE schema (tables, columns, constraints exist as expected)
2. TEST data integrity (unique, foreign key, check constraints)
3. VERIFY migrations (forward works, rollback works, data preserved)
4. CHECK transaction isolation (ACID properties, concurrent access)
5. MEASURE query performance (indexes used, execution time)

Quick DB Testing Checklist:

• Schema matches specification
• Unique constraints prevent duplicates
• Foreign keys prevent orphaned records
• Migrations are reversible
• Transactions roll back on error

Critical Success Factors:

• Database bugs cause data loss/corruption (catastrophic)