Automating SQL joins that follow foreign keys
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
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
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
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
RSS - Posts