-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Hi Andres,
> Thanks. This really helps.
glad to be of assistance :)
> 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.
The naive answer to this question would turn up source package names that
are different between the Debian and dmo archives as dmo has been adding "-
dmo" to source packages to distinguish them from the Debian variant. There
would also be libav vs ffmpeg differences.
So, I've not actually answered that question directly but instead some
slightly different ones that I hope are what you really wanted to know:
* What packages are in Debian and dmo that have the same name or have
"-'dmo" added to them? (Note that ffmpeg-dmo and xbmc-dmo both exist without
a non-"-dmo" source package existing in Debian)
* What source packages in dmo are building binary packages with the same
package names as binary packages in Debian?
* What source packages in dmo are building binary packages that are not in
Debian?
The third of these questions turns up:
* packages like acroread that I guess will never be in Debian
* various multimedia packages that might one day be in Debian
* variations on multimedia packages that introduce extra binary packages (I
guess ffmpeg-dmo producing libswresample* and mp4v2-dmo producing mp4-utils
packages perhaps fall into this category)
* boring soname changes on libraries like x264-dmo producing libx264-122
I suspect that sifting through these different cases probably requires a
person with knowledge of the Debian packages rather than more SQL.
Results (and SQL) attached. Let me know if there are further queries I can
help with.
cheers
Stuart
- --
Stuart Prescott www.nanoNANOnano.net
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.10 (GNU/Linux)
iEYEARECAAYFAk9rLPgACgkQn+i4zXHF0ait8ACdH1ufHnTR5X9v2GZp5NoMqGkZ
BIMAn04BPp6WB/4tR6Rx/HGnbiXfyyXT
=wYRo
-----END PGP SIGNATURE-----
## Source packages that are in both archives with same name
source | debian_version | dmm_version
----------+----------------+-------------
rar | 2:4.0.b3-1 | 2.80-2.1
xvidcore | 2:1.3.2-8 | 3:1.3.2-0.4
xvidcore | 2:1.3.2-9 | 3:1.3.2-0.4
(3 rows)
## Source packages that are in both archives with a *-dmo variant
source | debian_version | dmm_version
----------------------+----------------------------+-----------------------------
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
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
lame | 3.99.5+repack1-3 | 1:3.99.5-0.0
mlt | 0.7.8-2 | 1:0.7.8-0.1
mp4v2 | 1.9.1+svn479~dfsg0-3 | 2:1.9.1-0.9
mplayer | 2:1.0~rc4.dfsg1+svn34540-1 | 3:1.0~rc4+svn20120313-0.0
mplayer2 | 2.0-426-gc32b3ed-2 | 1:2.0~git20120313-0.1
transcode | 3:1.1.7-2 | 4:1.1.7-0.3
vlc | 2.0.0-6 | 1:2.0.1-0.0
x264 | 2:0.120.2171+git01f7a33-3 | 3:0.122.2184+git5c85e0a-0.0
xine-lib | 1.1.20.1-3 | 1:1.1.20.1-0.1
xine-lib-1.2 | 1.2.1-1 | 1:1.2.1-0.1
(15 rows)
## Source packages in dmo that build binary packages with the same name as
Debian packages
debian_source | dmm_source | debian_version
| dmm_version |
package_overlap
----------------------+--------------------------+-------------------------------+-----------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
gpac | gpac-dmo | 0.4.5+svn3462~dfsg0-1
| 1:0.4.6~svn20120228-0.0 | libgpac-dev,gpac,libgpac1
gstreamer0.10-ffmpeg | gstreamer0.10-ffmpeg-dmo | 0.10.13-2
| 1:0.10.13-0.2 | gstreamer0.10-ffmpeg,gstreamer0.10-ffmpeg-dbg
gtkpod | gtkpod-aac | 2.1.1-1
| 1:2.1.1-0.1 | libgtkpod-dev,libgtkpod1
icecast2 | icecast2-dmo | 2.3.2-9
| 1:2.3.2kh31-0.0 | icecast2
ices2 | ices2-dmo | 2.0.1-10
| 1:2.0kh60a-0.1 | ices2
kdenlive | kdenlive-dmo | 0.8.2.1-2
| 1:0.8.2.1-0.0 | kdenlive-dbg,kdenlive-data,kdenlive
lame | lame-dmo | 3.99.5+repack1-3
| 1:3.99.5-0.0 | lame,libmp3lame-dev,libmp3lame0,lame-doc
libav | ffmpeg-dmo | 4:0.8.1-1
| 5:0.10.2-0.1 |
libavfilter2,ffmpeg-doc,ffmpeg-dbg,libswscale2,libswscale-dev,libpostproc52,libpostproc-dev,libavutil51,libavutil-dev,libavformat53,libavformat-dev,libavfilter-dev,libavdevice53,libavdevice-dev,libavcodec53,libavcodec-dev
mlt | mlt-dmo | 0.7.8-2
| 1:0.7.8-0.1 |
libmlt++-dev,libmlt-dev,libmlt++3,libmlt4,melt,python-mlt3,libmlt-data
mp4v2 | mp4v2-dmo | 1.9.1+svn479~dfsg0-3
| 2:1.9.1-0.9 | mp4v2-utils,libmp4v2-dev
mplayer | mplayer-dmo | 2:1.0~rc4.dfsg1+svn34540-1
| 3:1.0~rc4+svn20120313-0.0 | mplayer-doc
mplayer | mplayer-dmo |
2:1.0~rc4.dfsg1+svn34540-1+b1 | 3:1.0~rc4+svn20120313-0.0 | mplayer,mencoder
mplayer2 | mplayer2-dmo | 2.0-426-gc32b3ed-2
| 1:2.0~git20120313-0.1 | mplayer2
transcode | transcode-dmo | 3:1.1.7-2
| 4:1.1.7-0.3 | transcode-doc,transcode
vlc | vlc-dmo | 2.0.0-6
| 1:2.0.1-0.0 |
vlc-plugin-sdl,vlc,vlc-dbg,vlc-nox,vlc-plugin-fluidsynth,vlc-plugin-jack,vlc-data,vlc-plugin-zvbi,vlc-plugin-svg,libvlccore5,libvlccore-dev,libvlc5,libvlc-dev,vlc-plugin-notify,vlc-plugin-pulse
x264 | x264-dmo | 2:0.120.2171+git01f7a33-3
| 3:0.120.2164+gitda19765-0.0 | libx264-120
x264 | x264-dmo | 2:0.120.2171+git01f7a33-3
| 3:0.122.2184+git5c85e0a-0.0 | x264,libx264-dev
xine-lib | xine-lib-dmo | 1.1.20.1-3
| 1:1.1.20.1-0.1 |
libxine1,libxine1-bin,libxine1-console,libxine1-x,libxine1-misc-plugins,libxine-dev,libxine1-plugins,libxine1-doc,libxine1-all-plugins,libxine1-dbg,libxine1-ffmpeg,libxine1-gnome
xine-lib-1.2 | xine-lib-1.2-dmo | 1.2.1-1
| 1:1.2.1-0.1 |
libxine2,libxine2-dev,libxine2-dbg,libxine2-console,libxine2-bin,libxine2-gnome,libxine2-misc-plugins,libxine2-vdr,libxine2-x,libxine2-plugins,libxine2-doc,libxine2-all-plugins,libxine2-ffmpeg
xvidcore | xvidcore | 2:1.3.2-9
| 3:1.3.2-0.4 | libxvidcore-dev,libxvidcore4
(20 rows)
## Source packages from dmm that build binary packages not in Debian
source | version |
missing_debian_packages
----------------------------+-----------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
2mandvd | 1.7.3-0.0 | 2mandvd,2mandvd-data
aacgain | 1.9-0.2 | aacgain
aacplusenc | 0.17.5-0.0 | aacplusenc
aacskeys | 0.4.0c-0.3 | aacskeys
acroread-debian-files | 9.4.7 |
acroread-debian-files
adobe-fontspack-jpn | 9.1.0-0.3 | acroread-fonts-jpn
adobereader-enu | 9.4.7-0.1 |
acroread,mozilla-acroread,acroread-l10n-en,acroread-data,acroread-dictionary-en,acroread-plugins,acroread-plugin-speech,acroread-escript
advancemenu | 2.5.0-0.5 | advancemenu
aften | 0.0.8svn20100103-0.0 |
libaften-dev,aften,libaften0
amrenc | 0.5.2-0.1 | amrenc
autopano-sift-c | 2.5.1-0.1 | autopano-sift-c
avidemux | 1:2.5.6-0.3 |
avidemux-cli,avidemux-plugins,avidemux-qt,avidemux,avidemux-common
bdsup2sub | 4.0.0-0.0 | bdsup2sub
bdvmdbg | 0.1.5-0.1 | bdvmdbg
bombono-dvd | 1.2.1-0.2 |
bombono-dvd-data,bombono-dvd
ccextractor | 0.61-0.0 | ccextractor
chaplin | 1.10-0.3 | chaplin
cinelerra | 4.3-0.0 |
cinelerra,cinelerra-doc,cinelerra-data
cinelerra-cv | 2.1.5-0.9 |
libquicktimehv-dev,cinelerra-cv,libmpeg3hv-1.5.0-1,cinelerra-cv-doc,cinelerra-cv-data,libmpeg3hv-dev,libquicktimehv-1.6.0-1
cutmp3 | 2.1-0.0 | cutmp3
darkice-full | 1.1-0.1 | darkice-full
debian-multimedia-keyring | 2010.12.26 |
debian-multimedia-keyring
devede | 3.21.0-0.0 | devede
divxenc | 1.6.5-0.0 | divxenc
dumphd | 0.61-0.4 | dumphd
dv2sub | 0.3-0.1 | dv2sub
dvd95 | 1:1.6p0-0.0 | dvd95
dvdrip | 1:0.98.11-0.0 | dvdrip
dvdrip-doc | 2:0.98.11-0.0 | dvdrip-doc
dvdrip-queue | 0.1.3-0.3 | dvdrip-queue
dvdshrink | 2.6.1.11-0.1 | xdvdshrink
dvd-slideshow | 0.8.4.2-0.3 | dvd-slideshow
dvdwizard | 0.7.1-0.0 | dvdwizard
easytag-aac | 2.1.7-0.0 | easytag-aac
event-execflow | 0.64-0.0 |
libevent-execflow-perl
faac | 1.28-0.7 |
libfaac0,faac,libfaac-dev
ffmpeg-dmo | 5:0.10.2-0.1 |
libswresample0,libswresample-dev
flash-player | 3:11.1.102.63-0.0 |
flashplayer-mozilla,kde-config-flash-player
foobnix | 2.5.35-0.0 | foobnix
freeme2 | 0.4-1.2 | freeme2
grip | 3.3.1-15.3 | grip
gst-plugins-really-bad | 0.10.23-0.0 |
gstreamer0.10-plugins-really-bad
gtk2-ex-formfactory | 0.67-0.0 |
gtk2-ex-formfactory-perl
gtkpod-aac | 1:2.1.1-0.1 |
gtkpod-aac-data,gtkpod-aac
h264enc | 9.4.4-0.0 | h264enc
handbrake | 0.9.6-0.1 |
handbrake-cli,handbrake-gtk
libaacplus | 2.0.2-0.2 |
libaacplus-dbg,libaacplus2,libaacplus-dev
libdvbcsa | 1.1.0-0.1 |
libdvbcsa1,libdvbcsa-dev
libdvdcss | 1.2.12-0.0 |
libdvdcss2,libdvdcss-dev
libfame | 0.9.1-0.6 |
libfame-dev,libfame-0.9-1
libmkv | 0.6.5.1-0.1 | libmkv-dev,libmkv0
libtxc-dxtn | 1.0.1-0.3 |
libtxc-dxtn0,libtxc-dxtn-dev
lxdvdrip | 1.77-0.0 | lxdvdrip
lxsplit | 0.2.4-0.0 | lxsplit
m2vrequantiser | 1.1-0.0 | m2vrequantiser
m4baker | 0.1.91-0.2 | m4baker
mjpegtools | 1:2.0.0-0.5 |
libmjpegtools-dev,mjpegtools,libmjpegtools-2.0-0
mlt-dmo | 1:0.7.8-0.1 |
libmlt-perl,libmlt-ruby,libmlt-ruby1.9.1
mod-musicindex-aac | 1.3.5-0.2 |
libapache2-mod-musicindex-aac
monkeys-audio | 3.99-u4-b5-0.1 |
libmac2,libmac-dev,monkeys-audio
mp4tools | 0.6.8-0.1 | mp4tools
mp4v2-dmo | 2:1.9.1-0.9 | libmp4v2-1,mp4-utils
mpglen | 0.0.2-0.2 | mpglen
mplayer-dmo | 3:1.0~rc4+svn20120313-0.0 | mplayer-nogui
mythplugins | 0.24.2-0.0 |
mytharchive,mythplugins,mythzoneminder,mythnetvision-data,mytharchive-data,mythweather,mythvideo,mythnews,mythnetvision,mythmusic,mythgame,mythgallery,mythbrowser
mythstream | 0.21+svn-r21640-0.4 | mythstream
myththemes | 0.24+fixes20110828-0.0 | mythtv-themes
mythtv | 0.24.2-0.1 |
libmythtv-perl,mythtv,mythtv-common,mythtv-database,mythtv-doc,mythtv-perl,python-mythtv,libmyth-0.24-0,libmyth-dev,libmythavcodec52,libmythavcore0,libmythavdevice52,libmythavfilter1,libmythavformat52,libmythavutil50,libmythpostproc51,libmythswscale0,mythffmpeg,mythtv-backend,mythtv-frontend
mythweb | 0.24+fixes20111226-0.0 | mythweb
nuvexport | 0.5~git20101231-0.0 | nuvexport
ocaml-aacplus | 0.2.0-0.1 |
libaacplus-ocaml-dynlink,libaacplus-ocaml-dev,libaacplus-ocaml
ogmrip | 0.13.7-0.0 |
ogmrip,libogmrip-dev,libogmrip1,ogmrip-doc
ogmrip-ac3 | 0.2-0.2 | ogmrip-ac3
ogmrip-dirac | 0.1-0.4 | ogmrip-dirac
ogmrip-mpeg | 0.2-0.3 | ogmrip-mpeg
ogmrip-nero-aac | 0.4-0.1 | ogmrip-nero-aac
ogmrip-oggz | 0.2-0.1 | ogmrip-oggz
ogmrip-profiles | 0.2-0.1 | ogmrip-profiles
ogmrip-video-copy | 0.3-0.1 | ogmrip-video-copy
pbmpcd | 0.20071119-0.2 | bemused-mpc
pgmfindclip | 1.13-0.2 | pgmfindclip
plug | 1.0-0.0 | plug
plugin-brightness-contrast | 0.4-0.2 |
kino-brightness-contrast-plugin
plugin-hsv-color-space | 0.4-0.2 |
kino-hsv-color-space-plugin
project-x | 0.91.0-0.1 | project-x
qdvdauthor | 1:2.3.0-0.0 |
qdvdauthor,qdvdauthor-data
qdvdauthor-templates | 1.11.0-0.0 | qdvdauthor-templates
qhimdtransfer | 1:0.1.0~git2385a9b-0.1 | qhimdtransfer
rar | 2.80-2.1 | rar-2.80
ripmake | 1.39-0.3 | ripmake
rubyripper | 0.6.2-0.0 | rubyripper
shorten | 3.6.1-0.2 | shorten
smile | 1.0-0.2 | smile,smile-data
smillaenlarger | 0.8.9-0.0 | smillaenlarger
smplayer2 | 0.0+20120304-0.0 |
smplayer2-common,smplayer2
submux-dvd | 0.5.2-0.0 | submux-dvd
subtitleripper | 0.3.4-0.7 | subtitleripper
tablet-encode | 2.30-0.1 | tablet-encode
telxcc | 0.git20120217-0.0 | telxcc
transcode-dmo | 4:1.1.7-0.3 | transcode-utils
tsmuxer | 1.10.6-0.0 | tsmuxer
tsmuxergui | 1.9.9-0.0 | tsmuxergui
ttaenc | 3.4.1-0.1 | ttaenc
videoporama | 0.8.2-0.0 | videoporama
videotrans | 1.6.1-0.0 | videotrans
w32codecs | 1:20110131-0.1 | w32codecs
x264-dmo | 3:0.122.2184+git5c85e0a-0.0 | libx264-122
xbmc-dmo | 11.0~rc2-0.1 |
xbmc-data,xbmc,xbmc-bin,xbmc-eventclients-wiiremote,xbmc-eventclients-common,xbmc-eventclients-dev,xbmc-eventclients-j2me,xbmc-eventclients-ps3,xbmc-skin-confluence,xbmc-standalone
xcutmp3 | 1.2-0.0 | xcutmp3
xvattr | 1.3-0.8 | xvattr
xvid4conf | 1.12-0.2 | xvid4conf
xvidcap | 1.1.7-0.10 | xvidcap
xvidenc | 8.4.3-0.0 | xvidenc
y4mscaler | 9.0-0.2 | y4mscaler
(114 rows)
-- Source packages that are in both archives with same name
SELECT
s.source,
s.version AS debian_version,
smm.version AS dmm_version
FROM sources AS s
JOIN sources AS smm ON
s.source = smm.source
WHERE
s.release='sid' AND
smm.release='sid-multimedia'
ORDER BY s.source;
-- Source packages that are in both archives with a *-dmo variant
SELECT
s.source,
s.version AS debian_version,
smm.version AS dmm_version
FROM sources AS s
JOIN sources AS smm ON
smm.source = s.source || '-dmo'
WHERE
s.release='sid' AND
smm.release='sid-multimedia'
ORDER BY s.source;
-- Source packages in dmo that build binary packages with the same name as Debian packages
SELECT
p.source AS debian_source,
pmm.source AS dmm_source,
p.version AS debian_version,
pmm.version AS dmm_version,
array_to_string(array_agg(p.package), E',') AS package_overlap
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')
GROUP BY p.source, p.version, pmm.source, pmm.version;
-- Source packages from dmm that build binary packages not in Debian
SELECT
source,
version,
array_to_string(array_agg(package), E',') AS missing_debian_packages
FROM packages
WHERE
release='sid-multimedia' AND
architecture IN ('i386', 'all') AND
package NOT IN (
SELECT package
FROM packages
WHERE release='sid' AND architecture IN ('i386', 'all')
)
GROUP BY source, version;
_______________________________________________
pkg-multimedia-maintainers mailing list
[email protected]
http://lists.alioth.debian.org/cgi-bin/mailman/listinfo/pkg-multimedia-maintainers
