[Buildd-tools-devel] RFC: Creation of a PostgreSQL database schema for wanna-build data

[Roger Leigh]

On Tue, Jan 27, 2009 at 11:58:55AM +0100, Adeodato Simó wrote:
> * Marc Brockschmidt [Mon, 26 Jan 2009 19:25:08 +0100]:
> 
> > >> I'd also like to store the build time and space statistics (currently
> > >> stored by sbuild in a GDBM database) stored here along with the logs.
> 
> > > Ok, I added those as well, but without a NOT NULL restriction, otherwise
> > > it'll be impossible to import old logs. If somebody cares enough, once
> > > we have this DB up and the old logs imported we can run a daily job to
> > > slowly fill in that information, if it's easily retrievable from the log
> > > itself (which I think it is).
> 
> > tail -n 1 on any build log will yield
> > | Build needed $time, $sizek disk space
> > This could (and should) be imported when the old build logs are
> > imported.
> 
> Oh, btw, would it make sense to store the name of the buildd that
> produced the log?

I think so.  Ideally, I'd like this coupled to the built/failed state
in the state table, which already has the buildd user as the builder
making the change.  However, doing this for old logs might be
difficult (but not impossible--all the info is in the log).


Regards,
Roger

-- 
  .''`.  Roger Leigh
 : :' :  Debian GNU/Linux             http://people.debian.org/~rleigh/
 `. `'   Printing on GNU/Linux?       http://gutenprint.sourceforge.net/
   `-    GPG Public Key: 0x25BFB848   Please GPG sign your mail.