Differences between revisions 49 and 50
Revision 49 as of 2011-04-16 20:43:15
Size: 2449
Editor: ?mdt
Revision 50 as of 2011-06-13 15:13:31
Size: 2133
Deletions are marked like this. Additions are marked like this.
Line 22: Line 22:
  * 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 [[http://lists.debian.org/debian-qa/2009/05/msg00035.html|Debian-QA mailing list]])
    You can use: {{{/usr/lib/postgresql/8.4/bin/psql service=udd}}}
  * From alioth.debian.org: {{{psql -h localhost -p 5441 -U guest udd}}}

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).

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)