Recently Ayende posted a simple SQL script for calculating the most popular posts in your Subtext blog. Being of the curious nature, I couldn't help but run the query against my own blog...
The Results:
- iPod Shuffle - What I Learned My First Day.
- .Text's MetaWeblog API - Edit Post Error...
- Hotfix KB928388 - Revised Daylight Savings Time
- subText Reaches 1,000 Downloads - and Counting!
- Debugging a .NET WebApp in VS.NET
- Gaim - MSN Crashes
- Using MbUnit with COM+ 1.5 transactions... a big Gotcha!
- CVS - Keeping your branch(es) in sync...
- Notepad++ : The best little editor money can't buy!
- [How-To] Save Your Visual Studio 2003 Settings.
- Mapping Drives via Remote Desktop
- w.bloggar v4.00 is released!
- Recently Discovered GMail Vulnerability... FIXED!
- WinXP - Zune Theme
- The 'ATLAS' Framework - Callback Handler JavaScript Bug
One of the cool things about this particular query is that it is weighted to help normalize the data a bit. See Ayende's post for more details. I'm not sure that I would have guessed some of those posts would have made my Top 15, but the numbers don't lie.
It's funny because some of those posts are from way back in the beginning when I was just cutting my teeth on .NET and blogging, and still had no idea where this blog would go... if anywhere.
Why not bake this into Subtext?
As I was looking through this and some of the other blog stats queries Ayende has posted as of late, I got to thinking... why not just bake this right into Subtext? Maybe add a new page in the Admin UI and a new Skin control?
But then I realized... we have a new plugin framework coming down the pipe for Subtext v2.0! So maybe some ambitious developer out there will take it upon him/herself to build these great queries into a shiny new plugin. Any takers? :)
Tags: subtext ayende blogstats sql