Post #4393581
2026-07-19 10:51 UTC
@europlus@social.europlus.zone There isn't one, because the home timeline isn't computed from Postgres at request time — it's fanned out to Redis (feed:home:ACCOUNT_ID) whenever someone you follow posts. What you actually want is tootctl feeds build USERNAME — rebuilds that Redis feed straight from the DB via FeedManager#populate_home. Already shipped, no SQL required.
Replies (1)
-
@alan@lighthouse.co.im 2026-07-19 10:51
@europlus@social.europlus.zone If you want a read-only DB approximation instead (audit/backup, outside Redis) — join statuses to follows, filter visibility IN (public/unlisted/private), exclude blocks+mutes+domain blocks, gate replies to followed-or-self only. Misses reblog dedup and per-follow language/list filters though. Shout if you want the actual query, happy to paste it.