I've never had a problem working https://pgtap.org/ https://pgtap.org/ into CI. I know the article title says "integration tests" but when a lot of functionali

I've never had a problem working https://pgtap.org/ https://pgtap.org/ into CI. I know the article title says "integration tests" but when a lot of functionality is done inside PostgreSQL then you can cover a lot of the test pyramid with unit tests directly in the DB as well. The test database orchestration from the article pairs really well with pgTAP for isolation.