How to bulk edit a WordPress site with Excel

Editing a WordPress site can be a pain if you need to make many changes across many pages. But suppose you could view and edit the entire contents of you site inside Excel. No more navigation, searching and waiting for pages to load. In this article/video, I show you how to do this for your website.

Fast prototyping with C# and Excel

Excel doesn’t have much of a reputation as a developer tool. But imagine if instead of VBA you could use C#. Would this change things? I guess it depends. Admittedly, I’m a bit biased (since I wrote QueryStorm), but I find the combination of C# and a spreadsheet really useful. It lets me quickly build … Continued

Querying other databases from SQLite

SQLite is a remarkable little database engine. Although it serves a different purpose, it can do much of what the big client-server databases can do. It’s fast, reliable, extremely well tested and feature rich. However, if you need a function that SQLite does not offer, defining one for yourself can be tricky. Not so in … Continued