Re: Fun with the BTS and an SQL DB

2007-05-05 Thread Holger Levsen
Hi, On Friday 04 May 2007 22:36, Lucas Nussbaum wrote: Some quick results: n | packages with more than n bugs open in unstable 10 | 1043 0 | 6783 Wow. Only 1000 packages have more than 10 bugs and more than 3000 packages are bug-free (if you counted source packages). Of course, we still

Re: Fun with the BTS and an SQL DB

2007-05-05 Thread Lucas Nussbaum
On 05/05/07 at 12:39 +0200, Holger Levsen wrote: Hi, On Friday 04 May 2007 22:36, Lucas Nussbaum wrote: Some quick results: n | packages with more than n bugs open in unstable 10 | 1043 0 | 6783 Wow. Only 1000 packages have more than 10 bugs and more than 3000 packages are

Re: Fun with the BTS and an SQL DB

2007-05-05 Thread Stefano Zacchiroli
On Sat, May 05, 2007 at 12:39:56PM +0200, Holger Levsen wrote: Wow. Only 1000 packages have more than 10 bugs and more than 3000 packages are bug-free (if you counted source packages). Of course, we still can should do better :-) On Sat, May 05, 2007 at 08:27:16PM +0200, Lucas Nussbaum

Re: Fun with the BTS and an SQL DB

2007-05-05 Thread Lucas Nussbaum
On 05/05/07 at 23:34 +0200, Stefano Zacchiroli wrote: On Sat, May 05, 2007 at 12:39:56PM +0200, Holger Levsen wrote: Wow. Only 1000 packages have more than 10 bugs and more than 3000 packages are bug-free (if you counted source packages). Of course, we still can should do better :-)

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 or

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 the