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
Simple File Comparison
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
The November Blog-A-Thon
Clearly, I'm already a day behind on the whole "blog every day in November" thing. But since I haven't actually posted in ... almost a year (not since the last PyCon, in fact), I still consider this a step in the right direction.
The thing is, to blog about ...
Read More
