My Picks for PyCon 2010

Posted by: barbara | Date: Dec 09, 2009 | Category: PyCon Python

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

why you shouldn't sleep with the laptop on the bed next to you

Posted by: barbara | Date: Nov 07, 2009 | Category: November Post-A-Day


Read More

Getting Update Times On The DB Server - MySQL4

Posted by: barbara | Date: Nov 06, 2009 | Category: MySQL November Post-A-Day Python

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

Posted by: barbara | Date: Nov 05, 2009 | Category: MySQL November Post-A-Day Python

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

Posted by: barbara | Date: Nov 04, 2009 | Category: November Post-A-Day Python

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