Search Postgresql Archives

Re: Thoughts on "Love Your Database"

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 





On 21 May 2016 at 00:08, Steve Atkins <steve@xxxxxxxxxxx> wrote:

> On May 20, 2016, at 1:43 PM, Guyren Howe <guyren@xxxxxxxxx> wrote:
>
> On May 20, 2016, at 13:38 , Pierre Chevalier Géologue <pierrechevaliergeol@xxxxxxx> 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


Yea, pgtap is an interesting solution which I used. Or tried to use. Using it was quite painful, and I gave up. Now I test the database things outside the database. Maybe there is something wrong with me, but for me it looks like me and pgtap really don't like each other.

But of course all people should check on their own. 


--
    regards Szymon Lipiński

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux