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...
GPG - encryption for the masses
Some handy usage information on how to use Gnu Privacy Guard (GPG) - an open source implementation of PGP: gpg --gen-key gpg --output revoke.asc --gen-revoke toms_key gpg --list-keys gpg --output publ...
python-clamav Could it get any simpler?
If only life was this simple apt-get install python-clamav: >>> import pyclamav >>> ret=pyclamav.scanfile('/tmp/virus') >>> print ret (1, 'Worm.Sober.G') >>> ret=pyclamav.scanthis("Buffer to test bla...
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...