[rb-general] Database scheme archlinux

[Bernhard M. Wiedemann]

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.

Ciao
Bernhard M.

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 181 bytes
Desc: OpenPGP digital signature
URL: <http://lists.reproducible-builds.org/pipermail/rb-general/attachments/20171120/85156b6b/attachment.sig>