Re: [UDD] Any reason to drop view all_sources?
Lucas Nussbaum <[email protected]> Wed, 7 Jan 2026 16:19:15 +0100
| Newsgroups | gmane.linux.debian.devel.quality-assurance |
|---|---|
| Message-ID | <[email protected]> |
Hi Andreas, > 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; What is your use case for it? Usually, you don't want to scan through all those sources (Debian+Ubuntu+...) at the same time without differenciating based on the distribution. 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). Lucas