Differences between revisions 1 and 32 (spanning 31 versions)
Revision 1 as of 2008-04-23 07:41:20
Size: 552
Comment:
Revision 32 as of 2009-02-12 16:42:13
Size: 1721
Comment: list archives
Deletions are marked like this. Additions are marked like this.
Line 3: Line 3:
Ultimate Debian Database (UDD) for short is an ongoing effort to create a relational database to encode information about Debian items (packages, bugs, popularity, ...). 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.
Line 5: Line 5:
It is currently being worked on as [wiki:SummerOfCode2008/UltimateDebianDatabase Google Summer of Code 2008 project]. 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)
Line 7: Line 17:
This page is for coordination during the project development. More data sources can easily be added (and will be in the near future).
Line 9: Line 19:
== Involved people ==  * To connect to '''udd.debian.org''':
  * From merkel.debian.org or alioth.debian.org: {{{/usr/lib/postgresql/8.3/bin/psql 'service=udd'}}}
  * Same with {{{python-psycopg2}}}: {{{conn = psycopg2.connect(host="localhost",port=5441,user="guest",database="udd")}}}
 * '''Examples''' of queries: http://udd.debian.org
 * '''Database schema''': http://udd.debian.org/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/
Line 11: Line 26:
 * Student: Christian von Essen
 * Mentor: Lucas Nussbaum
   * Co-mentor: Stefano Zacchiroli
   * Co-Mentor: Marc 'HE' Brockschmidt
For more information, please contact us on #debian-qa or debian-qa@lists.debian.org (mailing list [http://lists.debian.org/debian-qa/ 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.

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

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 [http://lists.debian.org/debian-qa/ 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.

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