HPR/hpr_generator
8
1
Fork 5
Code Issues 34 Pull Requests 3 Actions Packages Projects Releases Wiki Activity

Sort hosts page by lowercase host name? #318

New Issue
Open
opened 2025-12-02 23:31:17 +00:00 by davmo · 0 comments
davmo commented 2025-12-02 23:31:17 +00:00
Owner
Copy Link

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.
👍 1
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
Clear labels
Bug Found
For issues related to the code or the content of the created HTML files
 Feature Request
General Discussion
For discussing HPR site generation in general
 Help Request
For issues running or installing the site-generator
Feature Request
Used when requesting a new Feature.
No Label
Milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
archer72 davmo jknapp ken_fallon norrist paulj rho_n sgoti
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: HPR/hpr_generator#318
Delete Branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?