Something went wrong. Try again.
a tool for shared writing and social publishing
Something went wrong. Try again.
12345678910111213import { sql } from "drizzle-orm";
// The one definition of "trending": engagement over a super-linear time decay,// with a recommend worth five Bluesky likes. Both /reader/trending// (actions/reader/getHotFeed.ts) and the tag views order by this, so they rank// a given post identically.//// Interpolated into a query whose `documents` row is aliased `d`.export const TRENDING_RANK = sql` (d.bsky_like_count + d.recommend_count * 5)::numeric / power(extract(epoch from (now() - d.sort_date)) / 3600 + 2, 1.5)`;