alvis/oO
1
0
Fork 0
Code Issues 34 Pull Requests Actions Packages Projects Releases Wiki Activity

bug: no data retention purge for tip_scores and tip_feedback (GDPR 30-day) #76

New Issue
Closed
opened 2026-04-16 15:24:28 +00:00 by alvis · 0 comments
alvis commented 2026-04-16 15:24:28 +00:00
Owner
Copy Link

Problem

tip_scores and tip_feedback tables are documented as 30-day retention (schema comments reference GDPR), but no cleanup job exists. Data accumulates indefinitely.

Fix

  1. Add a daily cleanup function: DELETE FROM tip_scores WHERE served_at < datetime('now', '-30 days')
  2. Same for tip_feedback
  3. Run on API startup + setInterval (24h) for Phase 0
  4. Move to Prefect/cron in M4
## Problem `tip_scores` and `tip_feedback` tables are documented as 30-day retention (schema comments reference GDPR), but no cleanup job exists. Data accumulates indefinitely. ## Fix 1. Add a daily cleanup function: `DELETE FROM tip_scores WHERE served_at < datetime('now', '-30 days')` 2. Same for `tip_feedback` 3. Run on API startup + setInterval (24h) for Phase 0 4. Move to Prefect/cron in M4
alvis added this to the M2 — AI tips + multi-source signals milestone 2026-04-16 15:24:28 +00:00
alvis closed this issue 2026-04-17 13:34:45 +00:00
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
Clear labels
admin
backend
design
good-first-issue
infra
ml
mobile
platform
web
No Label
Milestone
No items
No Milestone M2 — AI tips + multi-source signals
Projects
Clear projects
No project
Assignees
Clear assignees
alvis
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: alvis/oO#76
Delete Branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?