I recently posted a question to MySQL Forums about a small but perplexing problem I was having in formulating a subquery search in MySQL. [Off-topic: the answer seems to be that I can't do subqueries under the version of MySQL (4.0.18) I'm running. No problem: I'll pass the "subquery" to an array in PHP and then build the main query from there. Clunky, but it should work.]
I'm a Firefox convert and one of its best features is the ability to expand its feature set through the use of extensions. As lover of RSS, (variously called "Really Simple Syndication," "Rich Site Summary," or "RDF Site Summary") one of the first extensions I added was Sage, an RSS reader that runs in the sidebar window of Firefox.
So what does that have to do with the question I posted to MySQL Forums?
MySQL Forums passes not only the forum categories through an RSS feed, but individual threads as well. So I was able to use Sage to capture the RSS feed for my question and now it is a trivial matter to track responses to it. I don't have to go the forum unless I see there is a new addition to the thread. About the only oddness is that new threads are added at the top, so the first one in the RSS reader is the most recent. I guess it makes sense if it is a very active thread.
Thread (initial) view in Sage
Individual posting view in Sage
©
2008 Tom Keays /
Notebook /
Contact Me
URL: http://www.tomkeays.com/notebook/sage_mysql.php
Last updated: January 20, 2005