Course contentsShow
← Software Engineering
Lesson 531 of 1,93316. Integration TestingFree lesson

Setting Up Test Databases

Creating isolated database instances for testing, including in-memory databases and containerized test databases.

Setting Up Test Databases

What you'll learn: How to create isolated database instances specifically for testing, so your tests don't interfere with real data or each other.

Why Test Databases Matter

When your integration tests verify code that reads or writes to a database, you face a dilemma: you can't use your production database (too risky!), and sharing a single test database between tests violates test independence. The solution is creating isolated database instances that exist solely for testing.

Think of it like a chemistry lab: you wouldn't mix chemicals directly in the supply containers. Instead, you pour samples into clean beakers for each experiment, keeping the originals safe and each experiment independent.

Two Common Approaches

In-Memory Databases

These databases run entirely in RAM, making them extremely fast. Libraries like SQLite's in-memory mode or H2 create a fresh database each test run:

// Example pseudocode concept
testDatabase = createInMemoryDatabase()
// Fast, isolated, disappears after test

Trade-off: Lightning-fast but may not perfectly match your production database's behavior.

Containerized Test Databases

Tools like Docker spin up real database instances (PostgreSQL, MySQL, etc.) in isolated containers. Each test suite—or even each test—can get its own container:

// Example pseudocode concept
testContainer = startDatabaseContainer("postgres:14")
testDatabase = testContainer.getConnection()
// Real database behavior, fully isolated

Trade-off: Slower to start but provides production-like behavior.

Which to Choose?

  • In-memory: Perfect for fast feedback when testing basic SQL operations
  • Containerized: Essential when you need production database features (triggers, stored procedures, specific SQL dialects)

Both approaches share the same goal: giving each test run a clean, isolated database state.

Key Takeaway: Test databases provide isolation and safety—use in-memory databases for speed or containerized databases for production-like accuracy, ensuring your tests never touch real data.