blogflare/migrations/0003_add_published_at_index.sql

-- Add index for descending published_at to optimize latest posts queries
CREATE INDEX IF NOT EXISTS idx_posts_published_at_desc ON posts(published_at DESC);