[Catalog-sig] Flamenco queries
"Martin v. Löwis"
martin at v.loewis.de
Mon Apr 9 12:00:39 CEST 2007
> Perhaps this?
> select rc.trove_id, count(*)
> from releases r, release_classifiers rc
> where r.name=rc.name and r.version=rc.version
> and r._pypi_hidden=FALSE
> group by rc.trove_id
This did work indeed (although it was slower than when doing
the counting in Python...)
I found that it was semantically incorrect, as packages that
have multiple level-three trove ids should be counted only
I ended up writing a cache for the browse page that gets
regenerated after five minutes (r443).
More information about the Catalog-sig