| 1 |
<html>
|
| 2 |
<title>Ultimate Debian Database (UDD)</title>
|
| 3 |
<body>
|
| 4 |
<h1>Ultimate Debian Database (UDD)</h1>
|
| 5 |
<h2>General information</h2>
|
| 6 |
|
| 7 |
<p>Ultimate Debian Database (UDD) gathers a lot of data about various
|
| 8 |
aspects of <a href="http://www.debian.org">Debian</a> in a single SQL
|
| 9 |
database. It allows users to easily access and combine all this data.</p>
|
| 10 |
|
| 11 |
<p>You can have a look at the <a href="http://udd.debian.org/schema/">UDD
|
| 12 |
Schema</a>.</p>
|
| 13 |
|
| 14 |
<p><b>More information about UDD is available at
|
| 15 |
<a href="http://wiki.debian.org/UltimateDebianDatabase"><tt>wiki.debian.org/UltimateDebianDatabase</tt></a>.</b></p>
|
| 16 |
|
| 17 |
<h2>Examples</h2>
|
| 18 |
|
| 19 |
<p>Some example queries are provided as CGI scripts, to make it easy for
|
| 20 |
everyone to run them. You can <a href="cgi-bin/">browse them</a> or <a
|
| 21 |
href="http://svn.debian.org/viewsvn/collab-qa/udd/web/cgi-bin/">view
|
| 22 |
the source code</a>.</p>
|
| 23 |
|
| 24 |
<p>There are also some more complex "applications" using UDD:</p>
|
| 25 |
<ul>
|
| 26 |
<li><a href="cgi-bin/bapase.cgi">Bapase</a> allows to search for "interesting" packages using various criterias</li>
|
| 27 |
<li><a href="cgi-bin/sponsorstats.cgi">SponsorStats</a> gives some statistics about who is sponsoring uploads to Debian</li>
|
| 28 |
</ul>
|
| 29 |
|
| 30 |
<h2>Timing information</h2>
|
| 31 |
|
| 32 |
<p>If you want to know when UDD is being updated, you can check the <a
|
| 33 |
href="crontabs.txt">crontab file</a>. The <i>timestamps</i> table can
|
| 34 |
tell you when a data source was last updated.</p>
|
| 35 |
|
| 36 |
<h2>Database dump</h2>
|
| 37 |
<p>A full dump of the database, generated every two days, is <a href="udd.sql.gz">also available</a>. Be careful, it's quite big (400 MB gzipped, and growing).</p>
|
| 38 |
</body>
|
| 39 |
</html>
|
Parent Directory
| 
Revision Log