udd.debian.org
On this site we show results of queries executed on the Ultimate Debian Database.
layout
The following table layout is used:
This layout is outdated; please look there for a more up-to-date version.
- Debian packages and sources:
- Ubuntu packages and sources:
- Carnivore:
- Upload history:
- Testing migrations
- Bugs:
- View bugs_rt_affects_stable:
- SELECT id, package, source FROM bugs WHERE affects_stable AND (id NOT IN (SELECT id FROM bugs_tags WHERE tag IN ('sid', 'sarge', 'lenny', 'experimental')) OR id IN (SELECT id FROM bugs_tags WHERE tag = 'etch')) AND id NOT IN (select id FROM bugs_tags WHERE tag = 'etch-ignore') AND ( package IN (SELECT DISTINCT package FROM packages_summary p WHERE release = 'etch') OR source IN (SELECT DISTINCT package FROM sources WHERE release = 'etch'))
- View bugs_rt_affects_testing:
- SELECT id, package, source FROM bugs WHERE affects_testing AND (id NOT IN (SELECT id FROM bugs_tags WHERE tag IN ('sid', 'sarge', 'etch', 'experimental')) OR id IN (SELECT id FROM bugs_tags WHERE tag = 'lenny')) AND id NOT IN (select id FROM bugs_tags WHERE tag = 'lenny-ignore') AND ( package IN (SELECT DISTINCT package FROM packages_summary p WHERE release = 'lenny') OR source IN (SELECT DISTINCT package FROM sources WHERE release = 'lenny'))
- View bugs_rt_affects_unstable:
- SELECT id, package, source FROM bugs WHERE affects_unstable AND (id NOT IN (SELECT id FROM bugs_tags WHERE tag IN ('lenny', 'sarge', 'etch', 'experimental')) OR id IN (SELECT id FROM bugs_tags WHERE tag = 'sid')) AND ( package IN (SELECT DISTINCT package FROM packages_summary p WHERE release = 'sid') OR source IN (SELECT DISTINCT package FROM sources WHERE release = 'sid'))
- View bugs_rt_affects_testing_and_unstable:
- SELECT id, package, source FROM bugs WHERE affects_unstable AND affects_testing AND (id NOT IN (SELECT id FROM bugs_tags WHERE tag IN ('sarge', 'etch', 'experimental')) OR (id IN (SELECT id FROM bugs_tags WHERE tag = 'sid') AND id IN (SELECT id FROM bugs_tags WHERE tag = 'lenny'))) AND ( package IN (SELECT DISTINCT package FROM packages p WHERE release = 'sid') OR source IN (SELECT DISTINCT package FROM sources WHERE release = 'sid')) AND ( package IN (SELECT DISTINCT package FROM packages p WHERE release = 'lenny') OR source IN (SELECT DISTINCT package FROM sources WHERE release = 'lenny'))
- Orphaned packages:
- Debian popcon:
- Ubuntu popcon:
- Linitian:
updates
The data in our database is updated as follows:
- bugs: Every second hour of every day
- archived bugs: Every second day, at 11 am
- orphaned packages: Every 6 hours
- popcon data: every day at 5 pm
- ubuntu packages: every day at 7 pm
- upload history: every day at 9 pm
- testing migrations: every day at 11 pm
- debian packages: ssh triggered
- linitian: 10 pm
- carnivore: 10:30 pm
Queries
We do the following queries for now:
- Packages in unstable, but not in testing, sorted by popcon installs
- Sources in unstable, but not in testing, sorted by maximum popcon installs
- Sources in Ubuntu, but not in Debian, sorted by maximum popcon installs
- Number of bugs per package
- Removal candidates
- Number of RC bugs per package
Suggestions?
Please insert any suggestions you may come up with (including an SQL query, if possible)
