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 [email protected] 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]
