FeedKeeper 0.27.2

FeedKeeper 0.27.2 brings major performance optimizations across database indexing, delta sync hydration, reader noise filtering, and background job scheduling.

• Database and query performance: Connection pragmas configure memory-backed temporary storage and a 64 MB cache with normal WAL checkpoints. Full-text search queries page article IDs before loading HTML blobs, avoiding large temporary sort tables, and cleanup queries avoid correlated JSON lookups.
• Delta sync and hydration: Changes to item content, reading states, bookmarks, and notes are hydrated in batch queries instead of per-entity lookups, and sequence numbers remain strictly monotonic across change log pruning.
• Reader noise cleaning: Leading character counting now short-circuits once the start of the article is passed, eliminating quadratic range calculations on long documents.
• Worker and cache reliability: Full-text worker queues back off adaptively when waiting for scheduled items, image caching rejects known missing URLs immediately before queueing, and access token last-used touches are throttled to every 5 minutes.

Migration 0039_performance_indexes.sql adds composite indexes for cascade deletes, housekeeping, item pagination, and full-text candidates, along with monotonic sequence floor triggers. Existing data is preserved automatically.