Re: Thoughts on "Love Your Database"

> On May 20, 2016, at 1:43 PM, Guyren Howe <guyren@gmail.com> wrote:
> 
> On May 20, 2016, at 13:38 , Pierre Chevalier Géologue <pierrechevaliergeol@free.fr> wrote:
>> 
>> Le 04/05/2016 18:29, Szymon Lipiński a écrit :
>>> On the other hand, when I was trying to store all my logic in a
>>> database, there was just one thing that made me hate it. Testing.
>>> Testing the procedures inside the database was not easy, not funny, and
>>> too much time consuming.
>> 
>> Yes, very good point.
> 
> Are there any best practices or tricks to make this easier?

In-database unit tests help. pgTap is a decent framework
for building that sort of test-suite in a way that'll play nice with
reporting and CI tools.

http://pgtap.org

Cheers,
  Steve