Stefano Zacchiroli: PTS and package descriptions
PTS, package descriptions (and more than a bit of UDD)
After delivering my
talk at DebConf, I went back to some (more) PTS hacking ... apparently I'm
in the mood for it
An apparently trivial feature
request (showing package descriptions)
provided for interesting thoughts. First of all the PTS is mostly
source-based, but in Debian we have no source package
descriptions (issue which probably deserves fixing by its
own). Rough consensus has then been to add tooltips on binary
package hyperlinks, to show short descriptions.
Still, adding the import of
An apparently trivial feature
request (showing package descriptions)
provided for interesting thoughts. First of all the PTS is mostly
source-based, but in Debian we have no source package
descriptions (issue which probably deserves fixing by its
own). Rough consensus has then been to add tooltips on binary
package hyperlinks, to show short descriptions.
Still, adding the import of Packages sounded like
overkilling, not mentioning duplicated wrt packages.d.o. Hence I decided to
be the first jumping on the UDD boat
(wonderful GSOC
project which I had the pleasure to co-mentor together with
Lucas and HE) for routinely usage.
Retrieving the most recent short description of each
binary package at each PTS run is as easy as:
select distinct packages.package, packages.description
from packages,
(select package, max(version) from packages group by package)
as latest (package, version)
where packages.package = latest.package
and packages.version = latest.version ;
To solve the more generic problem of the PTS missing a generic
description (or, if you want, to mitigate the problem that in
Debian we are missing a source package description), Lucas came up
with the intriguing idea of showing the description of the
most popular binary package, according to popocon. Piece
of cake:
select distinct packages.package, popcon.insts, packages.description
from packages, popcon,
(select package, max(version) from packages group by package)
as latest (package, version)
where packages.package = latest.package
and packages.version = latest.version
and packages.package = popcon.package ;
(same as before, but adding popularity: one has both all
short descriptions, and a way to spot the "canonical"
one)
Long life to UDD.
(BTW if you are interested in UDD, and you happen to be
at DebConf8, do not miss tomorrow's
QA BOF.)
A few notes/reactions from the talks I attended today from the very, very
back of the room. (AKA the skivvies and/or backyard track.)
(
It's more or less four months since I proposed to
Well a semi-productive week during which I 
Packages uploaded in Debconf.
I've uploaded qemubuilder new version which supports armel architecture. And I updated dpatch with some necessary patches.
Otavio has updated kernel-wedge in SVN to 2.6.26, so I updated ARM and MIPS
today. The udebs built after minor modifications and I can also build
installer images after having fixed some bugs in the build process. I
tested a 2.6.26 based image on the QNAP TS-409 (armel) as well as in QEMU
(mipsel).
2.6.26 will bring major improvements on ARM. Orion support is much better
and our 2.6.26 has a number of patches from Marvell that help with
performance on Orion. Our 2.6.26 also has Riku Voipio's LED driver for
Thecus N2100 which has been accepted for the 2.6.27 mainline kernel.
I haven't actually uploaded the udebs yet because I'm waiting for the
go-ahead as well as for the new version of the 2.6.26 kernel package to
build. But at least we're getting closer to having 2.6.26 as the kernel
for lenny.
in seven hours DebConf8 will officially begin, you can participate by watching the live video streams as described on the
It took me 34 hours elapsed time to get from a hotel in downtown San Francisco
to the
Do you know code that compare versions of debian packages (for example, that knows if 2:23.2.3~rc1-1 is lower than 2:23.2.3-2?), besides dpkg –compare-versions? If yes, please write a comment to this blog post, preferably with a link to the code.
Also, did someone already write a test suite for that? Who would be interested in such a test suite?
I’m considering writing a function in PL/SQL to compare debian versions (for the Ultimate Debian Database project). If someone already wrote that, I’m interested as well.
Debcamp is nice. Talking to people in person rather than having to do
IRC to get anything done is a breeze, really.
One thing I haven't been particularly happy about is the fact that
there aren't any good statistics on what the build capacity of an
architecture is; i.e., you don't know you're low on build capacity until
you suddenly start backlogging and it's too late. So, since J rg
Jaspert, Mark Hymers, and Steve Gran were there, I asked them whether
it'd be possible to add some data to the projectb database about
installing a binary. One additional column with a default now()
option later, and we now have interesting data that I can make
statistics of. Of course, since that column was only added four days
ago, during one of which the link to ftp-master.debian.org was down
(meaning, no uploads), there's not much data there yet; but I can start
making some graphs now.
Of course, the hard part is trying to figure out how to present the
data in a manner that one can actually get useful conclusions from,
which is harder than it seems. Anyhow, I'm trying. For now, on
As version 0.9.6 of
Here at 

First complete day after a full day travelling and I'm just about over the jet lag. Progress so far: