[11:58] <cjwatson> wgrant: you said "the usual 3-character threshold" the other day - do you know where that's implemented?  it is, perhaps obviously, near-impossible to search for
[11:59] <wgrant> cjwatson: That's a good question. It could be in the JS picker frontend.
[12:14] <cjwatson> thanks, will hunt
[12:47] <cjwatson> min_search_chars, indeed.
[12:54] <cjwatson> Hm.  This is all very reminiscent of the DSP picker work from 2011 that I tried to resurrect once ... maybe it makes more sense to try to finish that than to continue with the BinaryAndSourcePackageName vocabulary.
[12:55] <cjwatson> SourcePackage.setBranch ensures a DistributionSourcePackage row, so that would be charms-safe.
[13:05]  * cjwatson digs up year-old branch for that and is pleasantly surprised to find it not entirely exploding
[13:05] <wgrant> cjwatson: Still using the updated cache tables, though?
[13:05] <wgrant> DistributionSourcePackageInDatabase doesn't know about binary names AFAICR
[13:06] <cjwatson> The stuff I dug up uses DistributionSourcePackageCache
[13:06] <wgrant> (and the table isn't necessary for DistributionSourcePackage objects)
[13:06] <cjwatson> But it goes through that for binary names rather than using DistroSeriesPackageCache
[13:06] <cjwatson> Which seems potentially likely to perform better; will have to see
[13:08] <cjwatson> I didn't at all understand the constraints at the time I was last working on this (I was just resurrecting some old work by Purple in an attempt to deal with https://bugs.launchpad.net/launchpad/+bug/42298), but there's a query here that's ranking exact source name, exact binary name, partial source name, partial binary name
[13:08] <mup> Bug #42298: package picker lists unpublished (invalid) packages <lp-bugs> <target-picker> <vocabulary> <Launchpad itself:Triaged> <https://launchpad.net/bugs/42298>
[13:09] <cjwatson> cache-aware and archive-aware