Duplicate Packages from Debian archive in DMO
Andres Mejia
amejia004 at gmail.com
Thu Mar 22 00:42:19 UTC 2012
On Wed, Mar 21, 2012 at 7:11 PM, Stuart Prescott
<stuart at nanonanonano.net> wrote:
> -----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-----
>
>
>
> _______________________________________________
> pkg-multimedia-maintainers mailing list
> pkg-multimedia-maintainers at lists.alioth.debian.org
> http://lists.alioth.debian.org/cgi-bin/mailman/listinfo/pkg-multimedia-maintainers
Thanks. This really helps.
Could you
--
~ Andres
More information about the pkg-multimedia-maintainers
mailing list