it's a mystery

mysql> delete from ingredients where id IN( 4517, 4536, 4534, 4531);
ERROR 1217 (23000): Cannot delete or update a parent row: a foreign key constraint fails

And which foreign key constraint might that be?

Office Hours

I've been getting hassled a lot at work via IM. It's important for me to be available to talk to other people that I work with, but the context shifts are killing me when I'm constantly being interrupted. So-- I've implemented "office hours" and am enforcing it by going invisible in Adium, my IM client.

First I wrote a couple of simple shell scripts:

$ cat
/usr/local/bin/growlnotify -a -m "Adium is going invisible"
/usr/bin/osascript -e 'tell application "Adium" to go invisible'

$ cat
/usr/local/bin/growlnotify -a -m "No longer invisible"
/usr/bin/osascript -e 'tell application "Adium" to go online'

growlnotify is part of Growl, a notification system for OS x. Read more in the documentation

Then I call them via cron:

$ crontab -l
# be available from 3:00pm-4:00pm
00 15 * * * bash /Users/jaybuff/bin/
00 16 * * * bash /Users/jaybuff/bin/

# be available from 6:30pm - 11:30am
30 18 * * * bash /Users/jaybuff/bin/
30 11 * * * bash /Users/jaybuff/bin/

Birthday present for myself

I just purchased a Dell 30" monitor, the 3007WFP.

I payed $888 shipped (after a $200 rebate that I'll get in 60 days). It will also function as an HDTV. My MacBook Pro can run it at its full resolution, 2560 x 1600. Not bad!

iPhone app request: remind me when I'm near

Dear iPhone App Developers,

I would like an app that allows me to say things like:

"remind me the next time I'm near a walgreens to buy soap"
"remind me when I get to work to take my bike off the shuttle"

The interface would look like google maps. I draw a circle. When my phone notices I'm inside that circle it pops up a reminder.

I'm tired of getting home after just walking by a walgreens to realize I don't have soap. And I'm tired of forgetting my bike on the shuttle and having to chase it down three blocks to get it back.


Who's Gunna Be VP

Everyone else is speculating who Obama is going to pick for his running mate.

My short list, in order of likelihood:

* Jim Webb - Senator from Virginia. Former Marine (Vietnam Vet). Former Republican. Reagan's Secretary of the Navy.
* Sam Nunn - former Senator from Georgia. He was the Chairman of the Senate Armed Services Committee.
* Wesley Clark - Retired Four Star General. Ran for President in 2004.

Bikram Yoga

Figure 1: Hippies

Bikram Yoga is hard. Lauran has been raving about it for sometime now. Last night I agreed to go with her to Funky Door Yoga in Cole Valley.

The room is 105 degrees F and 40% humidity. The class lasts 90 minutes. We went through 26 different poses and two breathing exercises. The last ten minutes I started to get tunnel vision and had to lay down. I was zapped.

The instructor was really good. She knew I was new and kept giving me advice on the hard stuff. She kept calling me "James" though. Apparently I mumble my own name.

I wasn't aware it was possible to sweat that much. After a cold shower I felt 10,000 times better.

Afterwards Lauran and I went to some sushi place in Cole Valley. I haven't explored that neighboorhood much. It's actually really cool. I would like to live there, but Noe is really nice, too.

It's only $29 a month and you can pay as you go. Since one class is $16 I signed up for a full month. I'm actually looking forward to going back next week.

Apparently Daylight Saving Kicked In

Me: Whoa, it's bright out.
co-worker: yeah, daylight savings time.
Me: Oh yeah, when is that?
co-worker: it was this past Sunday
Me: get out of here
My phone is my primary clock and my laptop secondary. They corrected themselves and didn't mention it to me. For the past three days I've been trying to figure out why I've been feeling so sluggish. I guess that explains it.