|
Size: 2283
Comment:
|
Size: 2811
Comment:
|
| Deletions are marked like this. | Additions are marked like this. |
| Line 27: | Line 27: |
| * To connect to '''udd.debian.org''': * From quantz.debian.org: {{{psql service=udd}}} * From alioth.debian.org: {{{psql service=udd}}} * Same with {{{python-psycopg2}}}: {{{conn = psycopg2.connect(host="localhost",port=5441,user="guest",database="udd")}}} |
== 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'}) }}} |
Translation(s): English - Italiano
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)
- Packages in NEW queue
- DDTP translations
More data sources can easily be added (and will be in the near future).
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'})
Examples of queries: http://udd.debian.org
Database schema: http://udd.debian.org/schema/
Source code: available in the SVN of the collab-qa project at http://svn.debian.org/viewsvn/collab-qa/udd/
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).
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 :
SubPages