| Age | Commit message (Collapse) | Author | |
|---|---|---|---|
| 5 days | refactor: remove unused GetAllArticleGUIDs query | Claude | |
| 5 days | refactor: deduplicate articles at insertion time instead of query time | Claude | |
| 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 | |||
| 5 days | feat: deduplicate feed items by guid | Claude | |
| 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-11-08 | feat: Support multi-user | nsfisis | |
| 2025-07-12 | feat(backend,frontend): add feature to unsubscribe feed | nsfisis | |
| 2025-07-12 | feat(backend): introduce sqlc | nsfisis | |
 |
index : feedaka | |
| feedaka | nsfisis |
| aboutsummaryrefslogtreecommitdiffhomepage |