Differences between revisions 28 and 29
Revision 28 as of 2008-12-29 15:49:26
Size: 1903
Editor: EnricoZini
Comment: Added how to connect with ptyhon-psycopg2
Revision 29 as of 2009-01-06 12:19:41
Size: 1538
Comment: .org is now fully functional
Deletions are marked like this. Additions are marked like this.
Line 17: Line 17:
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''':
 * To connect to '''udd.debian.org''':
Line 22: Line 20:
 * 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)
 * '''Examples''' of queries: http://udd.debian.org
 * '''Database schema''': http://udd.debian.org/schema/

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

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"].