「バックフィル」とは何ですか？

[JammyDodger]

@sam

The following badge is triggered on “when a user acts on a post”, this means “delta” applications will get the :post_ids parameter.

SELECT p.user_id, p.id post_id, p.updated_at granted_at
FROM badge_posts p
WHERE p.like_count >= 25 AND
(:backfill OR p.id IN (:post_ids) )

The clause (:backfill OR p.id IN (:post_ids) ) allows us to filter the results. When the daily job runs :backfill is true so the entire set is scanned. When the delta jobs run :backfill is false and :post_ids is set.

I was trying to get it to trigger on When a user acts on a post, but I think my Reactions may be blocking that somehow? Anyway, Update Daily will work, and is less of a performance concern, I think