Differences between revisions 21 and 22
⇤ ← Revision 21 as of 2008-09-08 09:33:41 →
Size: 1211
Editor: LucasNussbaum
Comment:
← Revision 22 as of 2008-09-18 16:37:50 → ⇥
Size: 1444
Editor: StefanoZacchiroli
Comment:
Deletions are marked like this. Additions are marked like this.
Line 16: Line 16:
Debian Developers and contributors can connect from either '''master.debian.org''' or '''alioth.debian.org''', using:
{{{psql -h udd.debian.net -U guest udd}}}

Example queries: http://udd.debian.net

Database schema: http://udd.debian.net/schema/.		 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/
 * '''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/

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
  • Lintian
  • Orphaned packages
  • Carnivore

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

Some resources about 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 ]