aboutsummaryrefslogtreecommitdiffhomepage
path: root/backend/db/migrations/005_add_guid_index.sql
AgeCommit message (Collapse)Author
5 daysfeat: 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