Sort hosts page by lowercase host name? #318

Open
opened 2025-12-02 23:31:17 +00:00 by davmo · 0 comments
Owner

The Correspondents page is sorted by the names of the hosts. This a sort that separates names which begin with capital letters from those that use lower case.

Thus (hypothetical) hosts Albert and arthur are not adjacent.

This is potentially confusing when looking up a given host by scrolling down the page.

Suggestion is to use ORDER BY lower(host) in the query.

The [Correspondents page](https://hackerpublicradio.org/correspondents/index.html) is sorted by the names of the hosts. This a sort that separates names which begin with capital letters from those that use lower case. Thus (hypothetical) hosts *Albert* and *arthur* are not adjacent. This is potentially confusing when looking up a given host by scrolling down the page. Suggestion is to use `ORDER BY lower(host)` in the query.
Sign in to join this conversation.
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: HPR/hpr_generator#318