aboutsummaryrefslogtreecommitdiffhomepage
path: root/backend/db/migrations
AgeCommit message (Collapse)Author
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-10-27feat(backend): Make feeds.user_id column non-nullnsfisis
2025-10-27feat(backend): Create users tablensfisis
2025-07-13feat(backend): implement db schema migrationv0.2.0nsfisis