Differences between revisions 92 and 93
Revision 92 as of 2020-02-12 12:31:29
Size: 6393
Comment: direct folks to the mirror
Revision 93 as of 2020-06-29 07:03:20
Size: 6625
Deletions are marked like this. Additions are marked like this.
Line 48: Line 48:
You can '''report bugs''' against the qa.debian.org pseudo-package, using the ''udd'' usertag and user ''qa.debian.org@packages.debian.org''. ([[https://bugs.debian.org/cgi-bin/pkgreport.cgi?tag=udd;users=qa.debian.org@packages.debian.org|list of bugs]]) You can '''report bugs''' against the qa.debian.org pseudo-package, using the ''udd'' usertag and user ''qa.debian.org@packages.debian.org''. ([[https://bugs.debian.org/cgi-bin/pkgreport.cgi?tag=udd;users=qa.debian.org@packages.debian.org|list of bugs]] ; or [[https://udd.debian.org/bugs/?release=na&merged=ign&fusertag=only&fusertagtag=udd&fusertaguser=qa.debian.org%40packages.debian.org&allbugs=1&cseverity=1&ctags=1&sortby=id&sorto=asc&format=html#results|list of bugs using UDD]])

Translation(s): English - Italiano

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

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 master, coccia, quantz (qa) and respighi (release) (firewall config).

  • command-line:
    • psql service=udd

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

  • Python:

    import psycopg2
    conn = psycopg2.connect("service=udd")
    cursor = conn.cursor()
    cursor.execute("SELECT count(*) from sources where release='sid'")
  • 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'}) 

If you want to know precisely when a specific data source is updated, you can take a look at the crontab file. The timestamps table can tell you when a data source was last updated.

If you do not have access to the required machines, you can access the public UDD mirror directly from your own machines:

  • command line:

    psql --host=udd-mirror.debian.net --user=udd-mirror udd --password

    with password "udd-mirror". For quick successes, inspect the database schema on https://udd.debian.org/schema/udd.html. psql shows tables with \dt. Have fun.

Improving UDD

If you want to help improve UDD, you can set up your own instance as described on UltimateDebianDatabase/Hacking. You can report bugs against the qa.debian.org pseudo-package, using the udd usertag and user qa.debian.org@packages.debian.org. (list of bugs ; or list of bugs using UDD)


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 :


Even if the UDD's main goal was not to serve as a scientific research tool, it has been featured in some publications and talks: