Skip to content

upstream freshness status (uscan/watch)

It would be kind of nice to see how up to date Debian is, in general. I know of https://qa.debian.org/cgi-bin/watch but that gives only results per package. https://qa.debian.org/developer.php also gives that information, but per developer, and doesn't do sums...

i guess, as usual, UDD could be used to extract some of that information, but that doesn't give us historical information. this is, nevertheless, the magic query, from what i gathered:

udd=> SELECT status, COUNT(status), ROUND(100.0 * COUNT(*) / SUM(COUNT(*)) OVER ()) AS percent FROM upstream GROUP BY status ORDER BY count DESC;
            status            | count | percent 
------------------------------+-------+---------
 up to date                   | 21597 |      59
 newer package available      |  6542 |      18
 error                        |  4124 |      11
 only older package available |   856 |       2
 package available            |    10 |       0
                              |     0 |       9
(6 lignes)

we're 59% up to date! (assuming the "error" ones are out of date of course)...