Size: 5995
Comment: Update ingress host list as per https://salsa.debian.org/dsa-team/mirror/dsa-puppet/blob/master/modules/ferm/manifests/per_host.pp#L108 via jcristau.
|
Size: 6110
Comment: typos
|
Deletions are marked like this. | Additions are marked like this. |
Line 25: | Line 25: |
'''udd.debian.org''' is running on '''ullmann.debian.org'''. It accepts direct SSLed connections from ''master'', ''coccia'', ''quantz'' (''qa'') and ''respighi'' (''release.debian.org''). | '''udd.debian.org''' is running on '''ullmann.debian.org'''. It accepts direct SSLed connections from ''master'', ''coccia'', ''quantz'' (''qa'') and ''respighi'' (''release'') ([[https://salsa.debian.org/dsa-team/mirror/dsa-puppet/blob/master/modules/ferm/manifests/per_host.pp#L108|firewall config]]). |
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: https://udd.debian.org/schema/
Source code: available in the git repository of the qa project at https://salsa.debian.org/qa/udd
Database server: runs on postgres with plperl and postgresql-debversion
- UDD related services:
Bugs Search: multi-criteria search engine for bugs
Bugs Usertags: search for usertag on bugs
Sponsors Stats gives some statistics about who is sponsoring uploads to Debian
Bapase allows to search for "interesting" packages using various criterias
public UDD mirror allows anyone to query UDD using PostgreSQL command-line or GUI clients
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'") 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'})
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.
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)
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
full dump of the database generated every two days. (~1.1 GB and growing, to be restored using pg_restore. See this script for an example)
See also :
References
Even if its main goal was not to serve as a scientific resarch tool, UDD has been featured in several publications:
Norbert Preining. Analyzing Debian packages with Neo4j. Neo4j Online Meetup. Article parts 1, 2, 3, video
Lucas Nussbaum and Stefano Zacchiroli. The Ultimate Debian Database: Consolidating Bazaar Metadata for Quality Assurance and Data Mining.7th IEEE Working Conference on Mining Software Repositories (MSR'2010)Paper - Slides - HAL
Julius Davies, Hanyu Zhang, Lucas Nussbaum and Daniel M. German.Perspectives on Bugs in the Debian Bug Tracking System 7th IEEE Working Conference on Mining Software Repositories (MSR'2010): Mining Challenge Paper - Slides- HAL
SubPages