- 04:47 PM
- 11/20/09
| 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 by qbert72 to hockey at 07:53 PM on March 10 - 8 comments
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 by qbert72 to fantasy at 05:29 PM on October 29 - 10 comments
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 by qbert72 to fantasy at 11:40 PM on October 01 - 29 comments
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 by qbert72 to fantasy at 09:10 AM on September 11 - 22 comments
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 by qbert72 to culture at 09:09 AM on August 30 - 6 comments
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 by qbert72 at 02:38 AM on August 29
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 by qbert72 at 01:53 AM on August 27
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 by qbert72 at 06:35 PM on August 26
OK, I'll fess up. I haven't sent mine yet. But I haven't received one either. So there.
posted by qbert72 at 01:32 AM on April 21
Drood, I think netbros' point is that there is a factual error in rcade's post.
posted by qbert72 at 01:14 AM on April 21
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 by qbert72 at 12:03 AM on April 11
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 by qbert72 at 01:19 AM on April 10
I'm in. Thanks for setting this up, YYM. Glad to see our little app still getting used!
posted by qbert72 at 10:50 PM on April 08
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 by qbert72 at 10:47 PM on March 31
Mine will be late too. Thanks for the reminder, Folkways. I'll work on it today.
posted by qbert72 at 12:45 PM on March 15
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 by qbert72 at 10:12 PM on March 11
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 by qbert72 at 08:53 PM on March 10
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 by qbert72 at 04:13 PM on February 24
I'm pending. Under same name. I'm not afraid to show the world how much shit I listen to.
posted by qbert72 at 10:04 PM on February 02
Fan Ejected From Yankee Stadium For Bathroom Break During 'God Bless America'
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.