552
Comment:
|
2216
|
Deletions are marked like this. | Additions are marked like this. |
Line 1: | Line 1: |
#language en | |
Line 3: | Line 4: |
Ultimate Debian Database (UDD) for short is an ongoing effort to create a relational database to encode information about Debian items (packages, bugs, popularity, ...). | 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. |
Line 5: | Line 6: |
It is currently being worked on as [wiki:SummerOfCode2008/UltimateDebianDatabase Google Summer of Code 2008 project]. | 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) |
Line 7: | Line 18: |
This page is for coordination during the project development. | More data sources can easily be added (and will be in the near future). |
Line 9: | Line 20: |
== Involved people == | * To connect to '''udd.debian.org''': * From merkel.debian.org: {{{/usr/lib/postgresql/8.3/bin/psql 'service=udd'}}} ''Remark: Please note that some commands like for instance'' '''\d''' ''might not work because of accessing a PostgreSQL 8.4 server using a PostgreSQL 8.3 client.'' (see posting on [[http://lists.debian.org/debian-qa/2009/05/msg00035.html|Debian-QA mailing list]]) * From alioth.debian.org: {{{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 [[http://alioth.debian.org/projects/collab-qa/|collab-qa project]] at http://svn.debian.org/viewsvn/collab-qa/udd/ * '''Database server''': runs on postgres with plperl and postgresql-debversion |
Line 11: | Line 30: |
* Student: Christian von Essen * Mentor: Lucas Nussbaum * Co-mentor: Stefano Zacchiroli * Co-Mentor: Marc 'HE' Brockschmidt |
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]]). 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 == * [[/DataSources|data sources]] we want to be injected in the db * [[/udd.debian.net|wiki entry]] on [[http://udd.debian.net]] See also : * [[ProjectB]] * [[DDE]] (Debian Data Export) == SubPages == <<PageList(re:^UltimateDebianDatabase/)>> |
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: /usr/lib/postgresql/8.3/bin/psql 'service=udd'
Remark: Please note that some commands like for instance \d might not work because of accessing a PostgreSQL 8.4 server using a PostgreSQL 8.3 client. (see posting on Debian-QA mailing list)
From alioth.debian.org: 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/
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.
(Old?) Resources
?data sources we want to be injected in the db
?wiki entry on http://udd.debian.net
See also :