#4773  by phpbb
 Fri Apr 07, 2006 10:18 pm
If you don't want to read the technocrap:

try out this setlist finder:


autocomplete for venue and city name
search by month, day, or year


If you haven't noticed, I finally built a database of dead shows. I always wanted one, and now I have one. The main reason that it came together now is that I have been using a new language, Ruby, and specifically Ruby on Rails, and the setlists database fit very nicely with rails.

The first output was the "view tabs by setlist", but now I am putting out the actual ruby on rails front end. This stuff is what is called "web 2.0", using AJAX and nifty rounded corners. I've used Firefox 1.5, IE 6.0 and Opera 8.52 and things worked.

This particular app lets you search by month or day of month or year or Venue name or city name or state or any combination of the above.

This means that you can find all shows that were played in January, or all shows played on the 5th of the month, etc..

The nifty "web 2.0" stuff is the autocomplete for venues and cities. Just start typing the name of a venue, and the app will give you a list of suggestions (how fast I really don't know). The same works for Cities too.

Have fun...
Last edited by phpbb on Fri Apr 07, 2006 11:03 pm, edited 1 time in total.

 #4775  by jck_strw
 Fri Apr 07, 2006 10:44 pm
dude that's totally slick! Fucking alright.

 #7719  by phpbb
 Wed Aug 02, 2006 9:20 pm
I rewrote the set list program I created a while back from ruby to php. The new site is finally back up and can be found here:


or the original url will redirect you...


PS - for any techies out there, instead of using ruby on rails, its now written in the php version known as Cakephp. They are very similar. Ruby has better documentation, but, both are pretty intuitive when you get used to it.

 #7721  by ebick
 Wed Aug 02, 2006 11:28 pm
found a couple of bugs, dude.

I searched

Venue: Veterans Memorial Coliseum
City: New Haven
State: CT

and it pulls up 3/14/81, which is a Hartford show. The rest are right.

Then I did just CT and it appeared to pull every show.

But I like the look and feel.

 #7727  by phpbb
 Thu Aug 03, 2006 8:41 am
fixed and fixed