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 (, ), is the > maximum popcon score of all binaries build from source . Maybe it would make sense to name it popcon_source or popcon_src. popcon_max is indeed not very clear :-) -- | Lucas Nussbaum | [EMAIL PROTECTED] http://www.lucas-nussbaum.net/ | | jabber: [EMAIL PROTECTED] GPG: 1024D/023B3F4F | -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
Re: The Ultimate Debian Database
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 (, ), is the maximum popcon score of all binaries build from source . > And are there any plans on developing a, possibly web, interface? > A web interface is planned, yes. > Other than that, nice work :). > > P.S. added some information about DEHS on the wiki page. Thank you. > > Cheers, > -- > Atomo64 - Raphael Christian -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
Re: The Ultimate Debian Database
Christian von Essen wrote: > Hi, Hi, Is the database structure available somewhere? In a nice presentation format I mean :) > > > Or, given a source package, if you want to know the maximum of the popcon > scores of the packages build from that package, you just use the following > query: > > SELECT * FROM popcon_max WHERE package = ''; 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() And are there any plans on developing a, possibly web, interface? Other than that, nice work :). P.S. added some information about DEHS on the wiki page. > > Christian von Essen Cheers, -- Atomo64 - Raphael Please avoid sending me Word, PowerPoint or Excel attachments. See http://www.gnu.org/philosophy/no-word-attachments.html -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
Re: The Ultimate Debian Database
On Tue, Jul 22, 2008 at 05:06:26PM +0200, Christian von Essen wrote: > Hi, > > my name is Christian von Essen and I'm the GSOC student working on the > Ultimate Debian Database project this year. [...] > Feel free to edit the pages if you see fit. I'd be glad to hear about what you > are thinking about the project and its ideas as you are the target users of > the database. Amazing work, thanks! I've added a pointer to the parsed d-d-c archives, just in case. filippo -- Filippo Giunchedi - http://esaurito.net PGP key: 0x6B79D401 random quote follows: Machines take me by surprise with great frequency. -- Alan Turing -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
