EasyInstall - CPAN for Python?
In a nutshell, dowload EasyInstall from: http://peak.telecommunity.com/DevCenter/EasyInstall#installing-easy-install This now allows you to install python packages (called eggs). Like CPAN for PERL, i...
gavinj.net
Thoughts on technology, infrastructure, and AI
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...
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...