Automating SQL joins that follow foreign keys

Oct. 18, 2017 by

I’ve written a SQL code generator which automates the mindless, repetitive task of joining a table to the tables to which it has foreign keys. Generating this code isn’t exactly

Common Table Expressions in SQL are a code smell

Oct. 4, 2017 by

I’ve recently come to the conclusion that Common Table Expressions (CTE) in SQL are almost always undesirable.  CTE’s are a powerful feature.  But unless they’re recursive, CTE’s are just replacements

How to test a view in a SQL database

Sep. 27, 2017 by

I had a realisation that I’m looking forward to blogging about soon.  However, when I outlined my post I couldn’t find references for several things that I know to be

How to mock objects in databases where DDL is not transactional

Jan. 16, 2017 by

How to mock objects in Oracle / How to mock objects in MySQL The most significant difference between the major relational databases in terms of unit testing, is whether Data