Hi, I have worked on importing the output of bugscan in a postgresql DB (on merkel.d.o). I am now able to run queries such as:
* 10 maintainers with the highest number of bugs tagged patch (including * or excluding co-maintained packages) * bugs filed against packages no longer in Debian * total number of bugs opened in unstable, grouped by severity * ... (for details, the DB schema is readable on http://qa.debian.org/~lucas/pg-schema.sql ) The next step is to allow to record the evolution of the data. For example, I'd like to be able to graph the evolution of the number of open bugs in all the packages maintained or co-maintained by a given email address. For this, I'll probably run a daily cronjob that will run a query and store the result in a different table (I don't want to store all the information, but just a summary of it). Since I'll do a summary, I won't be able to regenerate the data if I want to get *more* information, so I have to determine carefully which summary to store. What I'm planning to do is to store on a daily basis: for all packages in Debian, for all packages maintained by the same person (restricting this to persons with at least 'n' bugs), for all packages maintained or co-maintained by the same person (restricting this to persons with at least 'n' bugs), for each package (restricting this to at least 'n' bugs), the number of packages in the group considered the number of open bugs in unstable for each severity the number of open bugs in unstable (excluding bugs tagged moreinfo or unreproducible) for each severity the number of open bugs in unstable not tagged moreinfo or unreproducible, but tagged patch, for each severity the number of release-critical bugs in testing *Can you think of other things that it would be interesting to store ?* (Of course, old rows will be removed after some time, using a simple expiration scheme) Thank you, -- | Lucas Nussbaum | [EMAIL PROTECTED] http://www.lucas-nussbaum.net/ | | jabber: [EMAIL PROTECTED] GPG: 1024D/023B3F4F | -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
