| 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-12-07 | refactor(graphql): change directory structure | nsfisis | |
| 2025-12-04 | refactor(backend): move cmd_*.go to cmd packagev0.4.3 | nsfisis | |
| 2025-12-04 | refactor(backend): move middleware.go to auth package | nsfisis | |
| 2025-11-28 | refactor(backend): Move config.go to separate package | nsfisis | |
| 2025-11-08 | refactor(backend): Centralize environment variable loading in config.go | nsfisis | |
| 2025-11-08 | feat: Support multi-user | nsfisis | |
| 2025-10-27 | feat(backend): Make feeds.user_id column non-null | nsfisis | |
| 2025-10-27 | refactor(backend): split main.gov0.3.4 | nsfisis | |
| 2025-10-27 | feat(backend): create-user command | nsfisis | |
| 2025-10-27 | feat(backend): Create users table | nsfisis | |
| 2025-07-13 | chore: update justfiles | nsfisis | |
| 2025-07-13 | feat(backend): change db file path | nsfisis | |
| 2025-07-13 | feat(backend): implement db schema migrationv0.2.0 | nsfisis | |
| 2025-07-13 | feat(container): fix Docker build | nsfisis | |
| 2025-07-12 | feat(backend,frontend): add feature to unsubscribe feed | nsfisis | |
| 2025-07-12 | feat(backend): introduce sqlc | nsfisis | |
| 2025-07-12 | fix(backend): fix incorrect parsing of feeds.fetched_at column | nsfisis | |
| 2025-07-11 | feat(frontend): move favicon to frontend/ | nsfisis | |
| 2025-07-11 | feat(backend): remove REST API endpoints | nsfisis | |
| 2025-07-11 | feat(backend): implement graceful shutdown | nsfisis | |
| 2025-07-11 | feat(backend): implement GraphQL resolvers | nsfisis | |
| 2025-07-11 | feat(backend): add justfile for backend | nsfisis | |
| 2025-07-11 | feat(backend): add GraphQL boilerplate code | nsfisis | |
| 2025-06-23 | refactor: change directory structure | nsfisis | |
