Re: [UDD] Any reason to drop view all_sources?
Hi,
Thanks for the explanation, I noticed that removal too and switched to sources instead https://salsa.debian.org/williamdes/debian-dashboard/-/commit/93cd0b595da8cf8edd1dfb12a164ae3fae5fc805
That said I am not sure if there was any impact on the data of my Debian dashboard project: https://salsa.debian.org/williamdes/debian-dashboard/-/commit/0464de2026c03847c0309d39832e50ce6aa388b6 and https://salsa.debian.org/williamdes/debian-dashboard/-/commit/14adcae958e0163e5b54f7f851d1f113c63a96d5
To be continued.
--
William Desportes
---- Le Wed, 07 Jan 2026 17:14:36 +0100 tille@debian.org a écrit ----
> Hi Lucas,
>
> > > is there any good reason to "drop view all_sources"[1]. I'm using this
> > > for team-metrics and while I could probably re-implement it somehow I
> > > would like to learn about the motivation first.
> >
> > This also came up on IRC a few days ago.
> >
> > I removed that view because there was no use for it internally (in
> > UDD-hosted tools) and it was a bit painful to update when the sources
> > schema changed.
> >
> > It was defined as the equivalent of:
> > SELECT * FROM sources -- that's Debian's source packages
> > UNION SELECT * FROM ubuntu_sources -- that's Ubuntu's
> > UNION SELECT * FROM derivatives_sources;
>
> Yes.
>
> > What is your use case for it?
>
> The use case was that I was seeking for different spellings of names of
> maintainers and this might happen over all those sources.
>
> > Usually, you don't want to scan through all those sources
> > (Debian+Ubuntu+...) at the same time without differenciating based on
> > the distribution.
>
> Its actually helpful to look beyond Debian for this specific purpose.
> However, I can add that view locally to the UDD clone I'm using for
> this.
>
> > I suspected that you want to use 'sources' instead (or 'sources_uniq' if
> > you prefer to hide some superseded packages that are still in Debian's
> > Sources files).
>
> Using all_sources was intentional (not sure whether we even invented it
> for this purpose at the time when I was starting this). If you think
> pristine UDD is better served without this view I could deal with this.
>
> Kind regards
> Andreas.
>
> --
> https://fam-tille.de[https://fam-tille.de]
Reply to: