Re: Last days before the soft freeze

[Samuel Henrique <samueloph@debian.org>]

For future reference, here's an UDD[0] query to sort our packages by
the last_upload date:

/* pkg-sec old uploads */
select all_sources.source,
       MAX(upload_history.date::date) as last_upload
from all_sources, upload_history
where upload_history.source = all_sources.source and
      all_sources.maintainer_email = 'team+pkg-security@tracker.debian.org' and
      all_sources.release = 'sid'
group by all_sources.source
order by last_upload

These are the result up until 2019:
crack    2018-06-05
openscap-daemon    2018-07-25
scap-security-guide    2018-07-26
bdfproxy    2018-09-11
dsniff    2018-11-05
statsprocessor    2019-07-08
onesixtyone    2019-07-16
doona    2019-08-03
sandsifter    2019-08-05
python-darts.lib.utils.lru    2019-09-04
inetsim    2019-09-05
hashdeep    2019-09-13
swatch    2019-09-15
forensic-artifacts    2019-09-19
dhcpig    2019-09-24
binwalk    2019-10-17
pyaff4    2019-10-20
reglookup    2019-10-27
vinetto    2019-11-12
python-vulndb    2019-11-17
arp-scan    2019-11-27
plaso    2019-11-28
samdump2    2019-11-28
nasty    2019-11-28
libewf    2019-12-03
unhide    2019-12-14
rekall    2019-12-26
ext4magic    2019-12-28

[0] https://wiki.debian.org/UltimateDebianDatabase/

-- 
Samuel Henrique <samueloph>