Running Java Integration Tests against a PostgreSQL Embedded database
Today, I’m going to walk you through running integration tests on the JVM against a real production-like PostgreSQL database. All without losing in terms of overall testing time or performance (especially when you have a database with hundreds of tables). In-memory databases (e.g., H2, HSQLDB, SQLite, …) are very often used as drop-in replacements when running integration tests. This is generally in order to make such tests run fast, self-contained and therefore free of side effects.