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

Simple File Comparison

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

Without going into too many specifics, one of the things I do on a weekly basis is intake records from one of our vending partners, massage the data a little, and update one of our own tables based on the results. Basically, what I get from this vendor each week ...

Read More