Re: The Ultimate Debian Database
On 22/07/08 at 23:06 +0200, Christian von Essen wrote:
> On Tue, Jul 22, 2008 at 03:31:58PM -0500, Raphael Geissert wrote:
> >
> > Hi,
> >
> > Is the database structure available somewhere? In a nice presentation format
> > I mean :)
>
> Not yet, as it is not in any way final :)
>
> >
> > The above question is because I don't understand very well why the name of
> > the table in this case is popcon_max; instead of something like popcon
> > where the package's popcon history is stored where the max values could be
> > gathered using MAX()
> >
>
> There is a table named popcon, structured (package, vote, old, recent,
> nofiles). Here package names a binary package.
>
> popcon_max on the other hand has (package, score) as the structure,
> and here package names a source package.
> popcon_max actually is a view. For line (<package>, <score>), <score> is the
> maximum popcon score of all binaries build from source <package>.
Maybe it would make sense to name it popcon_source or popcon_src.
popcon_max is indeed not very clear :-)
--
| Lucas Nussbaum
| lucas@lucas-nussbaum.net http://www.lucas-nussbaum.net/ |
| jabber: lucas@nussbaum.fr GPG: 1024D/023B3F4F |
Reply to: