« first day (187 days earlier)      last day (4827 days later) » 

12:01 AM
@drachenstern Your problem sounds similar to one I solved with a CTE once.
 
:awaits Groupon commercials:
 
would I need to parse it three times then? once to match existing "current" and migrate them to the historical, once to match all the intermediary pairs, and once for the insert into current from the end? that's what I think I'm gonna have to do here
I swear I could write it faster in C#, but I have my reasons for wanting to keep it in the DB
@mootinator also, can you come up with a better title?
 
hmm :/
 
google is bloody handy
> superbowl score
 
Oh damn
 
12:09 AM
 
oh hell no
that's pretty sharp
 
does it really worth to watch superbowl? never can get the panic around such events
 
I never figured I would use search as a dashboard by itself ...
@zerkms not really. as we were saying earlier we watch to see the commercials on account of the companies spend so much money on them
 
:-S
@drachenstern: you've changed your gravatar
 
Something like 2 million USD to be on television for 30 seconds a single time
 
12:11 AM
I have, some time ago
@DanGrossman that's too damned much
not disagreeing with your numbers, just the mechanics of that situation
 
I wonder what Chevrolet and Coca-Cola are paying to own the 'superbowl' searches on Google/Bing right now
 
and twitter is going mad in #superbowl hashtag
 
google I'm getting NFL and volkswagen
 
oh, they even add a ball pic right after the hashtag :-S
 
And I'm going to end up dead last. again
Oh well
 
12:15 AM
@TheRenamedException the way I figure it for everyone two person race that has a winner, they have a loser as well
unless there's a tie of course :\
ok, I liked the bridgestone one
 
lolwtf
 
GoDaddy could've done a LOT better than her :\
 
thats the joke
 
let's melt their servers ;)
 
Look at all those returns flocking back to Staples.
 
12:19 AM
@TimStone I missed a joke somewhere
 
It's OK, it wasn't really funny.
 
was it a commercial?
or just a reference?
commercials I can look up online
ok, dogwalking, bbl
 
Ah, yeah, there was just a Staples commercial.
 
@drachenstern there were 4 contenders including me :-p
I intentionally started taking more risks at the end, that strategy clearly doesn't work
especially when there's tequila shots involved for going in the rough, LOL
ok, time to let my friends all make fun of me ;-)
catch you guys later!
 
I don't know what happened but I now want to purchase a XOOM tablet
 
12:30 AM
What the heck? The HD feed just switched over to the regular feed.
 
I am curious to see if they do a good job with that movie, and I'm curious when they're gonna mix Hulk and that universe
 
Way more people watching TV at once than normal = your node got saturated = either downgrade quality or start turning some people's TVs off
 
It came back (:
 
but it's casted content isn't it?
 
I pay for it, I better get it!
 
12:33 AM
lol
 
They'll refund (10 minutes / 44640 minutes) or 0.02% of your bill for not providing HD service. If you ask nicely.
 
12:50 AM
Tommy Lee Jones?
I guess that's like casting Jeff Bridges
 
"Official motor oil sponsor of the NFL", because a bunch of men running around and throwing a ball on a field, who don't drive themselves to or from the game, are in great need of MOTOR OIL.
(Video unrelated)
 
heh
Is the main feed screwed up on ya'lls broadcasts or just my local?
only occasionally during camera changes
 
Screwed up how?
I stop watching when the commercials end, but I see there is a game of some sort on screen
 
bad switching somehow, I get a lot of interlaced video (like 15 frames or so) during camera transitions
but it's intermittent at best
imagined at worst
 
maybe you're having the same problem as rebecca
insufficient bandwidth!
 
12:56 AM
well except we're definitely on different nodes and I'm not on HD
 
most nodes are probably under strain today
and it's all digital TV now that analog's gone
 
My HD feed came back after about 2 minutes and has been fine since.
Also, you silly people that just watch for the commercials confuse me.
q:
 
@RebeccaChernoff bah, this whole devoting roughly two months of my year's free time to watching a thousand people's every move confuses me
 
Um, huh?
 
a full-bandwidth HD stream would run at 19 megabits per second per channel, but nobody actually devotes that all to one channel
 
12:59 AM
I'm not gonna pay attention to the whole season, so why focus on one game
@DanGrossman are you allowing for compression?
I'm surely not gonna watch just one team out of the whole league
 
Like I said, nobody does it :)
 
@DanGrossman well yeah, that would be dumb :p
we also don't single stack boxes on the floors of tractor trailers and send them across the country, we palletize them and stack them as tall as is safe for all involved
 
Usually.
strong argument there, toyota
 
I just realized I can't watch the superbowl :O
 
@RebeccaChernoff isn't it the whole point?
 
1:04 AM
Um, no. It is a football game.
 
"So yeah! You should try baseball! It's got like bursts of five seconds of action! So many ad opportunities, you just can't make a game with more holes and less action. It's really impossible." "Impossible you say? Challenge accepted!" ...and so was the American Football invented.
 
← hasn't actually watched an entire game in his life. Too much meta.
 
> According to a Wall Street Journal study of four recent broadcasts, and similar estimates by researchers, the average amount of time the ball is in play on the field during an NFL game is about 11 minutes. online.wsj.com/article/…
 
and the total game time is?
 
1:08 AM
2-4 hours?
 
I get the concept of metaphor, but do we really need to use baseball metaphors to describe football?
 
ok. never seen it
 
lol 4 hours?
 
more?
 
The total game is like 75 minutes
 
1:08 AM
The Superbowl is 4 hours long according to the TV guide!
 
3hrs of commercials
 
There's lots of pre-game and post-game stuff.
 
The entire presentation as packaged by the media conglomerates to display the entirety of the spectacle we call the superbowl is about 4 hours (not discounting potential overtime, or the preceding and following "specials" on TV)
There's the opening ceremony, where people sing, and coins are flipped
there's the halftime (which is on now)
 
fake fans?
 
games themselves are 2:45-3:15
 
1:10 AM
no, they're really fans of the BEP
 
@RebeccaChernoff seriously? I disagree. Or are you counting all the timeouts and everything?
 
The rest isn't just commercials, the clock isn't running the entire time.
 
@DanGrossman what I wanna know is who was responsible for turning the mikes up :p
 
@drachenstern, um what?
 
1:10 AM
@RebeccaChernoff a football quarter is 15 minutes, no?
 
Of game play yes. That doesn't mean it takes 15 minutes real-time for a quarter.
 
My wife is not impressed by the live performance
@RebeccaChernoff I know, but my point was gameplay is 75 minutes. Most televised football games are much longer, yes.
 
Tron?
this is weird
 
@DanGrossman I was curious
my wife asked who the other two were :p
 
Where are you getting 75 minutes??
A quarter is 15 minutes of game play. There are 4 quarters. 4*15 != 75. |:
q:
 
1:12 AM
4 * 15 + 15 (for halftime and normal timeouts)
 
> A standard football game consists of four 15-minute quarters (12-minute quarters in high-school football and often shorter at lower levels),[17] with a 12-minute half-time intermission after the second quarter
American football, known in the United States simply as football and sometimes as gridiron outside the United States and Canada, is a sport played between two teams of eleven. The objective of the game is to score points by advancing the ball (actually a prolate spheroid) into the opposing team's end zone. The ball can be advanced by running with it or throwing it to a teammate. Points can be scored by carrying the ball over the opponent's goal line, catching a pass thrown over that goal line, kicking the ball through the opponent's goal posts or tackling an opposing ball carrier in hi...
 
Yeah, you're undercutting there @drachenstern.
 
@RebeccaChernoff for televised performances yes
 
I did not know that, officially, football is a game played with prolate spheroids.
 
for the rules, I don't think I am am I?
 
1:14 AM
My assumption is that we are talking about NFL games here. NFL games are televised. So I'm not sure what difference you're trying to point out...
 
That a football game shouldn't take that long
 
If nobody watches the broadcast, was the game actually played?
 
at least 2 hours of the superbowl is taken over by advertising and the sponsors
 
@DanGrossman If nobody watches the broadcast, the game is cancelled!
 
that's nothing in comparison to snooker finals that can take up to 3 days long :-P
 
1:15 AM
Waste of money.
Anyway, "yay" for semi-legal internet feeds.
 
@drachenstern, yeah...no. Heh.
 
How much of that left?
 
@badp the halftime performance?
 
yeah
 
1:16 AM
it should be close to wrapping up, maybe five more minutes I think
idk myself
 
The National Football League (NFL) playoffs are a single-elimination tournament held at the end of the 16-game regular season to determine the NFL champion. Six teams from each of the league's two conferences qualify for the playoffs based on regular season records, and a tie-breaking procedure exists in the case of equal records. It ends with the Super Bowl, the league's championship game, which matches the two conference champions. NFL post-season history can be traced to the first NFL Championship Game in 1933, though in the early years, qualification for the game was based solely on ...
 
oh, nm, usher, so probably another 15 minutes :\
 
so how is the radio music during the superbowls specialer than common radio? :)
moar autotune?
 
@badp it's not really, just who they choose to put on the stage. it's all about trying to capture the zeitgeist
I guess we gotta wait for them to finish spelling Love in the middle of the field?
Either that or one of the stage's lightpanels is out
 
@drachenstern this.
 
1:20 AM
My wife hasn't heard this remix yet, she's all "WTF?"
 
lucky her
 
silly box heads.
 
couldn't they, whatdoiknow, propose something new? I swear all of these songs must have 6+ months
 
Yeah they lost me on that one
@badp just like most tours
 
"cloud" commercials NEVER make sense
 
1:22 AM
aw, this is the spanish channel
US commercials about european soccer :|
 
haha, ouch
yellawood is a sponsor at the superbowl? o.O
 
@drachenstern Hey, how would you resolve all the events at exactly the same time consistently?
 
sorted by discovered date
 
The best thing is, if the US hadn't blocked those stream indexing sites, I'd never found out about them
 
otherwise I'm led to believe it's in the order I presented in the spreadsheet
 
1:24 AM
yeah, use a torch in a disco floor. Good plan.
 
@mootinator we don't need to clutter the feed in here for that
 
I'll clutter your question with an imperfect solution then :P
 
lol, that'll work
 
sigh, another break.
bah, I totally expected "Meth" there.
lol, a commercial for a commercial.
I must be new here.
stop stop stop stop! too much action!
 
@badp you must be watching the live feed of the game
do you watch much american football?
 
1:31 AM
@drachenstern I am, it'll be delayed
@drachenstern Never watched much
I'll maybe watch the 3rd quarter then head to bed
0232 now
lol, full 45 seconds, a pass and another stop.
I guess this is all about the psychology
 
one thing i hate more then dirty bit is dirty bit live
@badp yeah, that's what she was saying about it being a 3 hour game
versus my assertion (however false it may be) that there's only supposedly 75 minutes of game play
 
@drachenstern well at least 45 seconds did pass.
 
ok, bieber was mostly funny, I only saw half of that
 
what are the players doing exactly right now?
...fuck all
 
singing songs sitting indian style in circles in the middle of the field
 
1:39 AM
I'm just glad I only recognized Bieber at the very end of the commercial
 
putting ozzy in there not knowing bieber was funny
 
and as I alt-tab I miss the 10 second of action of this quarter hour :|
 
@badp that is why I don't follow the whole season
 
Wow, way to ride on GoDaddy's superbowl spend
 
yeeey.
something happened
enjoy the ensuing 15 mins of replays and commercials, I'll go sleep now
(and sorry for the undue snarkiness, there were 2 more seconds of action after all)
 
1:43 AM
@badp bah, don't apologize :p
at least they wait till the gameplay to show the thunderstorm warning instead of during the commericials :D
 
lol
plots to destroy the CRTC.
 
Lol. This user just accused me of lying:
0
A: How to represent NaN in array of numbers?

TheBigOdouble d = 0.0/0.0; if(Double.isNan(d)){ // Double d is not a number. } Alternatively: double d = Double.Nan; if(Double.isNan(d)){ // Double d is not a number. }

 
@mootinator reckon that can be used to also reduce and remove the repeated lines?
 
Ah, the Groupon commercials begin.
 
@drachenstern Probably. My brain is on a break though.
 
1:51 AM
that was a cute coke commercial
@mootinator yeah, I'm gonna play with it a bit. I also have a possible use for that one in particular
now to join it against a table for "current events" that I can mock up and see if I get the same basic results
 
@ChrisJesterYoung YOU LIE!
2
 
@RebeccaChernoff ++ That's awesome, with the Joe Wilson reference. :-)
 
@ChrisJesterYoung obviously you did not report your actions honorably! There's no way you would say you downvoted, then say you undid the downvote, and mean either one!
I can't remember if I've had or not had a Stella Artois. I think I have.
 
@drachenstern I cite single static assignment. :-) So the first version of downvotes = 1; second version of downvotes = 0.
 
What's missing in the logic trail is that there were TWO downvoters based on someone upvoting your -1. Your removing one did not negate the other.
 
1:56 AM
@drachenstern Exactly.
 
@drachenstern It's also not ignoring solo 'on' events... oops O_o.
 
Yeah but I think I can tweak it, I like what you did with two CTEs like that
 
This is a good commercial. Whatever agency made it should win an award.
 
@drachenstern Eh, regardless I fixed the dumb mistakes I left in there ;)
 
2:06 AM
what is it about?
driving carefully?
 
0
A: Automated query on Data-Explorer make Everything useless

wafflesFine then, spoil all the fun for anonymous, see if I care. 20,000 queries deleted, another ip is in the blacklist. ALL anonymous users must solve a Captcha before running any queries.

 
Does this have any affect on users via the odata endpoint?
 
nope ... I left that in tact ... though I think I should be tougher on users doing too much odata work
 
What could you do?
 
2:15 AM
@mootinator ok, cool
 
Seems like options would be limited, but I don't know much about it.
 
I dunno ... cut it so they can only run a total of N queries per day
where N is probably 50
something low
 
@waffles and we wish you would give us a few more datapoints via API and we would probably run even less odata queries overall ;)
 
@drachenstern, like what?
 
@drachenstern Kev is working on a 1.1 version with a bunch of missing stuff like tag synonyms and so on
 
2:19 AM
@RebeccaChernoff like the top 25 queries, idk, hadn't thought about it that much just a general feeling
@waffles I had heard that
 
Yeah, there's some cool new stuff in 1.1. (:
 
@RebeccaChernoff cool
 
@drachenstern Hrm, I misunderstood. I thought you meant you wanted more data added to the api, but it sounds like you want data.stackexchange stuff added to the api?
 
@drachenstern Did you notice that the odata did, in fact have the lowest scored posts between 12-1am EST?
 
I thought it was 4-5
 
2:21 AM
4-5UTC
or 4-6
 
@RebeccaChernoff the general queries, yes. Instead of making us go looking for stuff like "how close am I to XYZ" then expose it
 
the two hours were close...
 
@mootinator oh, so we were right, sweet
and that was just a gut feel
 
@drachenstern Meh, I dunno that adding those adds a ton of value to the api. They're supposed to be surprises! (kinda)
 
@RebeccaChernoff but we can figure a lot of them out on our own or via the odata, so ... maybe I'm confused
 
2:23 AM
ehrm
that CURE commercial was NOT made well enough to invest $2 million in running it once
 
I probably need sleep
 
production budget: $100, distribution budget: $2 million, problem
 
Some of them, yeah. Some of them you can, but they don't give you an accurate picture.
 
and so if it was part of the API it might be a little more accurate, is my hope
I'm both selfish and lazy
I consider myself a good programmer because of that ;)
 
@drachenstern Spoken like a true Perl monger.
 
2:26 AM
ok, those aren't the only reasons I consider myself a good programmer :p
 
Badge progress is meant to be mysterious.
status-bydesign
 
@RebeccaChernoff I still say bah :p
 
@RebeccaChernoff I'm sure this goes quintuple for the elusive Hacker badge. :-P
 
21
Q: SO Badge Progress Report

SwDevMan81Is there a way to view the progress on certain SO Badges? For example: Tumbleweed - What value constitutes low views for a week? Fanatic and Woot – Is there a way to view how many days in a row you currently have? Beta – Is it even possible to get this badge anymore?

 
So what's the adage about if a team scores the first touchdown they lose overall? does that hold water?
that last pepsi max was funny
 
2:36 AM
Not watching. I'm editing last nights' concert.
 
/me does not have a TV, courtesy of some burglars a couple of months ago. But that's quite okay. I don't really miss it.
 
@ChrisJesterYoung if you have youtube you've got 90% of it ;)
 
gasps at @ChrisJesterYoung's scandalous plaintext use of /me
 
@RebeccaChernoff I don't think he has the userscript ;)
 
that's, um, basically what I was pointing out.
(;
 
2:38 AM
@RebeccaChernoff :-P
 
@ChrisJesterYoung I would expect the result of having a TV burglarized, for a programmer, would be an increase in client time or profitable side projects, leading to much more money than needed to replace the TV
 
@RebeccaChernoff If he's a Chrome dev user, I guess he has an excuse for the moment. :P
 
@RebeccaChernoff so .. um ... /me whoosh then?
 
@RebeccaChernoff Next time I'll be sure to send actual CTCP control codes instead. :-P
<3 Firebug, which allows me to send all kinds of garbage to sites that don't do server-side checking. :-)
 
/privmsg the_tavern :that'd be great, thanks @ChrisJesterYoung.
 
2:40 AM
@RebeccaChernoff Lol.
 
/cs deop #thetavern @RebeccaChernoff
 
noooooooooooooooooooooooooooo ):
 
/me fingers everyone in the channel.
 
2:43 AM
/me shudders
 
/kill @zerkms Just for the lulz
 
Nice two point conversion.
 
@DanGrossman I'm pretty sure we all know about the finger command sir ;)
 
/oper cky hunter2
; http://www.bash.org/?244321
@statuscompleted O_o
 
2:46 AM
@ChrisJesterYoung oh, hey there
It's completed !
 
Good fun. :-D
 
ponies detected
 
training cannons...
 
Mercedes tried. Mercedes failed. Chrysler wins.
 
I think so
 
2:49 AM
I don't get why y'all are so obsessed over the commercials. Has even one of them made you think "I HAVE TO GO BUY THAT NOWWWW!"?
 
Yes, I want a XOOM tablet and a Chrysler.
 
want and will actually buy are different.
 
@RebeccaChernoff I must register a godaddy.co account NAO
 
That's not the point of commercials. That's the point of infomercials. If infomercials were the best way to generate sales they would fill all commercial air time.
 
oh wait, the superbowl was today, that's why you're talking about commercials. who won?
 
2:51 AM
It's still in progress
Google or Bing "superbowl"
 
may I Yahoo! it?
 
Yahoo! is Bing
 
Google gives a live score if you Google "super bowl".
 
@ChrisJesterYoung see my link
 
2:51 AM
Bing gives you a better live score chart if you search "super bowl"
 
oh, wow. looks like a good ending.
 
lol, "superdry" is the first suggistion for "super"
 
@drachenstern Your link ain't Google.
 
You can Google with Bing. It works.
 
@DanGrossman O_o
 
2:52 AM
@ChrisJesterYoung i was on google earlier, this is better
 
it is even a handy timeline in the right side
 
@drachenstern Fair enough.
 
he didn't stand a chance
glad he got yardage tho
None of my teachers were redheads in camaros!
 
APPLE?
Oh, Verizon.
 
Yeah, don't be silly.
 
2:58 AM
I was ready to sell some stock.
2 minutes remain. Game should be over in about half an hour.
 

« first day (187 days earlier)      last day (4827 days later) »