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...
gavinj.net
Thoughts on technology, infrastructure, and AI
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...
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...