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

[Stephen Gran]

This one time, at band camp, Roger Leigh said:
> Dear all,

<snip good news>

> We would be grateful for any comments you might have, particularly
> if you have used the existing wanna-build and can see any defects,
> omissions, or any suggestions for anything we missed or could
> implement in a more optimal fashion.  If you are a PostgreSQL guru,
> a review of the PL/pgSQL and PL/Perl functions and triggers used
> for custom constraint checking would be much appreciated.

I am not a dak hacker, nor an ftpteam or wanna-build guy.  That being
said, it looks like a lot of the information you store and the functions
for comparison look an awful lot like the stuff dak currently has.  Does
it make sense to consolidate, and expand dak to handle the extra things
you need it to do?  It could presumably go in a seperate schema with
grants and so on so that permissions can be kept sensible - all of this
would need to be worked out with the ftpteam people.  It's just that I
get sad every time I see needless duplication of information in
databases :)

Cheers,
-- 
 -----------------------------------------------------------------
|   ,''`.                                            Stephen Gran |
|  : :' :                                        sgran at debian.org |
|  `. `'                        Debian user, admin, and developer |
|    `-                                     http://www.debian.org |
 -----------------------------------------------------------------
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: Digital signature
Url : http://lists.alioth.debian.org/pipermail/buildd-tools-devel/attachments/20090117/dcd96ad2/attachment.pgp