Wasim Thabraze

@di How do I find packages that have been taken down - from the database point of view? Is there any flag (`is_removed` or `is_malicious`) in the table?

Okay, So we add the flag to the respective table and we set it to `true` for any projects we want to mark as malicious. If I understand you correctly,...

Gotcha! So we can add the `is_malicious` flag to the `BlacklistedProject` model with default value as `false`. And the API end point would query for the entities of `BlacklistedProject` table...

I'm not working on this @pradyunsg . Feel free to pick it up.

@di Could you please help me in providing me more information about this issue? When I searched for `python2-miio` the results on my local environment were completely different and irrelevant...

Yeah - I was feeling the same. Because now the search queries seems to work as expected. Will do some debugging and check.

@di I presume the issue is because of usage of `lowercase` filter in [normalized_name](https://github.com/pypa/warehouse/blob/b66a37d0f5dd5d77730a1bfa427548aa554c40b5/warehouse/packaging/search.py#L29) which is tokenizing `psycopg2` to `psycopg` and `2` As per Elastic search, > lowercase tokenizer breaks...

Yeah - We should decide on which tokenizer to use. What about `whitespace` tokenizer? I'll check search results accuracy with `whitespace` tokenizer vs `lowercase` tokenizer.

Yes, it is @selotape You can start looking into this issue. Feel free to ping here if you need help with anything.