Mysql local variables
Just learned how to use variables in mysql - the variables are bound to the specific client session - and are destroyed on disconnect. SET @varname = value SELECT max(value) from table into @varname S...
gavinj.net
Thoughts on technology, infrastructure, and AI
Minolta AF 35-70/F4 Macro
macro_20070509_2 Originally uploaded by gavin.jackson. My new lens arrived yesterday (actually it's yet another old Minolta AF lens manufactured back in 1985) - it's a 35-70/F4 (constant aperture) wi...
Python file magic
File magic is used on Linux and Unix systems as a binary "fingerprint" to tell what type a file actually is - this provides a much better result than MIME or filename extensions. The "magic" pattern i...
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...
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...