Since my motivation boost in the beginning of the month caused me to wrap up a new release of liboggz, I have used the same boost to wrap up new editions of libfishsound, liboggplay and libkate too. These have been tagged in upstream git, but not yet published on the Xiph download location. I am waiting for someone with access to have time to move the tarballs there, I hope it will happen in a few days. The same is the case for a minor update of liboggz too.
As I was looking at Xiph packages lacking updates, it occurred to me that there are packages in Debian that have not received a new upload in a long time. Looking for a way to identify them, I came across the ltnu script from the devscripts package. It can sort by last update, packages maintained by a single user/group, and is useful to figure out which packages a single maintainer should have a look at. But I wanted a archive wide summary. Based on the UDD SQL query used by ltnu, I ended up with the following command:
#!/bin/sh
env PGPASSWORD=udd-mirror psql --host=udd-mirror.debian.net --user=udd-mirror udd --command="
select source,
max(version) as ver,
max(date) as uploaded
from upload_history
where distribution='unstable' and
source in (select source
from sources
where release='sid')
group by source
order by max(date) asc
limit 50;"
This will sort all source packages in Debian by upload date, and list the 50 oldest ones. The end result is a list of packages I suspect could use some attention:
source | ver | uploaded
-----------------------------+-------------------------+------------------------
xserver-xorg-video-ivtvdev | 1.1.2-1 | 2011-02-09 22:26:27+00
dynamite | 0.1.1-2 | 2011-04-30 16:47:20+00
xkbind | 2010.05.20-1 | 2011-05-02 22:48:05+00
libspctag | 0.2-1 | 2011-09-22 18:47:07+00
gromit | 20041213-9 | 2011-11-13 21:02:56+00
s3switch | 0.1-1 | 2011-11-22 15:47:40+00
cd5 | 0.1-3 | 2011-12-07 21:19:05+00
xserver-xorg-video-glide | 1.2.0-1 | 2011-12-30 16:50:48+00
blahtexml | 0.9-1.1 | 2012-04-25 11:32:11+00
aggregate | 1.6-7 | 2012-05-01 00:47:11+00
rtfilter | 1.1-4 | 2012-05-11 12:50:00+00
sic | 1.1-5 | 2012-05-11 19:10:31+00
kbdd | 0.6-4 | 2012-05-12 07:33:32+00
logtop | 0.4.3-1 | 2012-06-05 23:04:20+00
gbemol | 0.3.2-2 | 2012-06-26 17:03:11+00
pidgin-mra | 20100304-1 | 2012-06-29 23:07:41+00
mumudvb | 1.7.1-1 | 2012-06-30 09:12:14+00
libdr-sundown-perl | 0.02-1 | 2012-08-18 10:00:07+00
ztex-bmp | 20120314-2 | 2012-08-18 19:47:55+00
display-dhammapada | 1.0-0.1 | 2012-12-19 12:02:32+00
eot-utils | 1.1-1 | 2013-02-19 17:02:28+00
multiwatch | 1.0.0-rc1+really1.0.0-1 | 2013-02-19 17:02:35+00
pidgin-latex | 1.5.0-1 | 2013-04-04 15:03:43+00
libkeepalive | 0.2-1 | 2013-04-08 22:00:07+00
dfu-programmer | 0.6.1-1 | 2013-04-23 13:32:32+00
libb64 | 1.2-3 | 2013-05-05 21:04:51+00
i810switch | 0.6.5-7.1 | 2013-05-10 13:03:18+00
premake4 | 4.3+repack1-2 | 2013-05-31 12:48:51+00
unagi | 0.3.4-1 | 2013-06-05 11:19:32+00
mod-vhost-ldap | 2.4.0-1 | 2013-07-12 07:19:00+00
libapache2-mod-ldap-userdir | 1.1.19-2.1 | 2013-07-12 21:22:48+00
w9wm | 0.4.2-8 | 2013-07-18 11:49:10+00
vish | 0.0.20130812-1 | 2013-08-12 21:10:37+00
xfishtank | 2.5-1 | 2013-08-20 17:34:06+00
wap-wml-tools | 0.0.4-7 | 2013-08-21 16:19:10+00
ttysnoop | 0.12d-6 | 2013-08-24 17:33:09+00
libkaz | 1.21-2 | 2013-09-02 16:00:10+00
rarpd | 0.981107-9 | 2013-09-02 19:48:24+00
libimager-qrcode-perl | 0.033-1.2 | 2013-09-04 21:06:31+00
dov4l | 0.9+repack-1 | 2013-09-22 19:33:25+00
textdraw | 0.2+ds-0+nmu1 | 2013-10-07 21:25:03+00
gzrt | 0.8-1 | 2013-10-08 06:33:13+00
away | 0.9.5+ds-0+nmu2 | 2013-10-25 01:18:18+00
jshon | 20131010-1 | 2013-11-30 00:00:11+00
libstar-parser-perl | 0.59-4 | 2013-12-23 21:50:43+00
gcal | 3.6.3-3 | 2013-12-29 18:33:29+00
fonts-larabie | 1:20011216-5 | 2014-01-02 21:20:49+00
ccd2iso | 0.3-4 | 2014-01-28 06:33:35+00
kerneltop | 0.91-1 | 2014-02-04 12:03:30+00
vera++ | 1.2.1-2 | 2014-02-04 21:21:37+00
(50 rows)
So there are 8 packages last uploaded to unstable in 2011, 12 packages in 2012 and 26 packages in 2013. I suspect their maintainers need help and we should all offer our assistance. I already contacted two of them and hope the rest of the Debian community will chip in to help too. We should ensure any Debian specific patches are passed upstream if they still exist, that the package is brought up to speed with the latest Debian policy, as well as ensure the source can built with the current compiler set in Debian.
As usual, if you use Bitcoin and want to show your support of my activities, please send Bitcoin donations to my address 15oWEoG9dUPovwmUL9KWAnYRtNJEkP1u1b.