Back to jobs

Debug Supabase Realtime PostgREST Filter Join Timeout

Search - MySQL · ai_analyzed · UID ~022079168008191918724

Open Job

Job Details

Budget Unknown
ExperienceIntermediate
DurationUnknown
Weekly hoursUnknown
Client countryAbout the client
ProposalsLess than 5
Interviewing0
Invites sent0
First seenMon, Jul 20, 2026 11:40 AM
Last seenMon, Jul 20, 2026 5:20 PM

Description

Debug Supabase Realtime PostgREST Filter Join Timeout Posted 6 minutes ago Worldwide Summary Problem: Realtime subscription crashes during high-concurrency multi-tenant updates.Root Cause: A complex PostgreSQL trigger combined with recursive Row-Level Security (RLS) policies is causing an infinite recursion or timeout loop under load. Task: Optimize the nested SQL security definer function and refactor the TypeScript client filter logic to use proper channel broadcasting instead of heavy database polling. Deliverable: Optimized SQL policy script and patched TypeScript subscription code that passes stress testing under 100 concurrent writes. $10.00 Fixed-price Intermediate Experience Level Remote Job One-time project Project Type Contract-to-hire opportunity This lets talent know that this job could become full time. Learn more Skills and Expertise Mandatory skills Web Application PostgreSQL + 3 more Activity on this job Proposals: Less than 5 Last viewed by client: 4 minutes ago Interviewing: 0 Invites sent: 0 Unanswered invites: 0 About the client Member since May 3, 2026 Ethiopia Jimma11:40 AM $16 total spent 2 hires, 1 active

Skills

MySQL Web Application PostgreSQL NGINX JavaScript

Notification History

ChannelTypeStatusSentError
telegram pre_ai_job_alert sent Mon, Jul 20, 2026 11:41 AM -

User Actions

ActionActed at
No actions.