We’ve added pagination and sorting to help manage growing list collections. If you’ve been accumulating lists over time, these updates should make navigation noticeably easier.

The Problem

We’ve been receiving increasing feedback from users about performance and navigation issues as their list collections grew. Without pagination, loading 50+ lists meant fetching and rendering everything at once. This got slow. Scrolling through dozens of lists to find a specific one was tedious. The most recently updated list might be buried somewhere in the middle.

Items within lists had similar issues - no way to sort them, no context about when they were added. Several users reported difficulty finding recently saved items in long lists.

What Changed

List Pagination Lists now load 13 at a time with page navigation. You can jump between pages or move forward/backward. The interface shows your current position (e.g., “Page 2 of 5 • Showing 26 of 60 lists”).

List Sorting A sort dropdown lets you organize lists by:

• Most Recently Changed (default) - puts active lists at the top
• Newest First
• Oldest First

The sort persists as you navigate pages.

Item Sorting Within individual lists, you can now sort items by:

• Most Recent First (default)
• Oldest First

Timestamps Lists show when they were last updated (“Updated 2 days ago”). Items show when they were saved to Listify (“Saved 1 week ago”). This helps identify stale content or track what you’ve added recently.

Technical Notes

The pagination uses offset-based queries with proper count handling. Sort parameters are passed directly to PostgREST’s order parameter.

Search works across pagination. When you filter lists, pagination resets to page 1 with the new result set.

We continue to rely heavily on PostgREST for our API layer. Its built-in support for filtering, ordering, pagination, and count operations made implementing these features straightforward. The ability to express complex queries through URL parameters while maintaining proper SQL performance is impressive. Thanks to the PostgREST team for maintaining such a solid piece of infrastructure - it’s simplified our tech stack considerably and keeps our backend lean.

Usage

The changes apply automatically. If you have more than 13 lists, you’ll see pagination controls at the bottom of your lists page. The sort dropdown appears next to the search box.

For individual list pages, the item sort dropdown is at the top right, below the action buttons.