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 this data.
The data currently being imported includes:
- Packages and Sources files, from Debian and Ubuntu
- Bugs from the Debian BTS
- Popularity contest
- History of uploads
- History of migrations to testing
- Orphaned packages
More data sources can easily be added (and will be in the near future).
Some resources about UDD:
How to connect: Debian Developers and contributors can connect 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
Database schema: http://udd.debian.net/schema/
For more information, please contact us on #debian-qa or firstname.lastname@example.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.