Archive for September, 2008
Importing bugs into UDD, faster.
Saturday, September 27th, 2008Importing bugs from the Debian Bug Tracking System into UDD (the Ultimate Debian Database) in a reasonable time is challenging. The BTS uses flat files to store bug information, and importing a bug typically requires reading a ‘summary’ file, and a file containing the verisoning information, both of a few hundred bytes. That looks easy, [...]
Cool stats about Debian bugs
Wednesday, September 24th, 2008Now that bug #500000 has been reported, let’s have a look at all our other bugs, using UDD. Number of archived bugs: select count(*) from archived_bugs; count ——– 402826 Number of unarchived bugs marked done: select count(*) from bugs where status = ‘done’; count ——- 8267 Status of unarchived bugs (“pending” doesn’t mean “tagged pending” [...]
Looking for cliques in the GPG signatures graph
Friday, September 19th, 2008The strongly connected set of the GPG keys graph contains a bit more than 40000 keys now (yes, that’s a lot of geeks!). I wondered what was the biggest clique (complete subgraph) in that graph, and also of course the biggest clique I was in. It’s easy to grab the whole web of trust there. [...]
tool to mirror a website locally?
Thursday, September 18th, 2008Dear lazyweb, I need a tool to mirror a website locally (so I can browse it offline). Requirements: – not GUI-based (I want to run it in a script) – support recursive retrieval and include/exclude lists (like wget) – no output when everything is fine, but still output errors (not possible with wget, which still [...]
New Debian Developers!
Tuesday, September 16th, 2008We got a lot of (>= 10) new Debian developers recently. I’m really happy to see that the bottlenecks in the New Maintainer process were (at least partially) solved. My first NM (actually my second, my first one is on hold) also became a DD today. So, how long does it take to become a [...]
Is Mozilla the new XFree86? Could Ubuntu actually help?
Tuesday, September 16th, 2008All the recent moves of Mozilla make me feel that they are really taking the XFree86 path. Reading the Launchpad bug log about the EULA shows that most of the posters agree on who is on the wrong side, and favor switching to IceWeasel or Epiphany+Webkit. Even if Mozilla is apparently going to back off [...]
UDD and Buildstat
Wednesday, September 10th, 2008Ultimate Debian Database (UDD) is a GSoC project (now finished) which aimed at importing all different data sources that we have in Debian in a single SQL database, to make it easy to combine that data. Currently, we import information about source and binary packages, all bugs (both archived and unarchived), lintian, carnivore, popcon, history [...]