From cb00405041ee4714b6e817e9570cfa10ae972840 Mon Sep 17 00:00:00 2001 From: nsfisis 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