Fun with the BTS and an SQL DB

2007-05-04 Thread Lucas Nussbaum
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

Let's remove libapache-mod-gzip

2007-05-04 Thread Thijs Kinkhorst
reassign 401682 ftp.debian.org retitle 401682 RM: libapache-mod-gzip -- RoQA; Apache 1 only, orphaned thanks Hi all, Let's remove libapache-mod-gzip: - Supports Apache 1 only, which is about to be removed (see #418266). - Apache2 has this functionality built-in (mod_deflate). - Orphaned for 5 mon

Re: Fun with the BTS and an SQL DB

2007-05-04 Thread Filippo Giunchedi
On Fri, May 04, 2007 at 04:59:27PM +0200, Lucas Nussbaum wrote: > Hi, [...] > 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

Re: Fun with the BTS and an SQL DB

2007-05-04 Thread Filippo Giunchedi
On Fri, May 04, 2007 at 04:59:27PM +0200, Lucas Nussbaum wrote: > Hi, > > (for details, the DB schema is readable on > http://qa.debian.org/~lucas/pg-schema.sql ) just a few more comments on bugs_bugs: can it be useful to store usertags? what about added tags? I guess this would need to change

RFO: crystalspace, RC buggy > 1yr w/patch, not in oldstable/stable

2007-05-04 Thread Steve Langasek
crystalspace has been failing to build on alpha for > 1yr, even though a patch has been available in the BTS for 6 months today. Previous versions of the package built fine on all architectures, making this a serious regression and preventing the package's inclusion in a stable release (or in test

Re: RFO: crystalspace, RC buggy > 1yr w/patch, not in oldstable/stable

2007-05-04 Thread Bart Martens
On Fri, 2007-05-04 at 12:47 -0700, Steve Langasek wrote: > crystalspace has been failing to build on alpha for > 1yr, even though a > patch has been available in the BTS for 6 months today. Previous versions > of the package built fine on all architectures, making this a serious > regression and p

Re: Fun with the BTS and an SQL DB

2007-05-04 Thread Lucas Nussbaum
On 04/05/07 at 18:24 +0200, Filippo Giunchedi wrote: > just out of curiosity: have you already thought how to size the > threshold n ? Not yet. The algorithm will probably be something like that: - get a list of interesting packages and maintainers - add the missing ones to the "permanent" list t