Programmers Stack Exchange is a question and answer site for professional programmers interested in conceptual questions about software development. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I'm performing some research and analysis on bug/issue tracking databases and more specifically on how programmers and teams of programmers actually interact with them. What I'm looking for involves understanding how those databases change over time.

So what I don't need for example: is a database of all the bugs of some open source project as the bugs exist today. What I do need is a complete set of revision history for every issue/bug in the database. This would enable me to pick a specific datetime and say here were the list of all the issues/bugs that existed at that moment in time.

Anyway know of some publicly accessible issue/bug databases that expose this revision data?

Ideally, the revision would look something like this (shown for a single bug, with two revisions)

 1        2    2    mel         apr-1-2010:5pm  apr-1-2010:6pm
 1        2    3    steve       apr-1-2010:6pm  NULL
share|improve this question

closed as off-topic by gnat, Ixrec, Scant Roger, GlenH7, Matthieu M. Dec 21 '15 at 12:46

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Questions asking us to find or recommend tools, libraries, programming languages, resources (including books, blogs, tutorials, and examples), or projects to undertake are off-topic on Programmers as they attract opinionated answers that won't have lasting value to others. You may be able to get help in The Whiteboard, our chat room." – gnat, Ixrec, Scant Roger, GlenH7, Matthieu M.
If this question can be reworded to fit the rules in the help center, please edit the question.

JIRA exposes related data via its REST API, I don't really know of an easier / less complicated way. If you go that way, ASF's JIRA will be a great source for data. – Yannis Dec 29 '11 at 16:03
What bug tracking system you this for? Any analysis is predicated on the existence of the data source which I am assuming already exists for you. – Karlson Dec 29 '11 at 19:41
@Karlson - It doesn't matter what bug tracking system this is. I've just looking for any large sample set of data from somewhere that I can analyze. – namenlos Dec 30 '11 at 7:37
@namenlos Reading your question again I am puzzled. Are you looking for someone to publicly expose the raw data on their bug tracking to the public? You might have to register for quite a few of them and see what you can do in terms of reports. That might give you what you need. Start with Bugzilla implementations on – Karlson Dec 30 '11 at 14:53
What you probably need to to do is to extract the data from a bug tracking system (possible with both Jira and Bugzilla). Look at any ASF or JBoss Jira or Bugzilla project. – Marco Feb 18 '12 at 9:37

You might want to have a look at Philip Guo's publications (and maybe get into contact). If I remember correctly, he published a few papers for which he had access to data of big bug trackers.

share|improve this answer

Use this presentation:

to write queries you want against (for example) this database:

good luck!

share|improve this answer
why? What's good about it? How did it help you? Providing links is useful but not any one can google and find them. What google cannot provide is the insight you have and your experience. That's the value added in a good answer. – Walter Oct 10 '12 at 13:02
Thanks for the feedback, @Walter. Like you said, "not anyone can google and find them", so sometimes it useful to provide them for someone. Will do better next time! – Adam Adamaszek Oct 12 '12 at 19:24

Not the answer you're looking for? Browse other questions tagged or ask your own question.