Compared to just spinning up a DB in a container, I find the amount of setup/scaffolding required to mock the DB to be far greater. For years I took the mockin

Compared to just spinning up a DB in a container, I find the amount of setup/scaffolding required to mock the DB to be far greater. For years I took the mocking route, but it means there is a whole class of bugs that your tests won't catch, and the scaffolding was often fragile. Few years back I switched to just running a real DB in a container - very happy with this way.