In Part 1 we looked at using VIEWS to keep our SQL DRY. Unfortunately, there are cases when VIEWS are either not allowed or perform terribly and can’t be optimised. Stored Procedures are, of course, the mainstay of writing DRY SQL, and optimisation. Unfortunately, you can’t treat the result set of Stored Procedure as a query; therefore you can’t join storedContinue reading “How to write DRY SQL in MySQL – Part 2: Stored Procedure Hacks”
Author Archives: Gruff Davies
How to write DRY SQL in MySQL – Part 1: Views
Writing DRY code is a fundamental principle of software development. DRY, or Don’t Repeat Yourself, was popularised by the 1999 Pragmatic Programmer coding practices book (the alternative being WET code, meaning Write Everything Twice, or possibly “We Enjoy Typing”). DRY code is optimal, not just because it’s less typing, but because when you come to refactor code (make changes to it), it’s much easier if there’s aContinue reading “How to write DRY SQL in MySQL – Part 1: Views”
How to add a WordPress Blog to a Moonfruit website
Moonfruit websites (a.k.a. Sitemaker) offer a rich set of very easy to use features for beginners. The built-in blog looks nice and is fully integrated with your site and design but it’s very limited. If you want real blogging power and you want to add WordPress to your moonfruit site, here’s how to do it. NB: I will use SitemakerContinue reading “How to add a WordPress Blog to a Moonfruit website”
Reflections 