What I really wanted to say

So my post today was meant to be about something else (that’s why I set up this account). Can’t remember what it should be yet…

Not lock-free coding…

Not goating… although the Clippit thing is genius.

Maybe it was meant to be on writing unit tests for database-dependent code. What’s the best-practice way to do things? Should you rely on there being a genuine DBMS that you can mess with, and run some scripts to set up and tear down your test dataset? Or should you try to do all your tests without any database at all, relying on your SQL to be valid / tested independently (surely there must be a better way than this)? How should you set up test data for anything but in-memory datasets (file-based, Web-based, etc)? I need to look into this.

I’m not sure that the unit-testing thing was the idea for the post now. Maybe I’ll remember tomorrow.

This blog is already becoming a to-do list, hopefully I’ll be able to answer some of these questions soon!