Re: Thoughts on "Love Your Database" - Mailing list pgsql-general

From Steve Atkins
Subject Re: Thoughts on "Love Your Database"
Date
Msg-id 56CEF291-6629-4CCC-AED4-3D77107C8C08@blighty.com
Whole thread Raw
In response to Re: Thoughts on "Love Your Database"  (Guyren Howe <guyren@gmail.com>)
Responses Re: Thoughts on "Love Your Database"  (Szymon Lipiński <mabewlun@gmail.com>)
List pgsql-general
> 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



pgsql-general by date:

Previous
From: Peter Juhasz
Date:
Subject: Re: PQcancel may hang in the recv call
Next
From: Venkata Balaji N
Date:
Subject: Re: postgresql-9.5.3 compilation on Solaris SPARC