Differences between revisions 46 and 47
Revision 46 as of 2010-01-23 08:09:04
Size: 2452
Comment: CategoryPermalink --> http://udd.debian.org
Revision 47 as of 2010-10-27 20:23:09
Size: 2442
Editor: ?David Prévot
Comment: Link update
Deletions are marked like this. Additions are marked like this.
Line 36: Line 36:
 * [[http://perso.ens-lyon.fr/lucas.nussbaum/talks/debconf9-ultimate-debian-database.pdf|Slides from a UDD talk at Debconf9]]  * [[http://www.loria.fr/~lnussbau/files/debconf9-ultimate-debian-database.pdf|Slides from a UDD talk at Debconf9]]

Ultimate Debian Database

Ultimate Debian Database (UDD) gathers a lot of data about various aspects of Debian in the same SQL database. It allows users to easily access and combine all these data.

The data currently being imported include:

  • Packages and Sources files, from Debian and Ubuntu
  • Bugs from the Debian BTS
  • Popularity contest
  • History of uploads
  • History of migrations to testing
  • Lintian
  • Orphaned packages
  • Carnivore
  • Debtags
  • Ubuntu bugs (from Launchpad)

More data sources can easily be added (and will be in the near future).

  • To connect to udd.debian.org:

    • From merkel.debian.org: /usr/lib/postgresql/8.4/bin/psql service=udd

    • From alioth.debian.org: psql service=udd

      • Remark: Please note that some commands like for instance \d might not work because of accessing a PostgreSQL 8.4 server using a PostgreSQL 8.3 client. (see posting on Debian-QA mailing list)

        • You can use: /usr/lib/postgresql/8.4/bin/psql service=udd

    • Same with python-psycopg2: conn = psycopg2.connect(host="localhost",port=5441,user="guest",database="udd")

  • Examples of queries: http://udd.debian.org

  • Database schema: http://udd.debian.org/schema/

  • Source code: available in the SVN of the collab-qa project at http://svn.debian.org/viewsvn/collab-qa/udd/

  • Database server: runs on postgres with plperl and postgresql-debversion

For more information, please contact us on #debian-qa or debian-qa@lists.debian.org (mailing list subscription and archives).

UDD started as a Google Summer of Code project by Christian von Essen (Neronus), co-mentored by Lucas Nussbaum, Stefano Zacchiroli and Marc 'HE' Brockschmidt. It is now mainly maintained by Lucas Nussbaum, with help from others.

Other resources

See also :


?UltimateDebianDatabase/CreateLocalReplica (for some reason this link is not getting auto-generated)