Triggers in MySQL
Starting from Mysql 5.0.2, mysql now supports triggers - which can be quite handy. I'm using them to automatically create new (derived) table records when a user submits data to my web app. Syntax is...
gavinj.net
Thoughts on technology, infrastructure, and AI
Python cryptographic checksums
Python provides a pretty handy module for performin MD5 sums of both text and data buffers. The following function provides an MD5 sum given a file name: def get_hash(self, filename): """ Generates an...
pyinotify: monitor filesystem events with Python under Linux
Dan at work put me on to some new Linux Kernel functionality in the form of inotify - the userland tools and libraries allow you to hook into this pretty handy capability. It essentially allows you to...
Mysql Command of the day
I thought this one was worth blogging. To save the output of an SQL query in a file simply do this: SELECT * FROM table INTO OUTFILE "/tmp/filename.txt" Produces a tab delimited file with the outputs...
Brumbies 2007
Brumbies 2007 Originally uploaded by gavin.jackson. Photos of the last home match of 2007. We say farewell to George Gregan, Stephen Larkam and Jeremy Paul - all foundation team members of the CA Bru...