[arch-dev-public] Website updated- package maintainer changes
Dan McGee
dpmcgee at gmail.com
Tue Mar 30 03:00:05 CEST 2010
On Mon, Mar 29, 2010 at 2:06 AM, Pierre Schmitz <pierre at archlinux.de> wrote:
> Am Montag, 29. März 2010 00:01:03 schrieb Dan McGee:
>> Let me (and the list) know if you have any questions.
>
> Thanks for your work! Just one suggestion: Would it be possible to chagne the
> pacakge list view on the dev site to just operate on pkgbase and ignore the
> different pkgnames and architectures? This would managing package assignments
> and orphans a lot easier.
Agreed, I'll keep that in mind as I work on the website in the coming
weeks. Until then, here is that magic list.
mysql> select count(*), r.name, p.pkgbase, username from packages p
left join repos r on p.repo_id = r.id left join
packages_packagerelation pr on p.pkgbase = pr.pkgbase left join
auth_user u on pr.user_id = u.id where username is NULL and p.repo_id
in (1,2) group by r.name, p.pkgbase, username order by r.name,
p.pkgbase, count(*);
+----------+-------+------------------------------------+----------+
| count(*) | name | pkgbase | username |
+----------+-------+------------------------------------+----------+
| 2 | Core | bridge-utils | NULL |
| 1 | Core | filesystem | NULL |
| 1 | Core | ipw2100-fw | NULL |
| 1 | Core | ipw2200-fw | NULL |
| 1 | Core | iwlwifi-3945-ucode | NULL |
| 1 | Core | iwlwifi-4965-ucode | NULL |
| 1 | Core | iwlwifi-5000-ucode | NULL |
| 1 | Core | iwlwifi-5150-ucode | NULL |
| 2 | Core | libevent | NULL |
| 2 | Core | libgssglue | NULL |
| 2 | Core | libsasl | NULL |
| 2 | Core | libtirpc | NULL |
| 1 | Core | netcfg | NULL |
| 2 | Core | rfkill | NULL |
| 1 | Core | rt2x00-rt61-fw | NULL |
| 1 | Core | rt2x00-rt71w-fw | NULL |
| 1 | Core | tiacx-firmware | NULL |
| 1 | Core | wireless-regdb | NULL |
| 1 | Core | zd1211-firmware | NULL |
| 2 | Extra | 3ddesktop | NULL |
| 2 | Extra | aalib | NULL |
| 2 | Extra | abuse | NULL |
| 2 | Extra | acct | NULL |
| 1 | Extra | acidrip | NULL |
| 2 | Extra | afterstep | NULL |
| 2 | Extra | agg | NULL |
| 1 | Extra | aif | NULL |
| 2 | Extra | alltray | NULL |
| 2 | Extra | anthy | NULL |
| 2 | Extra | apollon | NULL |
| 2 | Extra | arch | NULL |
| 1 | Extra | archlinux-artwork | NULL |
| 2 | Extra | arj | NULL |
| 2 | Extra | at | NULL |
| 2 | Extra | aubio | NULL |
| 2 | Extra | audacious | NULL |
| 2 | Extra | audacious-plugins | NULL |
| 2 | Extra | aufs2 | NULL |
| 1 | Extra | autoconf2.13 | NULL |
| 2 | Extra | autofs | NULL |
| 2 | Extra | avahi | NULL |
| 2 | Extra | bc | NULL |
| 2 | Extra | beep | NULL |
| 2 | Extra | bigloo | NULL |
| 2 | Extra | biogrep | NULL |
| 2 | Extra | biopython | NULL |
| 2 | Extra | bitlbee | NULL |
| 2 | Extra | bittorrent | NULL |
| 2 | Extra | blassic | NULL |
| 2 | Extra | bomberclone | NULL |
| 2 | Extra | bonnie++ | NULL |
| 1 | Extra | bootchart | NULL |
| 2 | Extra | botan | NULL |
| 2 | Extra | brltty | NULL |
| 2 | Extra | btrfs-progs-unstable | NULL |
| 2 | Extra | c-ares | NULL |
| 2 | Extra | came | NULL |
| 2 | Extra | ccrtp | NULL |
| 2 | Extra | ccscript3 | NULL |
| 2 | Extra | cdcd | NULL |
| 1 | Extra | cddb_get | NULL |
| 2 | Extra | cdlabelgen | NULL |
| 4 | Extra | cdrdao | NULL |
| 2 | Extra | cdrkit | NULL |
| 2 | Extra | cdtool | NULL |
| 2 | Extra | cegui | NULL |
| 2 | Extra | centerim | NULL |
| 2 | Extra | cfitsio | NULL |
| 2 | Extra | clamav | NULL |
| 2 | Extra | cmt | NULL |
| 2 | Extra | colortail | NULL |
| 2 | Extra | corewars | NULL |
| 2 | Extra | cpudyn | NULL |
| 2 | Extra | cpufreqd | NULL |
| 2 | Extra | crimson | NULL |
| 2 | Extra | cssed | NULL |
| 1 | Extra | culmus | NULL |
| 2 | Extra | cvs | NULL |
| 2 | Extra | cvsps | NULL |
| 2 | Extra | cx_freeze | NULL |
| 2 | Extra | cyrus-sasl | NULL |
| 2 | Extra | cyrus-sasl-plugins | NULL |
| 2 | Extra | dbh | NULL |
| 2 | Extra | devil | NULL |
| 2 | Extra | dia | NULL |
| 1 | Extra | ding | NULL |
| 2 | Extra | distcc | NULL |
| 2 | Extra | django | NULL |
| 1 | Extra | docbook-xsl | NULL |
| 2 | Extra | dssi | NULL |
| 2 | Extra | dvdbackup | NULL |
| 2 | Extra | eboard | NULL |
| 2 | Extra | ed2k-gtk-gui | NULL |
| 1 | Extra | eigen | NULL |
| 2 | Extra | eject | NULL |
| 2 | Extra | elinks | NULL |
| 2 | Extra | enigma | NULL |
| 2 | Extra | etherape | NULL |
| 2 | Extra | ethstatus | NULL |
| 2 | Extra | evms | NULL |
| 2 | Extra | fastjar | NULL |
| 2 | Extra | fcgi | NULL |
| 2 | Extra | fcitx | NULL |
| 2 | Extra | feh | NULL |
| 2 | Extra | festival | NULL |
| 1 | Extra | festival-awb-arctic | NULL |
| 1 | Extra | festival-don | NULL |
| 1 | Extra | festival-kallpc16k | NULL |
| 1 | Extra | festival-rablpc16k | NULL |
| 2 | Extra | fftw2 | NULL |
| 2 | Extra | figlet | NULL |
| 2 | Extra | flite | NULL |
| 2 | Extra | fluidsynth | NULL |
| 1 | Extra | font-bh-ttf | NULL |
| 2 | Extra | fox | NULL |
| 2 | Extra | fsarchiver | NULL |
| 2 | Extra | gcal | NULL |
| 2 | Extra | gcin | NULL |
| 2 | Extra | gcombust | NULL |
| 2 | Extra | gdeskcal | NULL |
| 2 | Extra | gdesklets | NULL |
| 2 | Extra | gdk-pixbuf | NULL |
| 2 | Extra | gdome2 | NULL |
| 2 | Extra | gift | NULL |
| 2 | Extra | gift-fasttrack | NULL |
| 2 | Extra | gift-gnutella | NULL |
| 2 | Extra | gift-openft | NULL |
| 2 | Extra | gimp-fourier | NULL |
| 2 | Extra | glabels | NULL |
| 2 | Extra | glade | NULL |
| 2 | Extra | glew | NULL |
| 2 | Extra | gmencoder | NULL |
| 2 | Extra | gmpc | NULL |
| 2 | Extra | gnash-common | NULL |
| 2 | Extra | gnash-gtk | NULL |
| 1 | Extra | gnome-blog | NULL |
| 2 | Extra | gnomeicu | NULL |
| 2 | Extra | gnugo | NULL |
| 2 | Extra | gocr | NULL |
| 2 | Extra | gpart | NULL |
| 2 | Extra | gperf | NULL |
| 2 | Extra | graveman | NULL |
| 1 | Extra | gsfonts | NULL |
| 2 | Extra | gtick | NULL |
| 2 | Extra | gtk-smooth-engine | NULL |
| 2 | Extra | gtk-vnc | NULL |
| 2 | Extra | gtkam | NULL |
| 2 | Extra | gtkglarea | NULL |
| 2 | Extra | gtklp | NULL |
| 2 | Extra | gtkterm | NULL |
| 2 | Extra | gweled | NULL |
| 2 | Extra | gxine | NULL |
| 2 | Extra | haskell-mtl | NULL |
| 2 | Extra | haskell-network | NULL |
| 2 | Extra | haskell-packedstring | NULL |
| 2 | Extra | haskell-regex-compat | NULL |
| 2 | Extra | hdf5 | NULL |
| 2 | Extra | hdup | NULL |
| 2 | Extra | hexcurse | NULL |
| 2 | Extra | hping | NULL |
| 1 | Extra | hsqldb-java | NULL |
| 1 | Extra | httplib2 | NULL |
| 2 | Extra | httptunnel | NULL |
| 2 | Extra | httrack | NULL |
| 2 | Extra | hugs98 | NULL |
| 2 | Extra | icmake | NULL |
| 2 | Extra | id3lib | NULL |
| 2 | Extra | ilmbase | NULL |
| 2 | Extra | imap | NULL |
| 2 | Extra | imwheel | NULL |
| 2 | Extra | iptraf | NULL |
| 2 | Extra | ipvsadm | NULL |
| 2 | Extra | irda-utils | NULL |
| 1 | Extra | itext | NULL |
| 2 | Extra | jack | NULL |
| 2 | Extra | jade | NULL |
| 2 | Extra | jed | NULL |
| 2 | Extra | joe | NULL |
| 2 | Extra | john | NULL |
| 2 | Extra | jpilot | NULL |
| 2 | Extra | junit | NULL |
| 2 | Extra | kdelibs3 | NULL |
| 1 | Extra | koffice-l10n-fy | NULL |
| 1 | Extra | koffice-l10n-hne | NULL |
| 1 | Extra | koffice-l10n-wa | NULL |
| 2 | Extra | ladspa | NULL |
| 2 | Extra | lesstifextensions | NULL |
| 2 | Extra | libchewing | NULL |
| 2 | Extra | libdvdcss | NULL |
| 2 | Extra | libdvdnav | NULL |
| 2 | Extra | libdvdread | NULL |
| 2 | Extra | libexif-gtk | NULL |
| 2 | Extra | libffi | NULL |
| 2 | Extra | libflashsupport | NULL |
| 2 | Extra | libftdi | NULL |
| 2 | Extra | libhangul | NULL |
| 2 | Extra | libieee1284 | NULL |
| 2 | Extra | libixp | NULL |
| 2 | Extra | liblo | NULL |
| 2 | Extra | liblqr | NULL |
| 2 | Extra | libmad | NULL |
| 2 | Extra | libmal | NULL |
| 2 | Extra | libmcs | NULL |
| 2 | Extra | libmodplug | NULL |
| 2 | Extra | libmowgli | NULL |
| 2 | Extra | libmp4v2 | NULL |
| 2 | Extra | libmusepack | NULL |
| 2 | Extra | libnet | NULL |
| 2 | Extra | libnids | NULL |
| 2 | Extra | libnjb | NULL |
| 2 | Extra | libotf | NULL |
| 2 | Extra | libots | NULL |
| 2 | Extra | libpqxx | NULL |
| 2 | Extra | libproxy | NULL |
| 2 | Extra | libsexymm | NULL |
| 2 | Extra | libticonv | NULL |
| 1 | Extra | libui-sh | NULL |
| 2 | Extra | libvisual-projectm | NULL |
| 2 | Extra | libzip | NULL |
| 2 | Extra | libzrtpcpp | NULL |
| 2 | Extra | lincity | NULL |
| 2 | Extra | linuxdcpp | NULL |
| 2 | Extra | linux_logo | NULL |
| 2 | Extra | lsof | NULL |
| 2 | Extra | ltrace | NULL |
| 2 | Extra | lua | NULL |
| 2 | Extra | luola | NULL |
| 2 | Extra | lxsplit | NULL |
| 2 | Extra | lynx | NULL |
| 2 | Extra | lzo | NULL |
| 2 | Extra | m17n-db | NULL |
| 2 | Extra | m17n-lib | NULL |
| 2 | Extra | mailman | NULL |
| 2 | Extra | mcrypt | NULL |
| 1 | Extra | memtest86+ | NULL |
| 2 | Extra | mhash | NULL |
| 2 | Extra | mime-types | NULL |
| 2 | Extra | mod_fastcgi | NULL |
| 2 | Extra | mod_fcgid | NULL |
| 2 | Extra | mod_python | NULL |
| 2 | Extra | mod_wsgi | NULL |
| 2 | Extra | monotone | NULL |
| 2 | Extra | moon-buggy | NULL |
| 2 | Extra | moon-lander | NULL |
| 2 | Extra | most | NULL |
| 2 | Extra | motion | NULL |
| 2 | Extra | mp3blaster | NULL |
| 2 | Extra | mrxvt | NULL |
| 2 | Extra | mtr | NULL |
| 2 | Extra | muse | NULL |
| 1 | Extra | namcap | NULL |
| 2 | Extra | ne | NULL |
| 2 | Extra | netkit-bsd-finger | NULL |
| 2 | Extra | netpbm | NULL |
| 2 | Extra | netselect | NULL |
| 2 | Extra | nilfs-utils | NULL |
| 2 | Extra | nss-mdns | NULL |
| 2 | Extra | nss_ldap | NULL |
| 2 | Extra | ntop | NULL |
| 2 | Extra | nvclock | NULL |
| 2 | Extra | opencv | NULL |
| 2 | Extra | opengtl | NULL |
| 2 | Extra | opensp | NULL |
| 2 | Extra | oxygen-icons | NULL |
| 2 | Extra | pacbuild | NULL |
| 2 | Extra | pal | NULL |
| 2 | Extra | pam_ldap | NULL |
| 2 | Extra | patchutils | NULL |
| 2 | Extra | pebrot | NULL |
| 1 | Extra | perl-appconfig | NULL |
| 1 | Extra | perl-carp-clan | NULL |
| 1 | Extra | perl-date-calc | NULL |
| 1 | Extra | perl-file-desktopentry | NULL |
| 1 | Extra | perl-file-tail | NULL |
| 1 | Extra | perl-html-template | NULL |
| 1 | Extra | perl-io-socket-ssl | NULL |
| 1 | Extra | perl-libwww | NULL |
| 1 | Extra | perl-log-log4perl | NULL |
| 2 | Extra | perl-mail-spf | NULL |
| 2 | Extra | perl-mail-spf-query | NULL |
| 1 | Extra | perl-mime-lite | NULL |
| 1 | Extra | perl-mime-types | NULL |
| 2 | Extra | perl-net-dns-resolver-programmable | NULL |
| 1 | Extra | perl-net-server | NULL |
| 1 | Extra | perl-yaml | NULL |
| 2 | Extra | pinball | NULL |
| 1 | Extra | pkgstats | NULL |
| 2 | Extra | planner | NULL |
| 2 | Extra | potrace | NULL |
| 2 | Extra | povray | NULL |
| 2 | Extra | prelink | NULL |
| 2 | Extra | privoxy | NULL |
| 2 | Extra | projectm | NULL |
| 2 | Extra | pure-ftpd | NULL |
| 2 | Extra | putty | NULL |
| 1 | Extra | pylint | NULL |
| 2 | Extra | pyqt3 | NULL |
| 2 | Extra | python-cheetah | NULL |
| 2 | Extra | python-egenix-mx-base | NULL |
| 2 | Extra | python-eyed3 | NULL |
| 2 | Extra | python-formencode | NULL |
| 1 | Extra | python-gdata | NULL |
| 2 | Extra | python-geoip | NULL |
| 1 | Extra | python-logilab-astng | NULL |
| 1 | Extra | python-logilab-common | NULL |
| 2 | Extra | python-m2crypto | NULL |
| 2 | Extra | python-mpd | NULL |
| 2 | Extra | python-nose | NULL |
| 2 | Extra | python-notify | NULL |
| 2 | Extra | python-numeric | NULL |
| 2 | Extra | python-numpy | NULL |
| 1 | Extra | python-opengl | NULL |
| 2 | Extra | python-pygame | NULL |
| 2 | Extra | python-pysqlite | NULL |
| 2 | Extra | python-qscintilla | NULL |
| 1 | Extra | python-sqlobject | NULL |
| 2 | Extra | python-vpython | NULL |
| 2 | Extra | pyvorbis | NULL |
| 2 | Extra | pyxml | NULL |
| 2 | Extra | qgit | NULL |
| 2 | Extra | qjackctl | NULL |
| 2 | Extra | qof | NULL |
| 2 | Extra | qscintilla-qt3 | NULL |
| 2 | Extra | qstat | NULL |
| 2 | Extra | qsynth | NULL |
| 2 | Extra | qt3 | NULL |
| 2 | Extra | qt3-doc | NULL |
| 2 | Extra | quilt | NULL |
| 2 | Extra | razor | NULL |
| 2 | Extra | rbldnsd | NULL |
| 2 | Extra | rcs | NULL |
| 2 | Extra | re2c | NULL |
| 2 | Extra | recode | NULL |
| 2 | Extra | rep-gtk | NULL |
| 2 | Extra | revelation | NULL |
| 2 | Extra | rockdodger | NULL |
| 2 | Extra | root-tail | NULL |
| 2 | Extra | rosegarden | NULL |
| 2 | Extra | rpmunpack | NULL |
| 2 | Extra | rssh | NULL |
| 4 | Extra | ruby | NULL |
| 2 | Extra | sawfish | NULL |
| 2 | Extra | sbackup | NULL |
| 2 | Extra | schedtool | NULL |
| 2 | Extra | scim | NULL |
| 2 | Extra | scim-anthy | NULL |
| 2 | Extra | scim-chewing | NULL |
| 2 | Extra | scim-hangul | NULL |
| 2 | Extra | scim-m17n | NULL |
| 2 | Extra | scim-pinyin | NULL |
| 2 | Extra | scim-tables | NULL |
| 2 | Extra | scim-uim | NULL |
| 2 | Extra | scons | NULL |
| 2 | Extra | screem | NULL |
| 2 | Extra | setuptools | NULL |
| 2 | Extra | sg3_utils | NULL |
| 2 | Extra | sharutils | NULL |
| 2 | Extra | slib | NULL |
| 1 | Extra | slmodem | NULL |
| 1 | Extra | slmodem-utils | NULL |
| 2 | Extra | smc | NULL |
| 2 | Extra | smtpprox | NULL |
| 2 | Extra | snarf | NULL |
| 2 | Extra | snd | NULL |
| 2 | Extra | snes9x | NULL |
| 2 | Extra | socat | NULL |
| 2 | Extra | sox | NULL |
| 2 | Extra | spamassassin-spamc | NULL |
| 2 | Extra | spidermonkey | NULL |
| 2 | Extra | squashfs-tools | NULL |
| 2 | Extra | ssmtp | NULL |
| 2 | Extra | stardict | NULL |
| 2 | Extra | swatch | NULL |
| 2 | Extra | sweep | NULL |
| 2 | Extra | swh-plugins | NULL |
| 2 | Extra | swi-prolog | NULL |
| 2 | Extra | swig | NULL |
| 2 | Extra | swt | NULL |
| 2 | Extra | sylpheed | NULL |
| 2 | Extra | synergy | NULL |
| 2 | Extra | talloc | NULL |
| 2 | Extra | tcdr | NULL |
| 2 | Extra | tcptraceroute | NULL |
| 2 | Extra | texi2html | NULL |
| 2 | Extra | thttpd | NULL |
| 2 | Extra | tin | NULL |
| 2 | Extra | tomboy | NULL |
| 2 | Extra | tomcat | NULL |
| 2 | Extra | tor | NULL |
| 2 | Extra | tpb | NULL |
| 2 | Extra | transcode | NULL |
| 2 | Extra | transset | NULL |
| 2 | Extra | trayer | NULL |
| 2 | Extra | tsocks | NULL |
| 1 | Extra | ttf-arphic-ukai | NULL |
| 2 | Extra | ttf-arphic-uming | NULL |
| 2 | Extra | ttf-fireflysung | NULL |
| 2 | Extra | ttf-freebanglafont | NULL |
| 1 | Extra | ttf-freefont | NULL |
| 2 | Extra | ttf-indic-otf | NULL |
| 2 | Extra | ttf-isabella | NULL |
| 1 | Extra | ttf-junicode | NULL |
| 1 | Extra | ttf-khmer | NULL |
| 2 | Extra | ttf-linux-libertine | NULL |
| 2 | Extra | ttf-mph-2b-damase | NULL |
| 1 | Extra | ttf-thai | NULL |
| 2 | Extra | ttf-tibetan-machine | NULL |
| 2 | Extra | ttf-ubraille | NULL |
| 2 | Extra | twinkle | NULL |
| 2 | Extra | uim | NULL |
| 2 | Extra | uml_utilities | NULL |
| 2 | Extra | unarj | NULL |
| 2 | Extra | unixodbc | NULL |
| 2 | Extra | v86d | NULL |
| 2 | Extra | vacation | NULL |
| 2 | Extra | valkyrie | NULL |
| 2 | Extra | vconfig | NULL |
| 2 | Extra | viewglob | NULL |
| 1 | Extra | vim-buftabs | NULL |
| 2 | Extra | virtuoso | NULL |
| 2 | Extra | vnc | NULL |
| 2 | Extra | w3m | NULL |
| 2 | Extra | webalizer | NULL |
| 1 | Extra | wine | NULL |
| 2 | Extra | wipe | NULL |
| 2 | Extra | wireshark | NULL |
| 2 | Extra | wmii | NULL |
| 2 | Extra | wmix | NULL |
| 2 | Extra | words | NULL |
| 2 | Extra | worker | NULL |
| 2 | Extra | wpa_supplicant_gui | NULL |
| 2 | Extra | wput | NULL |
| 2 | Extra | wvdial | NULL |
| 2 | Extra | wvstreams | NULL |
| 2 | Extra | x11vnc | NULL |
| 2 | Extra | x2vnc | NULL |
| 2 | Extra | xarchiver | NULL |
| 2 | Extra | xbill | NULL |
| 2 | Extra | xbl | NULL |
| 2 | Extra | xboard | NULL |
| 2 | Extra | xclip | NULL |
| 2 | Extra | xdialog | NULL |
| 2 | Extra | xdrawchem | NULL |
| 2 | Extra | xemacs | NULL |
| 2 | Extra | xemacs-base | NULL |
| 2 | Extra | xemacs-sumo | NULL |
| 2 | Extra | xerces2-java | NULL |
| 1 | Extra | xfce4-artwork | NULL |
| 2 | Extra | xfsdump | NULL |
| 2 | Extra | xmahjongg | NULL |
| 1 | Extra | xorg-fonts-cyrillic | NULL |
| 1 | Extra | xorg-fonts-misc | NULL |
| 1 | Extra | xorg-fonts-type1 | NULL |
| 2 | Extra | xosd | NULL |
| 2 | Extra | xournal | NULL |
| 1 | Extra | xpdf-arabic | NULL |
| 1 | Extra | xpdf-chinese-simplified | NULL |
| 1 | Extra | xpdf-chinese-traditional | NULL |
| 1 | Extra | xpdf-cyrillic | NULL |
| 1 | Extra | xpdf-greek | NULL |
| 1 | Extra | xpdf-hebrew | NULL |
| 1 | Extra | xpdf-japanese | NULL |
| 1 | Extra | xpdf-korean | NULL |
| 1 | Extra | xpdf-latin2 | NULL |
| 1 | Extra | xpdf-thai | NULL |
| 1 | Extra | xpdf-turkish | NULL |
| 2 | Extra | xplc | NULL |
| 2 | Extra | xqf | NULL |
| 2 | Extra | xskat | NULL |
| 2 | Extra | xtermcontrol | NULL |
| 2 | Extra | xzgv | NULL |
| 2 | Extra | yasm | NULL |
| 2 | Extra | yodl | NULL |
| 2 | Extra | yp-tools | NULL |
| 2 | Extra | ypbind-mt | NULL |
| 2 | Extra | ypserv | NULL |
| 1 | Extra | zsnes | NULL |
| 2 | Extra | zvbi | NULL |
+----------+-------+------------------------------------+----------+
478 rows in set (0.23 sec)
More information about the arch-dev-public
mailing list