Overcoming First Principles  A guide for accessing the features of PostgreSQL in test driven develop
Channel: Postgres Conference
Date: 21/07/2016

Effective unit testing requires a software designer to define a set of abstractions which will comprise a particular system. If unit tests become brittle obstacles to refactoring or ineffective in providing design insight, then the approach we use for testing must be revised.

In this talk we will explore methods of treating PostgreSQL as a runtime component of your application and not as an external service. The end goal will be to learn to write tests that neatly capture units of functionality which depend on an SQL engine.

http://www.pgconf.us/2016/event/126/overcoming-first-principles-a-guide-for-accessing-the-features-of-postgresql-in-test-driven-development/