Fullstack Developer & Lovable Expert Needed for a Quick Supabase PostgreSQL Audit
Worldwide
I run a live streaming battle platform (fairrace.app) built on Next.js and TypeScript, hosted on Vercel, with Supabase PostgreSQL for the database, LiveKit for video, and Stripe for payments. It's live in production with real users and a real money in-app coin economy. I need a fullstack developer, ideally one who is also a Lovable expert and comfortable auditing apps built quickly on tools like Lovable, Replit, Base44 or Bolt, to run a quick but thorough Supabase PostgreSQL audit of the codebase and database before any issues cost me money or user trust. Tech Stack Next.js (App Router) with TypeScript, Supabase (Postgres, Auth, Realtime, RLS, Postgres functions), LiveKit, Stripe, and GitHub for version control. Core Loop Users buy coins, then gift them to streamers during live video. Streamers earn a cut and can withdraw via PayPal or convert to a spendable balance. The platform also runs a live 1v1 battle and tapping system, co-hosting, and a leaderboard. What I Need Checked Coin economy integrity: Every code path that moves coins: gifts, Stripe purchases, withdrawals, conversions, refunds. I've already found and fixed several spots where a failed database write was silently ignored while coins had already moved. I need someone to find any others and confirm the whole system is airtight. Database security: RLS policies on every table in Supabase PostgreSQL, and confirmation that all coin-mutating Postgres functions are locked to service_role only, never callable from a user's browser. Race conditions: Simultaneous taps and gifts in live battles, and the same account active on multiple devices at once. Realtime and LiveKit: Subscription scoping and cleanup, plus the co-host and battle dual-room connection setup. General pass: Flag anything else fragile or likely to cause silent data corruption. Deliverables 1 A written report of issues found, ranked by severity, in plain language I can act on as a non-technical founder. 2 Actual fixes for anything critical or high severity, submitted for my review. No direct pushes to production.3 A quotation for fixing the issues found, broken down by severity, along with a time estimate for how long the fixes will take to complete. Ideal Candidate A fullstack developer with strong Next.js and Supabase or Postgres experience (RLS, Postgres functions, Realtime specifically), ideally with a fintech or payments background. Lovable expert-level familiarity is a plus since it helps you quickly spot patterns where speed was prioritized over safety, even though this app was hand-coded rather than built on Lovable. Please include a past audit example in your proposal.
$15.00
Fixed-price- ExpertExperience Level
- Remote Job
- Ongoing projectProject Type
Skills and Expertise
Activity on this job
- Proposals:10 to 15
- Last viewed by client:1 hour ago
- Interviewing:3
- Invites sent:5
- Unanswered invites:2
About the client
- NGAOgun State10:49 PM
- $1.1K total spent115 hires, 2 active
- 3 hours
- Science & MedicineSmall company (2-9 people)
Explore similar jobs on Upwork
How it works
Create your free profileHighlight your skills and experience, show your portfolio, and set your ideal pay rate.
Work the way you wantApply for jobs, create easy-to-by projects, or access exclusive opportunities that come to you.
Get paid securelyFrom contract to payment, we help you work safely and get paid securely.
About Upwork
- 4.9/5(Average rating of clients by professionals)
- G2 2021#1 freelance platform
- 49,000+Signed contract every week
- $2.3BFreelancers earned on Upwork in 2020
Find the best freelance jobs
Growing your career is as easy as creating a free profile and finding work like this that fits your skills.
Trusted by