aboutsummaryrefslogtreecommitdiffhomepage
path: root/backend/db/schema.sql
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-12feat(backend,frontend): add feature to unsubscribe feednsfisis
2025-07-12feat(backend): introduce sqlcnsfisis