Prisma Jobs

Bug fix + performance task in a 14 / TypeScript / Prisma / PostgreSQL real-time dashboard app. Context: the app polls a leaderboard endpoint every 2 seconds to show ranked results from an Event table (user activity events with type, userId, timestamp, and a numeric value field). Two issues: 1. Missing database indexes. The polled query filters on (accountKey, lastActiveAt) and a separate query filters on (accountKey, status, updatedAt) — neither has a covering index, so both scans get slower as event history grows. Need hand-written Prisma migration SQL adding the two composite indexes (not `prisma migrate dev` autogenerate). 2. Leaderboard fallback silently fails as empty state. The ranking endpoint has a primary data source and a fallback data source. When the...