--- /dev/null
+Title: Brushing up on old packages in Xiph and Debian
+Tags: english, debian, multimedia, standard, video
+Date: 2025-02-28 16:45
+
+<p>Since my motivation boost in the beginning of the month caused me
+to wrap up a new release of
+<tt><a href="https://xiph.org/oggz/">liboggz</a></tt>, I have used the
+same boost to wrap up new editions of
+<tt><a href="https://xiph.org/fishsound/">libfishsound</a></tt>,
+<tt><a href="https://gitlab.xiph.org/xiph/liboggplay/">liboggplay</a></tt>
+and
+<tt><a href="https://wiki.xiph.org/index.php/OggKate">libkate</a></tt>
+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.</p>
+
+<p>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 <tt>ltnu</tt> script from the
+<tt><a href="https://tracker.debian.org/pkg/devscripts">devscripts</a></tt>
+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 <a href="https://udd.debian.org/">UDD</a> SQL
+query used by ltnu, I ended up with the following command:</p>
+
+<pre>
+#!/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;"
+</pre>
+
+<p>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:</p>
+
+<pre>
+ 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)
+</pre>
+
+<p>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.</p>
+
+<p>As usual, if you use Bitcoin and want to show your support of my
+activities, please send Bitcoin donations to my address
+<b><a href="bitcoin:15oWEoG9dUPovwmUL9KWAnYRtNJEkP1u1b">15oWEoG9dUPovwmUL9KWAnYRtNJEkP1u1b</a></b>.</p>
projects / homepage.git / commitdiff