Duplicate Packages from Debian archive in DMO
Stuart Prescott
stuart at nanonanonano.net
Wed Mar 21 23:11:27 UTC 2012
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Hi all,
Just to put some real data on packages that are in both Debian and
debian-multimedia.org I extracted the appended data from UDD.
I suspect that many will find inclusion of packages like libdrm-intel1
and libdrm2 somewhat beyond the "multimedia" calling of this repository.
In terms of shear size of the repository:
release | binary_packages | source_packages
- --------------------+-----------------+-----------------
sid-multimedia | 298 | 128
wheezy-multimedia | 306 | 134
squeeze-multimedia | 331 | 151
lenny-multimedia | 256 | 120
which is certainly consistent with the feedback that packages are
dropped from dmm as they become available in Debian and that the
position is much better for wheezy than squeeze.
Please feel free to let me know if there is further data from UDD that
would be useful here.
cheers
Stuart
Squeeze:
package | debian_version | dmm_version
- --------------------+--------------------------+------------------------------------
audacity | 1.3.12-6 | 1.3.12-7.4
audacity-data | 1.3.12-6 | 1.3.12-7.4
audacity-dbg | 1.3.12-6 | 1.3.12-7.4
blender | 2.49.2~dfsg-2+b2 | 2.49.2~dfsg-2.1
dir2ogg | 0.11.8-1 | 0.9.3-0.0
ffmpeg | 4:0.5.6-3 | 5:0.7.11-0.1
ffmpeg-dbg | 4:0.5.6-3 | 5:0.7.11-0.1
ffmpeg-doc | 4:0.5.6-3 | 5:0.7.11-0.1
i965-va-driver | 1.0.1-3 | 1.0.7-0.0
icecast2 | 2.3.2-6 | 1:2.3.2kh29-0.4squeeze1
kdenlive | 0.7.8-1 | 0.7.8-1.2
kdenlive-data | 0.7.8-1 | 0.7.8-1.2
kdenlive-dbg | 0.7.8-1 | 0.7.8-1.2
libavcodec52 | 4:0.5.6-3 | 5:0.7.11-0.1
libavcodec-dev | 4:0.5.6-3 | 5:0.7.11-0.1
libavdevice52 | 4:0.5.6-3 | 5:0.7.11-0.1
libavdevice-dev | 4:0.5.6-3 | 5:0.7.11-0.1
libavfilter-dev | 4:0.5.6-3 | 5:0.7.11-0.1
libavformat52 | 4:0.5.6-3 | 5:0.7.11-0.1
libavformat-dev | 4:0.5.6-3 | 5:0.7.11-0.1
libavutil-dev | 4:0.5.6-3 | 5:0.7.11-0.1
libdrm2 | 2.4.21-1~squeeze3 | 2.4.23-0.0
libdrm2-dbg | 2.4.21-1~squeeze3 | 2.4.23-0.0
libdrm-dev | 2.4.21-1~squeeze3 | 2.4.23-0.0
libdrm-intel1 | 2.4.21-1~squeeze3 | 2.4.23-0.0
libdrm-intel1-dbg | 2.4.21-1~squeeze3 | 2.4.23-0.0
libdrm-radeon1 | 2.4.21-1~squeeze3 | 2.4.23-0.0
libdrm-radeon1-dbg | 2.4.21-1~squeeze3 | 2.4.23-0.0
libmlt++3 | 0.5.6+git20100727-1 | 1:0.6.2-0.0
libmlt-data | 0.5.6+git20100727-1 | 1:0.6.2-0.0
libmlt-dev | 0.5.6+git20100727-1 | 1:0.6.2-0.0
libmlt++-dev | 0.5.6+git20100727-1 | 1:0.6.2-0.0
libpostproc51 | 4:0.5.6-3 | 5:0.7.11-0.1
libpostproc-dev | 4:0.5.6-3 | 5:0.7.11-0.1
libquicktime1 | 2:1.1.5-1+b1 | 3:1.2.2-0.3squeeze1
libquicktime-dev | 2:1.1.5-1+b1 | 3:1.2.2-0.3squeeze1
libquicktime-doc | 2:1.1.5-1 | 3:1.2.2-0.3squeeze1
libswscale0 | 4:0.5.6-3 | 5:0.7.11-0.1
libswscale-dev | 4:0.5.6-3 | 5:0.7.11-0.1
libva1 | 1.0.1-3 | 1.0.7-0.0
libva-dev | 1.0.1-3 | 1.0.7-0.0
libva-x11-1 | 1.0.1-3 | 1.0.7-0.0
libvpx0 | 0.9.1-2 | 0.9.7.p1-2.squeeze2
libvpx0-dbg | 0.9.1-2 | 0.9.7.p1-2.squeeze2
libvpx-dev | 0.9.1-2 | 0.9.7.p1-2.squeeze2
libvpx-doc | 0.9.1-2 | 0.9.7.p1-2.squeeze2
melt | 0.5.6+git20100727-1 | 1:0.6.2-0.0
mencoder | 2:1.0~rc3++final.dfsg1-1 | 2:1.0~rc3++svn20100804-0.2squeeze1
mplayer | 2:1.0~rc3++final.dfsg1-1 | 2:1.0~rc3++svn20100804-0.2squeeze1
mplayer-doc | 2:1.0~rc3++final.dfsg1-1 | 2:1.0~rc3++svn20100804-0.2squeeze1
quicktime-utils | 2:1.1.5-1+b1 | 3:1.2.2-0.3squeeze1
quicktime-x11utils | 2:1.1.5-1+b1 | 3:1.2.2-0.3squeeze1
vainfo | 1.0.1-3 | 1.0.7-0.0
(53 rows)
Sid:
package | debian_version | dmm_version
- --------------------------+-------------------------------+-----------------------------
ffmpeg-dbg | 4:0.8.1-1 | 5:0.10.2-0.0
ffmpeg-doc | 4:0.8.1-1 | 5:0.10.2-0.0
gpac | 0.4.5+svn3462~dfsg0-1 | 1:0.4.6~svn20120228-0.0
gstreamer0.10-ffmpeg | 0.10.13-2 | 1:0.10.13-0.2
gstreamer0.10-ffmpeg-dbg | 0.10.13-2 | 1:0.10.13-0.2
icecast2 | 2.3.2-9 | 1:2.3.2kh31-0.0
ices2 | 2.0.1-10 | 1:2.0kh60a-0.1
kdenlive | 0.8.2.1-2 | 1:0.8.2.1-0.0
kdenlive-data | 0.8.2.1-2 | 1:0.8.2.1-0.0
kdenlive-dbg | 0.8.2.1-2 | 1:0.8.2.1-0.0
lame | 3.99.5+repack1-3 | 1:3.99.5-0.0
lame-doc | 3.99.5+repack1-3 | 1:3.99.5-0.0
libavcodec53 | 4:0.8.1-1 | 5:0.10.2-0.0
libavcodec-dev | 4:0.8.1-1 | 5:0.10.2-0.0
libavdevice53 | 4:0.8.1-1 | 5:0.10.2-0.0
libavdevice-dev | 4:0.8.1-1 | 5:0.10.2-0.0
libavfilter2 | 4:0.8.1-1 | 5:0.10.2-0.0
libavfilter-dev | 4:0.8.1-1 | 5:0.10.2-0.0
libavformat53 | 4:0.8.1-1 | 5:0.10.2-0.0
libavformat-dev | 4:0.8.1-1 | 5:0.10.2-0.0
libavutil51 | 4:0.8.1-1 | 5:0.10.2-0.0
libavutil-dev | 4:0.8.1-1 | 5:0.10.2-0.0
libgpac1 | 0.4.5+svn3462~dfsg0-1 | 1:0.4.6~svn20120228-0.0
libgpac-dev | 0.4.5+svn3462~dfsg0-1 | 1:0.4.6~svn20120228-0.0
libgtkpod1 | 2.1.1-1 | 1:2.1.1-0.1
libgtkpod-dev | 2.1.1-1 | 1:2.1.1-0.1
libmlt++3 | 0.7.8-2 | 1:0.7.8-0.1
libmlt4 | 0.7.8-2 | 1:0.7.8-0.1
libmlt-data | 0.7.8-2 | 1:0.7.8-0.1
libmlt-dev | 0.7.8-2 | 1:0.7.8-0.1
libmlt++-dev | 0.7.8-2 | 1:0.7.8-0.1
libmp3lame0 | 3.99.5+repack1-3 | 1:3.99.5-0.0
libmp3lame-dev | 3.99.5+repack1-3 | 1:3.99.5-0.0
libmp4v2-dev | 1.9.1+svn479~dfsg0-3 | 2:1.9.1-0.9
libpostproc52 | 4:0.8.1-1 | 5:0.10.2-0.0
libpostproc-dev | 4:0.8.1-1 | 5:0.10.2-0.0
libswscale2 | 4:0.8.1-1 | 5:0.10.2-0.0
libswscale-dev | 4:0.8.1-1 | 5:0.10.2-0.0
libvlc5 | 2.0.0-6 | 1:2.0.1-0.0
libvlccore5 | 2.0.0-6 | 1:2.0.1-0.0
libvlccore-dev | 2.0.0-6 | 1:2.0.1-0.0
libvlc-dev | 2.0.0-6 | 1:2.0.1-0.0
libx264-120 | 2:0.120.2171+git01f7a33-3 | 3:0.120.2164+gitda19765-0.0
libx264-dev | 2:0.120.2171+git01f7a33-3 | 3:0.122.2184+git5c85e0a-0.0
libxine1 | 1.1.20.1-3 | 1:1.1.20.1-0.1
libxine1-all-plugins | 1.1.20.1-3 | 1:1.1.20.1-0.1
libxine1-bin | 1.1.20.1-3 | 1:1.1.20.1-0.1
libxine1-console | 1.1.20.1-3 | 1:1.1.20.1-0.1
libxine1-dbg | 1.1.20.1-3 | 1:1.1.20.1-0.1
libxine1-doc | 1.1.20.1-3 | 1:1.1.20.1-0.1
libxine1-ffmpeg | 1.1.20.1-3 | 1:1.1.20.1-0.1
libxine1-gnome | 1.1.20.1-3 | 1:1.1.20.1-0.1
libxine1-misc-plugins | 1.1.20.1-3 | 1:1.1.20.1-0.1
libxine1-plugins | 1.1.20.1-3 | 1:1.1.20.1-0.1
libxine1-x | 1.1.20.1-3 | 1:1.1.20.1-0.1
libxine2 | 1.2.1-1 | 1:1.2.1-0.1
libxine2-all-plugins | 1.2.1-1 | 1:1.2.1-0.1
libxine2-bin | 1.2.1-1 | 1:1.2.1-0.1
libxine2-console | 1.2.1-1 | 1:1.2.1-0.1
libxine2-dbg | 1.2.1-1 | 1:1.2.1-0.1
libxine2-dev | 1.2.1-1 | 1:1.2.1-0.1
libxine2-doc | 1.2.1-1 | 1:1.2.1-0.1
libxine2-ffmpeg | 1.2.1-1 | 1:1.2.1-0.1
libxine2-gnome | 1.2.1-1 | 1:1.2.1-0.1
libxine2-misc-plugins | 1.2.1-1 | 1:1.2.1-0.1
libxine2-plugins | 1.2.1-1 | 1:1.2.1-0.1
libxine2-vdr | 1.2.1-1 | 1:1.2.1-0.1
libxine2-x | 1.2.1-1 | 1:1.2.1-0.1
libxine-dev | 1.1.20.1-3 | 1:1.1.20.1-0.1
libxvidcore4 | 2:1.3.2-9 | 3:1.3.2-0.4
libxvidcore-dev | 2:1.3.2-9 | 3:1.3.2-0.4
melt | 0.7.8-2 | 1:0.7.8-0.1
mencoder | 2:1.0~rc4.dfsg1+svn34540-1+b1 | 3:1.0~rc4+svn20120313-0.0
mp4v2-utils | 1.9.1+svn479~dfsg0-3 | 2:1.9.1-0.9
mplayer | 2:1.0~rc4.dfsg1+svn34540-1+b1 | 3:1.0~rc4+svn20120313-0.0
mplayer2 | 2.0-426-gc32b3ed-2 | 1:2.0~git20120313-0.1
mplayer-doc | 2:1.0~rc4.dfsg1+svn34540-1 | 3:1.0~rc4+svn20120313-0.0
python-mlt3 | 0.7.8-2 | 1:0.7.8-0.1
transcode | 3:1.1.7-2 | 4:1.1.7-0.3
transcode-doc | 3:1.1.7-2 | 4:1.1.7-0.3
vlc | 2.0.0-6 | 1:2.0.1-0.0
vlc-data | 2.0.0-6 | 1:2.0.1-0.0
vlc-dbg | 2.0.0-6 | 1:2.0.1-0.0
vlc-nox | 2.0.0-6 | 1:2.0.1-0.0
vlc-plugin-fluidsynth | 2.0.0-6 | 1:2.0.1-0.0
vlc-plugin-jack | 2.0.0-6 | 1:2.0.1-0.0
vlc-plugin-notify | 2.0.0-6 | 1:2.0.1-0.0
vlc-plugin-pulse | 2.0.0-6 | 1:2.0.1-0.0
vlc-plugin-sdl | 2.0.0-6 | 1:2.0.1-0.0
vlc-plugin-svg | 2.0.0-6 | 1:2.0.1-0.0
vlc-plugin-zvbi | 2.0.0-6 | 1:2.0.1-0.0
x264 | 2:0.120.2171+git01f7a33-3 | 3:0.122.2184+git5c85e0a-0.0
(92 rows)
- -------------------------------------------------
(Note: the UDD instance used here is the one we have for #debian into which we
have injected dmm's Packages and Sources files because end-user-support
has historically lead many users there; udd.debian.org does not include this
3rd party repository. Apologies also for the sort of SQL that makes DBAs cry)
SELECT
p.package,
p.version AS debian_version,
pmm.version AS dmm_version
FROM packages AS p
JOIN packages AS pmm ON
p.package = pmm.package AND
p.architecture = pmm.architecture
WHERE
p.release='squeeze' AND
pmm.release='squeeze-multimedia' AND
p.architecture IN ('i386', 'all')
ORDER BY p.package;
SELECT
p.package,
p.version AS debian_version,
pmm.version AS dmm_version
FROM packages AS p
JOIN packages AS pmm ON
p.package = pmm.package AND
p.architecture = pmm.architecture
WHERE
p.release='sid' AND
pmm.release='sid-multimedia' AND
p.architecture IN ('i386', 'all')
ORDER BY p.package;
SELECT release, COUNT(*)
FROM packages
WHERE
release LIKE '%-multimedia' AND
architecture IN ('i386', 'all')
GROUP BY release;
SELECT release, COUNT(*)
FROM sources
WHERE
release LIKE '%-multimedia'
GROUP BY release;
SELECT
bins.release,
bins.cnt AS binary_packages,
srcs.cnt AS source_packages
FROM
(
SELECT release, COUNT(*) AS cnt
FROM packages
WHERE
release LIKE '%-multimedia' AND
architecture IN ('i386', 'all')
GROUP BY release
) AS bins
JOIN (
SELECT release, COUNT(*) AS cnt
FROM sources
WHERE
release LIKE '%-multimedia'
GROUP BY release
) AS srcs
ON bins.release = srcs.release;
- --
Stuart Prescott www.nanoNANOnano.net
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.10 (GNU/Linux)
iEYEARECAAYFAk9qYB8ACgkQn+i4zXHF0agjtQCfRa6VD7qUzSr+xfypZyOkzynh
KIcAnRaxd1eoGH3vtu+wPh2nwPboB6ay
=hUPu
-----END PGP SIGNATURE-----
More information about the pkg-multimedia-maintainers
mailing list