aboutsummaryrefslogtreecommitdiffhomepage
path: root/backend/db/schema.sql
AgeCommit message (Collapse)Author
2026-02-13feat: add feed sidebar and cursor-based paginationnsfisis
Add a feed sidebar to /unread and /read pages for filtering articles by feed, and replace the fixed 100-article limit with cursor-based pagination using a "Load more" button. Backend: - Add PageInfo, ArticleConnection types and pagination args to GraphQL - Replace GetUnreadArticles/GetReadArticles with parameterized queries - Add GetFeedUnreadCounts query and composite index - Add shared pagination helper in resolver Frontend: - Add FeedSidebar component with unread count badges - Add usePaginatedArticles hook for cursor-based fetching - Update ArticleList with Load more button and single-feed mode - Use ?feed=<id> query parameter for feed filtering Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>
2026-01-12feat: deduplicate feed items by guidClaude
Use ROW_NUMBER() window function to filter out duplicate articles with the same guid across different feeds. This ensures each guid appears only once in unread/read article lists. - Add idx_articles_guid index for PARTITION BY performance - Modify GetUnreadArticles and GetReadArticles queries with CTE
2025-10-27feat(backend): Make feeds.user_id column non-nullnsfisis
2025-10-27feat(backend): Create users tablensfisis
2025-07-12feat(backend,frontend): add feature to unsubscribe feednsfisis
2025-07-12feat(backend): introduce sqlcnsfisis