feat(server): add purge mechanism for soft-deleted records

Automatically removes soft-deleted records older than 90 days.
Runs on server startup and every 24 hours thereafter.
Respects foreign key dependencies when deleting.

Co-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>

1 files changed, 3 insertions, 0 deletions

diff --git a/src/server/index.ts b/src/server/index.ts
index 52eab67..4a6978d 100644
--- a/src/server/index.ts
+++ b/src/server/index.ts
@@ -11,6 +11,7 @@ import {
 	study,
 	sync,
 } from "./routes/index.js";
+import { startPurgeScheduler } from "./services/purge-scheduler.js";
 
 const app = new Hono();
 
@@ -44,4 +45,6 @@ serve({
 	port,
 });
 
+startPurgeScheduler();
+
 export { app };