diff options
| author | Claude <noreply@anthropic.com> | 2026-01-12 08:58:04 +0000 |
|---|---|---|
| committer | Claude <noreply@anthropic.com> | 2026-01-12 08:58:04 +0000 |
| commit | 8524487824f7332223b24e75ab327bf6ec5eccc9 (patch) | |
| tree | c44fb10d82e34d55479cefc62496517c749db3b6 /backend/auth/middleware.go | |
| parent | 485486c7ff986712ecb09e92217236d276d317c4 (diff) | |
| download | feedaka-8524487824f7332223b24e75ab327bf6ec5eccc9.tar.gz feedaka-8524487824f7332223b24e75ab327bf6ec5eccc9.tar.zst feedaka-8524487824f7332223b24e75ab327bf6ec5eccc9.zip | |
refactor: deduplicate articles at insertion time instead of query time
Change deduplication strategy from query-time (ROW_NUMBER window function)
to insertion-time (global guid check before insert).
Benefits:
- Simpler queries without CTE/window functions
- Consistent read state (no duplicate articles to manage)
- Better query performance (no per-query deduplication overhead)
Changes:
- Add CheckArticleExistsByGUID query for global guid lookup
- Add migration to remove existing duplicate articles
- Modify fetchOneFeed and AddFeed to skip duplicates on insert
- Revert GetUnreadArticles/GetReadArticles to simple queries
Diffstat (limited to 'backend/auth/middleware.go')
0 files changed, 0 insertions, 0 deletions