Prisma Jobs

Bug fix in a real-time chat application. Context: chat messages are stored as generic ChatEvent rows in Postgres, with no dedicated flag distinguishing a private message from a public one — private messages currently arrive with a text-based marker prefixed to the message body (e.g. a bracketed tag at the start of the string). The frontend chat component already has a fully built, distinct rendering path for private messages (different visual treatment) — it just never gets used, because the API route that serves chat events to the frontend maps every single row to the generic "chat" type regardless of content, so the private-message type the frontend already knows how to render is never actually emitted. Task: update the API route so it correctly detects the priv...

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...