| Age | Commit message (Collapse) | Author | |
|---|---|---|---|
| 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-10-27 | feat(backend): Make feeds.user_id column non-null | nsfisis | |
| 2025-10-27 | feat(backend): Create users table | nsfisis | |
| 2025-07-13 | feat(backend): implement db schema migrationv0.2.0 | nsfisis | |
 |
index : feedaka | |
| feedaka | nsfisis |
| aboutsummaryrefslogtreecommitdiffhomepage |