diff options
| author | Claude <noreply@anthropic.com> | 2026-01-12 08:46:55 +0000 |
|---|---|---|
| committer | Claude <noreply@anthropic.com> | 2026-01-12 08:46:55 +0000 |
| commit | 485486c7ff986712ecb09e92217236d276d317c4 (patch) | |
| tree | 8c8c49747fd4d9db6cc24c821a2e27aced01a271 /backend/graphql/model | |
| parent | 67bfaf8f103295c5562db02a0044e311e3504518 (diff) | |
| download | feedaka-485486c7ff986712ecb09e92217236d276d317c4.tar.gz feedaka-485486c7ff986712ecb09e92217236d276d317c4.tar.zst feedaka-485486c7ff986712ecb09e92217236d276d317c4.zip | |
feat: deduplicate feed items by guid
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
Diffstat (limited to 'backend/graphql/model')
0 files changed, 0 insertions, 0 deletions