Something went wrong. Try again.
grain.social is a photo sharing platform built on atproto. grain.social
appview atproto photography
Something went wrong. Try again.
123456789101112// Use in place of `"social.grain.gallery" t` in chronological feed queries.// Exposes `t.sort_at = min(created_at, indexed_at)` so that future-dated// `createdAt` values (client clock skew) don't pin galleries to the top of// `/recent` and friends. Backdated values (e.g. /settings/import sets// createdAt to the original Bluesky post date) are preserved, so historical// imports still slot into history rather than the top of the feed.//// Pair with `orderBy: "t.sort_at"` and select `t.sort_at` for the cursor.export const galleryFeedTable = `( SELECT *, min(created_at, indexed_at) AS sort_at FROM "social.grain.gallery") t`;