On Wed, Mar 21, 2012 at 7:11 PM, Stuart Prescott <stu...@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@lists.alioth.debian.org > http://lists.alioth.debian.org/cgi-bin/mailman/listinfo/pkg-multimedia-maintainers
Thanks. This really helps. Could you -- ~ Andres _______________________________________________ pkg-multimedia-maintainers mailing list pkg-multimedia-maintainers@lists.alioth.debian.org http://lists.alioth.debian.org/cgi-bin/mailman/listinfo/pkg-multimedia-maintainers