Problem
All posts matching current filters are fetched and rendered in a single response. The listPosts() query in src/db.ts has no LIMIT clause, and the home route renders every result at once. This won't scale as post count grows.
Proposed Solution
Add cursor-based or offset/limit pagination to the posts list:
- Add
LIMIT and OFFSET to listPosts() queries in src/db.ts
- Return pagination metadata (total count, current page, has more)
- Add "Load more" or page navigation controls using HTMX
- Apply pagination to all sort/filter/search modes
Acceptance Criteria
Problem
All posts matching current filters are fetched and rendered in a single response. The
listPosts()query insrc/db.tshas noLIMITclause, and the home route renders every result at once. This won't scale as post count grows.Proposed Solution
Add cursor-based or offset/limit pagination to the posts list:
LIMITandOFFSETtolistPosts()queries insrc/db.tsAcceptance Criteria