Blog Upgrade Time Again

Well, in the space of a few months, I’ve outgrown the previous Drupal version I was using for Blogs, which was a replacement of an earlier Blog implementation. The primary reason was better date based indexing, either by months, or calendar functions. I was told that a calendar function was available but was unable to locate (at least easily).

Anyway, I’m now using WordPress. It provides the added strength of Archives (which is in months), and one other great thing – Categories. Given I’ve been writing across a few different technologies and interests it’s great to be able to seperate these out, and then even submit this appropiately via RSS to some blog aggregetors.

I’ve moved all my articles, but I’ve lost the dates of older stuff from my first move. The old blog is still available at http://techstuff.arabx.com.au

Tagged with: General

Producing Chi-Squared statistics with SQL

The Chi-Squared test is one of the most widely used statistical tests for categorical data. It comes in two flavors: the goodness-of-fit test asks whether an observed frequency distribution matches an expected one, while the test of independence asks whether two categorical variables are associated with each other.

Speaking at COSCUP 2026 — Planning your upgrade to MySQL 9.7

I am excited to be speaking at COSCUP 2026 in Taipei, Taiwan on August 8th and 9th. COSCUP (Conference for Open Source Coders, Users and Promoters) is one of the largest open source conferences in Asia, and it is always a privilege to present to the engaged and technically sharp community there.

Producing Two Sample T-Test statistics with SQL

The two sample t-test for equal variance is a statistical test to determine if the means of two groups are different enough that the difference is likely caused by some underlying difference, rather than random chance.