Category Archives: Software Development

Reblog: The Absolute Minimum Every Software Developer Absolutely, Positively Must Know About Unicode and Character Sets

No full blog post this time. I just wanted to point you towards an excellent article I read yesterday, by Joel Spolsky: The Absolute Minimum Every Software Developer Absolutely, Positively Must Know About Unicode and Character Sets (No Excuses!) The … Continue reading

Posted in Software Development | Tagged , , | Leave a comment

Simple Python script that runs SQL scripts against a given SQLite database

Many of the search hits for my blog are along the lines of “python sqlite script”. I really hope those folks find what they are looking for. I thought I might add this really simple script to run SQL script … Continue reading

Posted in Software Development | Tagged , , , , | 2 Comments

Organising custom Commands in a WPF TreeView using the Model-View-ViewModel design pattern

In my current project’s interface, the main elements of the GUI are a TabControl holding any number of workspaces, and a side panel with commands to launch the desired workspaces. It is closely based on a MVVM demo I saw, … Continue reading

Posted in Software Development | Tagged , , , , , , , , , , , | Leave a comment

A Python script that finds and runs other Python scripts (which I use to build my SQLite database)

My, what an unwieldy blog title. While working on my current project, I wanted to be able to generate and fill my SQLite database from scratch, in an instant, by calling a single script. I found a convenient way of … Continue reading

Posted in Software Development | Tagged , , , , , | 2 Comments

Python Script to Count Tables, Columns and Rows in SQLite Database

One of my colleagues asked me for some metrics regarding the size of our project’s database to put in a report, so I wrote a short little script Python to summarize the dimensions of SQLite tables. It prints a list … Continue reading

Posted in Software Development | Tagged , , , , | 1 Comment

Generating Smarter Visual Studio Code Snippets Using T4 Templates

The last formal tip in The Pragmatic Programmer urges the reader to “Sign Your Work”, and states that, at the very least, each code file should have the author’s name and the creation date as a comment at the top. … Continue reading

Posted in Software Development | Tagged , , , , , , , | Leave a comment

Replacing a delegate with an inline lambda expression: Improvements on an MS Exams Custom WPF Control example

I was dusting off my WPF skills when I took a look at the Custom WPF Control example in this book: MCTS Self-Paced Training Kit (Exam 70-511): Windows Application Development with Microsoft .NET Framework 4 The example, in Chapter 5 … Continue reading

Posted in Software Development | Tagged , , | Leave a comment