Visualizing trends in the bug-tracker

At work I manage projects with Trac. It’s great. We have about ten different projects, including websites and internal web apps, with most of the code in a central Subversion repository hooked up to Trac so that it’s easy to see what got changed when (and why!). But rather than bore you with Trac evangelism I’ll share a goofy hack I built to get a basic visualization of the ticket load in Trac over time.

Trac spam

It’s a problem. Trac is a fantastic, world-dominating software project management and bug-tracking system written in Python. It integrates with Subversion and has a wiki and just works. Even the Rails guys use it. It’s possible that if Trac and Chuck Norris walked into a bar, only Trac would leave. But unfortunately, the comment-spammers and wiki-spammers have noticed Trac and have been updating their scripts. Hence the 12,00015,000 hits for “trac spam.

Introduction to Trac

Newsforge has posted a nice brief introduction to Trac. If you haven’t heard of it yet, Trac is a sophisticated and well-designed software project management system written in Python, with excellent Subversion integration. I’ve enjoyed seeing it grow and spread – even people who are quite devoted to languages other than Python use it enthusiastically.