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

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

There are currently two UDD instances: udd.debian.net, and udd.debian.org. We are moving everything to .org, but some bits might still be missing.

• To connect to the .org instance:

  • From merkel.debian.org or alioth.debian.org: /usr/lib/postgresql/8.3/bin/psql 'service=udd'

• To connect to the .net instance: from either master.debian.org or alioth.debian.org, using: psql -h udd.debian.net -U guest udd

• Examples of queries: http://udd.debian.net (FIXME: move to .org)

• Database schema: http://udd.debian.net/schema/ (FIXME: move to .org)

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

For more information, please contact us on #debian-qa or debian-qa@lists.debian.org.

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.

(Old?) Resources

• [wiki:?/DataSources data sources] we want to be injected in the db

• [wiki:/udd.debian.net wiki entry] on [ http://udd.debian.net ]

See also : ["ProjectB"].