aboutsummaryrefslogtreecommitdiffhomepage
path: root/backend
AgeCommit message (Collapse)Author
5 daysrefactor: remove unused GetAllArticleGUIDs queryClaude
5 daysrefactor: deduplicate articles at insertion time instead of query timeClaude
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 daysfeat: deduplicate feed items by guidClaude
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-07refactor(graphql): change directory structurensfisis
2025-12-04refactor(backend): move cmd_*.go to cmd packagev0.4.3nsfisis
2025-12-04refactor(backend): move middleware.go to auth packagensfisis
2025-11-28refactor(backend): Move config.go to separate packagensfisis
2025-11-08refactor(backend): Centralize environment variable loading in config.gonsfisis
2025-11-08feat: Support multi-usernsfisis
2025-10-27feat(backend): Make feeds.user_id column non-nullnsfisis
2025-10-27refactor(backend): split main.gov0.3.4nsfisis
2025-10-27feat(backend): create-user commandnsfisis
2025-10-27feat(backend): Create users tablensfisis
2025-07-13chore: update justfilesnsfisis
2025-07-13feat(backend): change db file pathnsfisis
2025-07-13feat(backend): implement db schema migrationv0.2.0nsfisis
2025-07-13feat(container): fix Docker buildnsfisis
2025-07-12feat(backend,frontend): add feature to unsubscribe feednsfisis
2025-07-12feat(backend): introduce sqlcnsfisis
2025-07-12fix(backend): fix incorrect parsing of feeds.fetched_at columnnsfisis
2025-07-11feat(frontend): move favicon to frontend/nsfisis
2025-07-11feat(backend): remove REST API endpointsnsfisis
2025-07-11feat(backend): implement graceful shutdownnsfisis
2025-07-11feat(backend): implement GraphQL resolversnsfisis
2025-07-11feat(backend): add justfile for backendnsfisis
2025-07-11feat(backend): add GraphQL boilerplate codensfisis
2025-06-23refactor: change directory structurensfisis