Testing
Azure Cosmos DB is a globally distributed, multi-model database with unique behavior around partition keys, request units (RU/s), consistency levels, and the change feed. Testing these behaviors requires both local emulation and integration tests against the real service. This guide covers both. The Cosmos DB Emulator Microsoft provides
Database
Untested migrations are one of the highest-risk deployments in software engineering — a bad migration can corrupt production data in seconds with no undo. This post covers a systematic approach to testing forward migrations, rollback paths, data integrity invariants, and zero-downtime patterns like expand/contract, all using TestContainers so
Testing
Most Python database test suites share the same set of mistakes. Tests that mock Session.query(). Fixtures that share state between tests. Integration tests that take 20 minutes because developers tried to be too thorough. This guide identifies the most damaging anti-patterns and shows how to replace them with
Testing
asyncpg is the fastest PostgreSQL driver for Python—but testing async database code correctly requires more setup than the synchronous equivalent. This guide covers the full testing stack: spinning up real PostgreSQL via Testcontainers, managing async connection pools in tests, and isolating tests without sacrificing speed. Why asyncpg Testing Is
Android
Room is Android's recommended database library, wrapping SQLite with type-safe query builders and Kotlin coroutines support. Testing Room properly means validating DAO queries, schema migrations, and Paging 3 integration—without ever touching a real disk database. Room Testing Strategy Room provides first-class support for testing through
Database
Goose is the most widely-used database migration tool in the Go ecosystem, but its simplicity makes it easy to ship migrations without testing them. This guide covers a complete testing strategy using testcontainers-go, Go's standard testing package, up/down migration verification, and SQL assertion patterns that
Database
Alembic is the standard database migration tool for SQLAlchemy applications, but its revision system is easy to break silently. This post covers a complete pytest-based testing strategy: upgrade and downgrade testing with real databases, Testcontainers for isolated environments, SQLAlchemy fixture patterns, and idempotency verification to catch the errors that
Database
Atlas brings declarative schema management to database migrations, letting you define what your schema should look like rather than how to get there. This post covers automated schema validation with atlas schema diff, lint-driven migration safety checks, CI/CD pipeline integration, and drift detection to keep your database and
Database
Liquibase changelogs applied without testing are a production incident waiting to happen. This post covers every layer of the Liquibase testing stack: updateSQL dry-runs, Testcontainers-backed integration tests, rollback verification, and precondition testing to guard against environmental assumptions. Key Takeaways Dry-run before you apply. liquibase updateSQL generates the
Database
Supabase testing starts with supabase start for a fully local Postgres stack, pgTAP for Row Level Security policy validation, and Deno's built-in test runner for Edge Functions — all running locally without any remote API calls. Key Takeaways RLS policies are database logic — test them in the database.
Database
PlanetScale's database branching model lets you create isolated test databases from production schema in seconds. Pair that with automated schema change validation and Vitess compatibility checks, and you have a testing workflow that catches production incidents before they happen. Key Takeaways Database branches are your test environments. PlanetScale
Database
Neon's branching API makes test isolation cheap — create a branch per PR in seconds, run tests, delete it. But serverless Postgres has specific behaviors around cold starts, connection pooling, and branch state that need explicit testing coverage. Key Takeaways Branches are the unit of test isolation. Neon branches