"First Flag" badge has precise public timestamps that could be correlated with flagged posts

Fixing it in the query should be a simple matter of date_trunc('hour', flag.created_at) as granted_at but considering whether the badge should be around at all is also a good point.

2 Likes