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. I lifted the UDD SQL +query used by ltnu from the script and adjusted it slightly to end 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.
+