[rb-general] Database scheme archlinux

[Holger Levsen]

hi,

kpcyrd are you subscribed to rb-general or do you still need cc:s?

On Mon, Nov 20, 2017 at 01:42:17PM +0100, Bernhard M. Wiedemann wrote:
> On 2017-11-20 12:34, Holger Levsen wrote:
> >> It seems the scheme is currently explicitly for debian. The pragmatic
> >> idea would be creating a different table for archlinux results to avoid
> >> interfering with other scripts, but I'm open for input here.
> > I like the pragmatic approach here. that said…
> 
> I have an opposing view here.
> 
> I think during the summit mapreri tried adding a 'distribution' field to
> the tables in a test instance and it was not that hard.
> This would avoid duplicating logic for every distribution involved and
> the available fields already cover most use cases we have for openSUSE.
> 
> It would also make it a lot easier to make SQL queries like
> 'what is the reproducibility status of bash in any distribution'
> without any further hacking for every added distribution.
> 
> And if very distribution-specific fields are required for something in
> the future, those could still go into a separate table then.

you convinced me, thanks. I agree with you now, and from private
conversation I know that Mattia also agrees with this.


-- 
cheers,
	Holger
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 833 bytes
Desc: not available
URL: <http://lists.reproducible-builds.org/pipermail/rb-general/attachments/20171122/114775dc/attachment.sig>