On Wed, Mar 21, 2012 at 8:42 PM, Andres Mejia <amejia...@gmail.com> wrote: > 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
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 _______________________________________________ pkg-multimedia-maintainers mailing list pkg-multimedia-maintainers@lists.alioth.debian.org http://lists.alioth.debian.org/cgi-bin/mailman/listinfo/pkg-multimedia-maintainers