10at10 Club

Main Discussion Area => Stream of Consciousness => Topic started by: mshray on September 26, 2009, 09:07:46 AM

Title: the Paging Darryl thread
Post by: mshray on September 26, 2009, 09:07:46 AM: I checked with Darryl offline & he agreed this is a good idea, so here it is.

He even said that one of these days he might get around to putting web front page on a MySQL Db so that anyone could do their own searches.
Title: Re: the Paging Darryl thread
Post by: ggould on September 26, 2009, 10:47:57 PM: Quote from: mshray on September 26, 2009, 09:07:46 AM
I checked with Darryl offline & he agreed this is a good idea, so here it is.

He even said that one of these days he might get around to putting web front page on a MySQL Db so that anyone could do their own searches.

Yeah, we should get together on this site. Maybe if Darry's interested, we can put them here, using the MySQL stuff I don't understand!
Title: Re: the Paging Darryl thread
Post by: darryl on September 28, 2009, 01:00:01 AM: Ah, so I guess I should subscribe to this thread then, I guess. :-}
Title: Re: the Paging Darryl thread
Post by: urth on November 07, 2009, 01:18:42 AM: After today's set, I noticed that we hadn't heard 21 Guns for a couple of days post-set. Later on I checked back thru the previous 24 hours on the "just played" engine, and did not see it listed at all during that time. (Granted, there had been about a 3-hour lapse in data from around 3pm to 6pm, so it could well have been played there.) However, that's still a significant drop in the rotation from what we'd been hearing, even last week. Could you check your data scraper and see if this is in fact the case, or if I'm deluding myself?
Title: Re: the Paging Darryl thread
Post by: darryl on November 22, 2009, 11:43:26 PM: Whoops! Missed this. Sorry about that. Hey -- I have a new DIY system. It's ugly as sin and not optimized at all. I need to add date/time ranges too. Also a checkbox to "use same search for both". Feh, JavaScript. And CSS. And MySQL indices. And fancy looking pages. :-P
Title: Re: the Paging Darryl thread
Post by: darryl on November 22, 2009, 11:44:11 PM: Whoops. Link would help: http://www.rudebadmood.com/foglist/
Title: Re: the Paging Darryl thread
Post by: Gazoo on November 23, 2009, 10:57:04 AM: Quote from: darryl on November 22, 2009, 11:44:11 PM
Whoops. Link would help: http://www.rudebadmood.com/foglist/

Fascinating!

Date/Time Artist Song Album 2009-11-02 03:18:01 Jefferson Starship RIDE THE TIGER Dragon Fly [Remaster] 2009-09-26 02:21:01 Jefferson Starship RIDE THE TIGER Dragon Fly [Remaster] 2009-08-06 03:18:02 Jefferson Starship RIDE THE TIGER Dragon Fly [Remaster] 2009-07-05 17:09:02 Jefferson Starship RIDE THE TIGER Dragon Fly [Remaster] 2009-01-31 14:12:01 Jefferson Starship RIDE THE TIGER Dragon Fly [Remaster] 2008-04-21 10:51:00 Jefferson Starship RIDE THE TIGER Dragon Fly [Remaster] 2008-01-21 20:51:01 JEFFERSON STARSHIP MIRACLES Red Octopus 2007-11-28 15:39:00 Jefferson Starship RIDE THE TIGER Dragon Fly [Remaster] 2007-03-28 15:24:00 JEFFERSON STARSHIP MIRACLES Red Octopus 2006-09-27 19:27:00 Jefferson Starship RIDE THE TIGER Dragon Fly [Remaster] 2006-01-28 14:42:00 Jefferson Starship RIDE THE TIGER Dragon Fly [Remaster] 2005-11-12 06:24:00 Jefferson Starship RIDE THE TIGER Dragon Fly [Remaster] 2005-07-29 19:24:00 JEFFERSON STARSHIP MIRACLES Red Octopus 2005-07-29 13:39:00 JEFFERSON STARSHIP MIRACLES Red Octopus 2005-05-20 09:03:00 Jefferson Starship RIDE THE TIGER Dragon Fly [Remaster] 2005-04-16 06:24:00 JEFFERSON STARSHIP MIRACLES Red Octopus 2005-02-22 18:24:01 Jefferson Starship RIDE THE TIGER Dragon Fly [Remaster] 2005-01-09 12:18:01 JEFFERSON STARSHIP MIRACLES Red Octopus 2004-12-12 14:30:01 Jefferson Starship RIDE THE TIGER Dragon Fly [Remaster]
Title: Re: the Paging Darryl thread
Post by: darryl on November 23, 2009, 03:39:43 PM: Faster link if you're only trying to search (not see last 200 played): http://rudebadmood.com/foglist/search.php
Title: Re: the Paging Darryl thread
Post by: darryl on November 23, 2009, 10:54:50 PM: Hey, does somebody here work at the SF Chron? So says one of the IP addresses that hit my site. Which is fine and all, just me being nosey.
Title: Re: the Paging Darryl thread
Post by: Tinka Cat on November 24, 2009, 07:46:40 AM: Quote from: darryl on November 23, 2009, 10:54:50 PM
Hey, does somebody here work at the SF Chron? So says one of the IP addresses that hit my site. Which is fine and all, just me being nosey.

i do ... but my activity was work related... :)
Title: Re: the Paging Darryl thread
Post by: darryl on November 25, 2009, 09:26:12 AM: Quote from: Tinka_Cat on November 24, 2009, 07:46:40 AM
Quote from: darryl on November 23, 2009, 10:54:50 PM
Hey, does somebody here work at the SF Chron? So says one of the IP addresses that hit my site. Which is fine and all, just me being nosey.

i do ... but my activity was work related... :)

Of course. :-}

Oh, btw, I'd like to add paging to get beyond 200 results. Now that I found the STARTROW parameter for MySQL's WHERE clause, this should be easy.

ALSO, if anybody wants direct MySQL read access (it can talk to Microsoft Excel via ODBC, for instance), I would *LOVE* to see the data get used more creatively (frequency charts, trends over time, etc.) Just PM me if you want the access.