Jon Todd

I don’t really know how to say this but Windows 7 is kind of a big deal. So much so that it’s probably worth throwing a party, you know, like tupperware. In case you don’t know how to throw a party, Microsoft will tell you, take a look at this gem.

These days there’s a video to learn just about anything you want online and while there’s certainly a ton of crap out there it’s nice to see that Yale and MIT are putting up there courses on the web for free.

This beauty was recorded at MIT in 1986!

If you’ve ever found yourself trying to determine which tables have a foreign key to a given table in MySQL the following query should do the trick.

Variables:

• MY_SCHEMA – name of schema the referenced table is in
• MY_TABLE – name of the table being referenced by foreign keys

Query:

SELECT
TABLE_SCHEMA,
TABLE_NAME,
COLUMN_NAME,
REFERENCED_COLUMN_NAME
FROM
information_schema.KEY_COLUMN_USAGE
WHERE
REFERENCED_TABLE_SCHEMA = 'MY_SCHEMA'  AND
REFERENCED_TABLE_NAME = 'MY_TABLE';

So I’ve officially moved to San Francisco and started working at the [new job](http://www.structuralwealth.com). I’m living in the in a place called Marina Cove which will be home for at least the next few months while I get my bearings and a better idea of where I’d like to be long term. The marina area is nice, right by the bay, beach, presidio and a few other parks but the general crowd might a bit too fratboy for me. On the plus side I live right next to the area’s Safeway grocery store so not having a car hasn’t been a big issue and eating well is easy. Also the 30x express bus stop is two blocks away and gets me to work in under 15 min.

More to come about SF

Think I first heard these guys at Pieter’s place. I can’t stop listening to this album. It’s very electronic really dig the following songs:

1. And I Was A Boy From School
2. No Fit State
3. Over & Over

Let’s face it, you know what songs you’re listening to a lot but what if you wanted a playlist that gave this information to you so you could say blog about which songs are on your own personal top 10 list. My goal was to create a playlist which will show me that songs I listened to the most in the last week that I’ve recently added to my collection. This isn’t really possible in iTunes smart playlists since the play count doesn’t actually store the dates of each time you listen.

That said, here’s a set of rules that gets pretty close:

1. Last Played – is in the last – 7 days
2. Date Added – is in the last – 1 months
3. Rating – is greater than – (no stars)

Then to get my top X songs I just order by rating.

I’m sure I could improve on this and would be interested to hear about your creative playlist ideas.