• Diff for "UltimateDebianDatabase"

Translation(s): English - Italiano

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.

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), Packages in NEW queue, DDTP translations.

• Some example queries are provided as CGI scripts, to make it easy for

  • everyone to run them. You can browse them

  or view the source code.

• Database schema: http://udd.debian.org/schema/

• Source code: available in the git repository of the collab-qa project at http://anonscm.debian.org/gitweb/?p=collab-qa/udd.git;a=summary

• Database server: runs on postgres with plperl and postgresql-debversion

For more information, please contact us on #debian-qa or debian-qa@lists.debian.org (mailing list subscription and archives).

Connecting to and using UDD

udd.debian.org is running on ullmann.debian.org. It accepts direct SSLed connections from quantz (qa) and wagner (alioth).

• command-line:

  • psql service=udd

  • or: psql -U guest -h udd.debian.org -p 5452 udd

• Python:

  import psycopg2
  conn = psycopg2.connect(host="udd.debian.org",port=5452,user="guest",database="udd")
  cursor = conn.cursor()
  cursor.execute("SELECT count(*) from sources where release='sid'")
  print cursor.fetchall()[0][0]

• Ruby (DBI): require 'dbi' ; dbh = DBI::connect('DBI:Pg:dbname=udd;port=5452;host=udd.debian.org', 'guest') 

• Ruby (PG): require 'pg'; conn = PG.connect({:host => 'udd.debian.org', :port => 5452, :user => 'guest', :dbname => 'udd'}) 

Credits

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

• Slides from a UDD talk at Debconf9

See also :

• ProjectB

• DDE (Debian Data Export)

SubPages

• CategoryPermalink