From cb00405041ee4714b6e817e9570cfa10ae972840 Mon Sep 17 00:00:00 2001
From: nsfisis <nsfisis@gmail.com>
Date: Mon, 27 Apr 2026 21:20:10 +0900
Subject: feat(backend): adapt feed fetch interval to update frequency

Add per-feed fetch_interval_seconds (clamped to [1h, 24h]) that halves
on new articles and grows 1.5x when a fetch yields nothing, replacing
the fixed 1h schedule with the 10min cooldown filter. Scheduler tick
shortened to 30min so the 1h floor is honored with reasonable precision.
---
 backend/db/migrations/007_add_feeds_fetch_interval_seconds.sql | 1 +
 1 file changed, 1 insertion(+)
 create mode 100644 backend/db/migrations/007_add_feeds_fetch_interval_seconds.sql

(limited to 'backend/db/migrations/007_add_feeds_fetch_interval_seconds.sql')

diff --git a/backend/db/migrations/007_add_feeds_fetch_interval_seconds.sql b/backend/db/migrations/007_add_feeds_fetch_interval_seconds.sql
new file mode 100644
index 0000000..102a555
--- /dev/null
+++ b/backend/db/migrations/007_add_feeds_fetch_interval_seconds.sql
@@ -0,0 +1 @@
+ALTER TABLE feeds ADD COLUMN fetch_interval_seconds INTEGER NOT NULL DEFAULT 3600;
-- 
cgit v1.3.1

