Summary
Address Codex review findings from PR #38:
🔴 High Priority - Cursor Format Incompatibility
- DB uses base64 offsets, ScrapingBee uses
page:N format
- Causes pagination resets and wasted credits
- Add "hot" to sortMap to prevent sort degradation
🟡 Medium Priority - Incomplete Index Coverage
- Missing indexes for category+newest, category+ending
- Deadline predicate not indexed for trending/newest
- Performance degrades as table grows with expired rows
Proposed Fixes
- Cursor compatibility: Add "hot" to sortMap, prevent fallback cycling
- Index coverage: Add composite indexes with deadline predicate
- Add handler tests: Validate pagination and filtering behavior
References
Codex review: commit 1173168 (PR #38 merge)
Summary
Address Codex review findings from PR #38:
🔴 High Priority - Cursor Format Incompatibility
page:Nformat🟡 Medium Priority - Incomplete Index Coverage
Proposed Fixes
References
Codex review: commit 1173168 (PR #38 merge)