Monthly Archives: November 2017

Stored Procedures for every DB access

Some applications use a stored procedure for every database access. Strange, isn’t it?

Nevertheless, sometimes it’s the right thing to do. Continue reading

Advertisements
Posted in programming | Tagged , | Leave a comment

Generating SQL with SQL

How do you write SQL commands? Sometimes I use SQL queries for that. Continue reading

Posted in programming | Tagged , | 5 Comments

Defensively? Optmistically?

Do we really want a self-driving car to show us an error console when it cannot identify an object on the Motorway? Do you want to send out a financial report when most of its records are incorrect? Continue reading

Posted in programming | Tagged , , , | 2 Comments

How to debug with triggers?

In java we got AspectJ to intercept our methods. In SQL we got triggers. A great tool for debugging. Continue reading

Posted in programming | Tagged , , , | 1 Comment