I’m in work on a Saturday, doing some database munging. We have a large update that requires dropping a bunch of rows, and a schema change.
I wish we had a DBA on staff for times like this. Or maybe a kick-ass local consultant whom we could bring in from time to time.
The row drops are taking forever. We don’t use triggers, but we of course have FKs and indexes. I’ll bet a savvy DBA would know some tricks to make the drops go faster. Drop indexes first? Don’t use a transaction? Inhibit table scanning? Something something something.
I know about good db behavior in our application, and measurement techniques, and know enough to know what I don’t know (that’s always most important), and a few performance tricks esp. when using Django. But table munging tricks I’m not so hot on. It’s not for lack of desire; there are only so many hours in the day.
I hoped I wouldn’t need to bring my work laptop to PyCon. Alas, it looks like I’ll need to, and do some work in the evenings. Sigh.
I’m counting the days until I get on the plane for PyCon! My company’s not paying for my attendance, and I’m using PTO for my time out of the office. OTOH, I’ll have a clear conscience if I happen to talk to a company in the exhibition hall.
On a whim, I summarily deleted every e-mail I had that was from before 2009-01-01.
It was liberating.
I recently bought a Das Keyboard Professional S for Mac keyboard, to use at work. There are already many blog posts and articles about mechanical keyboard, keyboard switches, and the Das Keyboard product line. I won’t re-hash all that here. Let’s get right to my opinions.
I give it an A-. I’m very happy I bought it.
I was halfway done with a wonderful blog post, when I ran into a company-confidentiality wall. I hate when that happens.
My spouse traveled to Canada for a few days. She just went a few miles over the border into Vancouver, BC.
She neglected to add an international data plan to her mobile number before she left. Because of this, she racked up $300 of data charges in 24 hours.
Every wireless carrier has at least one, and you have to add it to your account before you travel outside the country, and then delete it when you return home. But, why? My carrier knows when I’m out of the country! In fact, multiple systems between my cellphone and my account know it!