|
Size: 1758
Comment: Adding pointer to DDE
|
Size: 1756
Comment: converted to 1.6 markup
|
| Deletions are marked like this. | Additions are marked like this. |
| Line 24: | Line 24: |
| * '''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/ | * '''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/ |
| Line 26: | Line 26: |
| For more information, please contact us on #debian-qa or debian-qa@lists.debian.org (mailing list [http://lists.debian.org/debian-qa/ subscription and archives]). | For more information, please contact us on #debian-qa or debian-qa@lists.debian.org (mailing list [[http://lists.debian.org/debian-qa/|subscription and archives]]). |
| Line 32: | Line 32: |
| * [wiki:/DataSources data sources] we want to be injected in the db * [wiki:/udd.debian.net wiki entry] on [ http://udd.debian.net ] |
* [[/DataSources|data sources]] we want to be injected in the db * [[/udd.debian.net|wiki entry]] on [ http://udd.debian.net ] |
| Line 36: | Line 36: |
| * ["ProjectB"] * ["DDE"] (Debian Data Export) |
* [[ProjectB]] * [[DDE]] (Debian Data Export) |
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)
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 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 (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.
(Old?) Resources
?data sources we want to be injected in the db
?wiki entry on [ http://udd.debian.net ]
See also :