- 02:20 AM
- 12/02/08
| Name: | Alexandre Simard |
|---|---|
| Homepage URL: | http://www.brocheafoin.biz |
| Location: | Montréal |
| Gender: | M |
| Member since: | January 29, 2002 |
| Last visit: | September 08, 2008 |
qbert72 has posted 14 links and 720 comments to SportsFilter and 26 links and 565 comments to the Locker Room.
"That," Capitals coach Bruce Boudreau said, "was officially heartbreaking." Backstrom knocks in winning goal for wrong team.
posted on March 10, 2008 - Go to the detail view for this result
World Series confidence pool final standings The Red Sox put trox and tron7 over the top, ending my supremacy to my great dismay. apoch did a fine job securing the Costanza. Congratulations to everyone involved!
posted on October 29, 2007 - Go to the detail view for this result
World Series Confidence Pool! Help me kick the tires on my new super-speedy server and show off your mad prediction skillz by entering a good old-fashioned confidence pool for this year's MLB post season. You have until 6:30PM on Wednesday to enter your picks. If you're not familiar with this type of pool, please read DrJohnEvans' primer.
posted on October 01, 2007 - Go to the detail view for this result
Fantasy Hockey anyone? Yahoo! has opened registration for hockey leagues a couple of days ago. Who will start a SpoFi league? Not me, since I'm taking a break from fantasy sports this winter. But SpoFi still needs to see another edition of the battle royale between Weedy and grum (and new contenders) for fantasy hockey supremacy.
posted on September 11, 2007 - Go to the detail view for this result
A Pro Hockey Player, a Noise Label, a Dream Realized Boyd Devereaux grows tired of the usual Nickelback and Bon Jovi pre-game pump up jams and begins surreptitious nightly excursions into the underground psych and noise scenes, which will lead him to found his own record label.
posted on August 30, 2007 - Go to the detail view for this result
Fan Ejected From Yankee Stadium For Bathroom Break During 'God Bless America' The no movement rule has been in place since 9/11, much like the playing of the song.
posted by AaronGNP at 12:20 AM on September 08
Welcome to the New Server SportsFilter has relaunched on a new Linux server with MySQL/PHP software driving the site. All weblog posts and comments have been moved over, going all the way back to the first post on Jan. 24, 2002. (Updated Aug. 21).
posted by rcade at 02:31 PM on August 29
Yeah, but you don't want to run a query for every post
No, I don't. I forgot to say that I'm running my new comments query on top of the regular (non-logged-in) front page query, which should be fairly straightforward (apart from regular 'Oh, right, MySQL doesn't support this' drudgery).
Then the *new* markers are just 'joined' in code when outputting the page. You could even conceivably just parse the cached version of the page to add these markers, and forego the initial query.
I'm absolutely not certain I'm being clear here...
posted at 02:38 AM on August 29
Welcome to the New Server SportsFilter has relaunched on a new Linux server with MySQL/PHP software driving the site. All weblog posts and comments have been moved over, going all the way back to the first post on Jan. 24, 2002. (Updated Aug. 21).
posted by rcade at 02:31 PM on August 27
rcade: I gotta figure out how Matt did it without crushing his database
yerfatma: I always wondered that too. If you figure it out, can you provide details? There's really nothing you can cache. I think the front page of Metafilter is static for non-logged-in users, which would relieve a lot of strain on the db.
I think you're right that the front page is cached for non-logged-in users. As for the new comments indicators, if I recall correctly, there was a cookie in previous SpoFi containing a datetime for the last visit. I'm assuming Matt used a single query such as
SELECT post_id, id FROM comments WHERE published_date > current_user.last_visit ORDER BY post_id ASC, id ASC
The result count of this query would yield the total of new comments. Then you only need a couple of loops in CF/PHP/whatever to get the first new comment and the number of new comments for each post. It's a single query on a single table, the least strain you can put on the db.
posted at 01:53 AM on August 27
Welcome to the New Server SportsFilter has relaunched on a new Linux server with MySQL/PHP software driving the site. All weblog posts and comments have been moved over, going all the way back to the first post on Jan. 24, 2002. (Updated Aug. 21).
posted by rcade at 02:31 PM on August 26
OK, some comments:
* The "view older posts" link in the Locker Room brings you to older posts on the main site
* There is no longer an archive by month or category that I can find
* I miss the search engine
All of these are closely related to me wanting to reread the classic Red Dawn thread.
posted at 06:35 PM on August 26
So, by "March," you actually meant "April," right? Right? I finally mailed out my SpoFi Swap CDs Thursday.
posted by The_Black_Hand at 03:01 PM on April 21
OK, I'll fess up. I haven't sent mine yet. But I haven't received one either. So there.
posted at 01:32 AM on April 21
Danica Patrick Wins IndyCar Race in Japan Danica Patrick became the first female winner in IndyCar history Sunday, taking the Indy Japan 300 when leader Helio Castroneves was forced to pit for fuel in the final laps. The 26-year-old driver won in her 50th IndyCar start. "She's rocketed herself to the top end of the roll call for most successful female racing drivers ever," writes Gemma Briggs. "The last significant victory was probably Michele Mouton's World Rally Championship win ... way back in 1981."
posted by rcade at 08:59 AM on April 21
Drood, I think netbros' point is that there is a factual error in rcade's post.
posted at 01:14 AM on April 21
2008 NHL Playoffs Confidence Pool Enter your picks here, more details inside.
posted by Ying Yang Mafia at 05:12 PM on April 11
All right, I've entered the SpoFi Collective based on our average picks, and the game results from the first two days of play. So we have a provisional leaderboard. Game on!
posted at 12:03 AM on April 11
2008 NHL Playoffs Confidence Pool Enter your picks here, more details inside.
posted by Ying Yang Mafia at 05:12 PM on April 10
Hmmm, most likely, yes. I haven't had a look at this code in ages... It's not such a big issue, is it?
posted at 01:19 AM on April 10
2008 NHL Playoffs Confidence Pool Enter your picks here, more details inside.
posted by Ying Yang Mafia at 05:12 PM on April 08
I'm in. Thanks for setting this up, YYM. Glad to see our little app still getting used!
posted at 10:50 PM on April 08
Bush Booed By Beltway Baseballers! The high heat shut 'em up a little bit, though.
posted by The_Black_Hand at 04:44 PM on March 31
first pitch at the Montreal Expos home opener in their new stadium Aww, man, don't rub it in. It was snowing here this afternoon, and I wondered how an opener in our brand new outdoors downtown stadium would have felt like.
posted at 10:47 PM on March 31
posted by Folkways at 04:31 PM on March 15
Mine will be late too. Thanks for the reminder, Folkways. I'll work on it today.
posted at 12:45 PM on March 15
"That," Capitals coach Bruce Boudreau said, "was officially heartbreaking." Backstrom knocks in winning goal for wrong team.
posted by qbert72 at 07:53 PM on March 11
Bryan McCabe says hello. Thanks, grum. I wanted to see other candidates. I still think Backstrom has this beat. McCabe is at least aiming towards the corner, just (a whole lot of) not enough. Backstrom actually strikes it back to the goal from outside the crease.
posted at 10:12 PM on March 11
"That," Capitals coach Bruce Boudreau said, "was officially heartbreaking." Backstrom knocks in winning goal for wrong team.
posted by qbert72 at 07:53 PM on March 10
I thought Backstrom's reaction was very weird. He just stayed there and started adjusting his gloves. But there's not much he could do, I guess. Huet and Ovechkin were already lying face to the ground in disgust. This is the worst "own goal" I've ever seen in hockey. Steve Smith's in 1986 had bigger consequences, but it was a fluke play. Backstrom's shooting it in like he would do if he was at the other side of the ice. I feel really bad for him too.
posted at 08:53 PM on March 10
Blackhawks to play in the Friendly Confines? The Chicago Blackhawks are gunning for an outdoor game and it looks as if they want to play it at Wrigley Field. [via]
posted by NoMich at 07:23 PM on February 24
What are the chances of a Habs-Leafs outdoor game? The Canadiens played against the Oilers in Edmonton for the first occurence of these outdoor games. I'm afraid other teams will get their turn before it comes back to us. Doesn't Montreal have an outdoor soccer stadium where they could play? Unfortunately, we don't. We have a huge, crumbling indoor stadium, and a few small-ish outdoor stadiums, including the the Alouettes' home, which seats 20 000 people, and the upcoming Stade Saputo, which will seat a maximum of 17 000. So it doesn't look good that way either...
posted at 04:13 PM on February 24
SportsfIlter last.fm Group I set up a SportsFilter group on last.fm and invited those people who I saw (on the Wiki) had last.fm accounts.
posted by terrapin at 12:21 PM on February 02
I'm pending. Under same name. I'm not afraid to show the world how much shit I listen to.
posted at 10:04 PM on February 02
These words in the linked article scare me:
During the patriotic 7th inning stretch at Yankee Stadium, [snip] he tried to leave his seat during the traditional singing of God Bless America
The Ministry of Truth is cooking up new traditions.