• Re: remark about the UDD upload_history table

    From Lucas Nussbaum@21:1/5 to Patrice Duroux on Tue Feb 27 18:40:01 2024
    Hi,

    Le mer. 14 févr. 2024 à 19:36, Patrice Duroux
    <patrice.duroux@gmail.com> a écrit :

    Hi,

    I am a bit surprised with the following output:

    udd=> select distinct distribution from upload_history;
    distribution
    ---------------------------------

    I filed a bug about that, but unfortunately the whole upload_history
    gatherer code is fragile, because it is based on parsing the mailing
    list archives... So I'm not sure this will be fixed at some point.

    On 19/02/24 at 11:15 +0100, Patrice Duroux wrote:
    Hi,

    May I also suggest renaming this 'upload_history.distribution' column
    to 'upload_history.release' for a better consistency with the other
    tables that have the two columns (distribution and release)?

    UDD generally follows the naming from the source data. I agree that
    there's some confusion between distribution and release that requires
    extra care when writing queries, but I don't think that we should change
    that at this point given it would be an API change and there might be
    external consumers of the raw (SQL) data.

    Lucas

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)