[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
once.

I ended up writing a cache for the browse page that gets
regenerated after five minutes (r443).

Regards,
Martin


More information about the Catalog-sig mailing list