Duplicate Packages from Debian archive in DMO
Andres Mejia
amejia004 at gmail.com
Thu Mar 22 02:11:47 UTC 2012
On Wed, Mar 21, 2012 at 8:42 PM, Andres Mejia <amejia004 at gmail.com> wrote:
> 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
Ah, hit send on the wrong mail and completely forgot about this.
I was going to ask, could you do a query on sid showing the source
packages available in dmo only and in both debian and dmo? I'm still
waiting on the import of the udd to my system.
--
~ Andres
More information about the pkg-multimedia-maintainers
mailing list