Search filters put 'Programming Language :: Python :: N :: Only' checkboxes in an odd place

[bskinn]

The search-filter checkboxes are sorting the Programming Language :: Python :: N :: Only checkboxes below all of the respective N.n checkboxes, instead of placing them immediately below the N checkboxes:

This is highly nonintuitive, at least to me.

This may be low priority given that, e.g., #2442 and/or #3462 would presumably change the UI considerably.

[waseem18]

I second this. Only checkbox is a bit confusing. As @bskinn mentioned we should probably place Only below 2 and 3.

[Cheukting]

@nlhkabu do you want me to have a look at it?

[hellp]

The root cause seems to be the default ordering of Postgres' text fields.

Example:

SELECT classifier FROM mytable ORDER BY classifier;

Output:

Python :: 2 
Python :: 2.7 
Python :: 2 :: Only 

Looks like the collation "ucs_basic" (mentioned here as a SQL standard, but not default in PG, for UTF-8: https://www.postgresql.org/docs/10/static/collation.html) returns the strings in the order we'd prefer:

SELECT classifier FROM mytable ORDER BY classifier COLLATE ucs_basic ;

Output:

Python :: 2 
Python :: 2 :: Only 
Python :: 2.7 

What's the better idea? Simply change the query in the one place (does sqlalchemy support that somehow) or migrate the database field to always order by this collation?

[Cheukting]

Amazing @hellp !

[nlhkabu]

@dstufft is this something for you to look at?

[di]

This seems to have resolved itself. https://pypi.org/search/?q= currently shows the following: