2010 Music

Another year of good music.. but not many shows. Looking back at 2009 posts I see that the one show I thought I saw in 2010 was actually 2009. Did see a great Waco Bros/Eleventh Dream Day show at the Hideout in the winter. And I see there’s an actual new Eleventh Dream Day album out in 2011 so more shows for sure. And a solo Ted Leo show in February is something to look forward to. Seeing Amy and Wreckless led to seeing Holly Golightly in the spring. Amy and Eric were great (of course) and the new album good as well.

Some stuff in 2010 I liked a lot:

Nothing in 2010?

Suprised I didn’t post anything aside from music of 2009 in 2010. Tumblr, Twitter, Foursquare… guess that’s why.. but going to at least do a music post this year.

2009 Music

I was going to post a list of bands and tracks that I listened to from year that I wanted to note. But to my suprise much of what I’ve been listening to this year has actually been from 2008. Perhaps it was all the traveling in 2008-2009 but a lot more tunes than I would have expected were 2008 ones. So I could do a whole decade retrospective but that’s going to take a whole different frame of mind. Where I was in 2000 versus 2010.. well, a lot of things have changed. That’s for sure.

I only make it out to 3 shows this year. I think the least amount since the mid 80s. Given that the kids are older now that shouldn’t be the case (a resolution for 2010). For documentations sake: Eleventh Dream Day/Mekons @ hideout (great but i could just be nostalgia), Art Brut @ schubas (great, awesome), Waco Brothers @ schubas (good).

But somehow I thought it was a great year for music. I don’t have actual reasons to feel this way (fewer concerts, fewer 2009 tracks) but I did..

So some good things.. (some 2009 others just things I enjoyed in 2009):

That’s pretty much a dump of my 2009 mp3 lists from my blackberry.. should figure out a way to post those automatically; could be fun to read in 2020.. Happy 2010 in music.

New Blogs

Two people I know well have just started blogging and I thought I’d link to them…

Maps N Cars is just what you’d expect from the name and from the 9 year old who writes it. Lots of pictures of cars and some of maps.

ReadNStuff is a little newer and will be at a minimum documenting the books (and books and more books) that are read. Other stuff for sure.

It’s interesting to see how quickly they (9 and 10) pick up the mechanics of using wordpress. Didn’t explain linking but someone commented that the car pictures would be good as links. So showed that button and now it’s second nature.

Location Services

I’ve been using Latitude on Google Maps my BlackBerry and love the idea of making this location information more available. FireEagle is a service from Yahoo that makes this location info available to other applications. That’s perfect but need a way to get it updated automatically..

MoosTrax, that’s the application (runs as a service on my BlackBerry Bold) and updates MoosTrax (maps of location, etc) and also updates FireEagle. So today as I moved around town FireEagle was up to date and now MoosTrax shows my travels.

So my location can be made available (using OAuth of course) to any app that I authorize. And I’ll authorize MyPalIMBot (once I write that code) and then TEMP and ADDress will take into account my real location.

If I add a twitter post function then it can geotag the tweets.

I saw something last week that 2010 would be the year of location. Perhaps that’s true.. It will be for me.

Google Voice

Playing with google voice and so just trying a little call widget. Give me a ring…


Widget above

Joins really are faster

Came across a sweet way to split a delimited string into a table (so I could build a list of words for a keyword clound). The source was given as Joe Celko and that prompted me to reread his SQL Programming Style book. He’s got a real firm conviction about how things should be. Good thing to aim for at least.

So I thought I’d take a quick look at some quick SQL I had to add entries to a table that were new. It’s not a very well thoughtout table (or system for that matter) and I’d been living with the 15 second runtime. Inspired by the book though, I took a closer look.

Going from a where not in (select.... ) to a left outer join on the 3 columns and testing for NULL took the runtime to 0. Just runs instantly.
Old Version

SELECT
GETDATE() AS cDate, GETDATE() AS mDate,
sn_client AS sn_client, ServiceID AS ServiceID
, relationship, MIN(cDate) AS sDate, NULL AS eDate
FROM sn_ConnectionsRaw
WHERE sn_Client + serviceID + relationship
NOT IN (
SELECT sn_Client + serviceID + relationship
FROM sn_Connections)
GROUP BY sn_client , ServiceID, relationship

New version:

SELECT
GETDATE() AS cDate, GETDATE() AS mDate,
sn_client AS sn_client, ServiceID AS ServiceID
, relationship, MIN(cDate) AS sDate, NULL AS eDate
FROM sn_ConnectionsRaw
LEFT OUTER JOIN sn_connections
ON sn_Connections.sn_Client = sn_ConnectionsRaw.sn_Client
AND sn_Connections.ServiceID = sn_ConnectionsRaw.ServiceID
AND sn_connections.Relationship = sn_ConnectionsRaw.Relationship
WHERE sn_Connections.sn_Client IS NULL
GROUPY BY sn_ConnectionsRaw.sn_Client , sn_ConnectionsRaw.ServiceID, sn_ConnectionsRaw.Relationship

WFMU

The annual pledge marathon ends tomorrow on WFMU. They are aiming for 1.2 million dollars.. pretty ambitious but they are getting pretty close to 1 million.

A great station.. first listened to it searching for more Ted Leo music and came across Terre T’s Cherry Blossom Clinic. She’s had Ted live as well as Wreckless Eric and Amy Rigby; plays M.O.T.O as well as The Raspberries.

I could go on about my favorite DJs but generally anyone is worth listening to for 15 minutes at least and you can listen to most of their past shows so you can become a fan easily.

The site is a great example of what a radio site should be. Archives, playlists, comments.. it’s all there. Realtime listening is in nearly any format you could desire. The flash player displays the current and next track. I’m listening to the ACC stream at this very moment.

So you should listen and pledge as well.

WFMU – 91.1 .. “the freeform station of the nation”.. “the fun 91″


WFMU
How This Works…
Support Freeform Radio!
Your Name
Your Email
Your Pledge $
Add this banner to your site!

Erlang history

Having just started running ejabberd (a XMMP/Jabber server; using it to support some laconica microblogging sites) I paid extra attention to a bunch of articles about Erlang (the programming language that ejabberd is written in). One in particular was a well written history of the development of the language by Joe Armstrong.

http://www.cs.chalmers.se/Cs/Grundutb/Kurser/ppxt/HT2007/general/languages/armstrong-erlang_history.pdf

Oddly enough someone had just asked about functional languages at work and I spent a day messing with some XSLT stuff which is a ‘nearly’ functional language.. Guess there’s something in the air.

This article reminded me of old Dr. Dobbs issues. Not too far beyond my level of knowledge but clearly beyond. Good to read something that’s a stretch. Too bad Dr. Dobbs didn’t make it.

Coffee!

A great article about coffee and the new Starbucks instant and the increased prices from some local roasters. And great comments from the people (real people) at Intelligentsia. Well considered comments from real people are a powerful thing.

Follow

Get every new post delivered to your Inbox.