For which of the following scenarios would an in-memory database (like SQLite in-memory) be the MOST appropriate choice for integration testing?
Node.js interview question for Advanced practice.
Answer
Running fast feedback tests for a service's basic CRUD (Create, Read, Update, Delete) logic.
Explanation
In-memory databases excel at speed and simplicity. They are perfect for testing the application's core logic for simple data operations (CRUD) where the specific features of the production database are not important. For scenarios involving database-specific features (A, D) or critical operations like migrations (B), using a real test instance of the production database is necessary to ensure correctness.