v1.4.1 - library browsing no longer jitters on PostgreSQL
🩹 Hotfix
- Library scrolling on PostgreSQL deployments could visibly jump back and forth between series with adjacent letters, making the library hard to browse (reported on a live pg install within hours of v1.4.0). Root cause: the library's sorts ordered by name/year alone, and OFFSET pagination without a fully unique order lets PostgreSQL resolve ties (rebooted volumes share exact names) differently on every page fetch - so page windows overlapped and gapped, starving the infinite scroll and reflowing the grid under the reader. Every paginated sort now carries a unique id tiebreaker, and the alphabet jump bar's letter index is computed against the same total order the pages realize.
- Same fix applied to the OPDS series catalog, which paginated the same way - Panels/KOReader users on PostgreSQL could see series duplicated or missing across catalog pages.
- SQLite deployments were never visibly affected (its tie order happens to be stable in practice) and behave identically after this change.
📦 Upgrading
Standard three-service compose: docker compose pull && docker compose down && docker compose up -d. No compose, environment, or schema changes.