On 20 May 2016 at 22:43, 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?
I only write tests outside the database. Currently I'm involved in projects where all the logic is outside, so having tests outside is rather obvious. However I have a small toy project with logic inside the database, and tests outside. I also think that it doesn't matter where the tests are, it is important to have them, and run them. I'm not sure that tests inside are much better solution.
regards Szymon Lipiński