|
Size: 1903
Comment: Added how to connect with ptyhon-psycopg2
|
Size: 1538
Comment: .org is now fully functional
|
| Deletions are marked like this. | Additions are marked like this. |
| Line 17: | Line 17: |
| There are currently two UDD instances: udd.debian.'''net''', and udd.debian.'''org'''. We are moving everything to .org, but some bits might still be missing. * To connect to the '''.org instance''': |
* To connect to '''udd.debian.org''': |
| Line 22: | Line 20: |
| * To connect to the '''.net instance''': from either '''master.debian.org''' or '''alioth.debian.org''', using: {{{psql -h udd.debian.net -U guest udd}}} * '''Examples''' of queries: http://udd.debian.net (FIXME: move to .org) * '''Database schema''': http://udd.debian.net/schema/ (FIXME: move to .org) |
* '''Examples''' of queries: http://udd.debian.org * '''Database schema''': http://udd.debian.org/schema/ |
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
More data sources can easily be added (and will be in the near future).
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/
For more information, please contact us on #debian-qa or debian-qa@lists.debian.org.
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.
(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"].