My Picks for PyCon 2010
Following the lead of Catherine Devlin, Jesse Noller, and other Python bloggers, I've finally had a chance to comb through the list of talks for PyCon 2010 and come up with a few picks of my own. It goes without saying that I'll probably change my mind ...
Read More
Getting Update Times On The DB Server - MySQL4
Here's the MySQL4 version of the script I posted yesterday. On the MySQL4 server, we don't have that handy INFORMATION_SCHEMA db for reference - instead, we have to get table information using SHOW TABLE STATUS
. The biggest difference between the two scripts is that this one requires a ...
Read More
Getting Update Times On The DB Server - MySQL5
Here's another utility script that I use to check on replication to one of our slave db servers. This probably bears some explanation - a few months ago, replication stopped for no apparent reason (at least no reason that was apparent to the developers - our SA either didn't know ...
Read More
File Comparison With Some DB Bells and Whistles
Right. So yesterday's post was mind-numbingly simple. But that's the just the file comparison. The script that I actually use also hits the db and generates a slew of additional updates for me, based on the results of that diff.
#!/usr/bin/python # usage: ./compare.py pwdata102409.txt pwdata103109.txt used_codes_wk6 ...
Read More
