We're building a niche professional networking platform. The app is
fully functional and pre-launch — in final hardening phase before
user acquisition begins. The codebase is clean, well-organized, and
fully documented with a detailed spec, prioritized task tracker, and
complete system audit ready to hand off on day one.
No design work. No figuring out what to build. Just executing a
clear, well-defined scope on a modern stack.
Location preference: United States preferred. Will consider
worldwide candidates with excellent English and overlapping
availability with US Eastern time.
STACK
- React 18 + TypeScript + Vite
- Supabase (auth, database, edge functions, RLS, storage)
- Tailwind CSS
- Cloudflare Pages
- TanStack Query + TanStack Virtual
SCOPE OF WORK
Week 1-2 — Backend & Infrastructure
- Migrate Supabase project from Lovable-managed to our own project
- Set up Cloudflare R2 for media storage + custom media subdomain
- Update frontend upload pipeline to point to R2
- Add SMS OTP via Twilio
- Google OAuth integration
- Apple OAuth integration
Week 2-3 — Database Cleanup
- Drop ~20 unused backup and legacy tables
- Add missing indexes on high-traffic tables
- Add proper foreign key cascade behavior
- Tighten RLS policies
- Fix search_path injection risk on existing SQL functions
Week 3-5 — Frontend Code Quality
- Split 6 large components and pages (500-1000 lines each) into
proper subcomponents
- Reduce TypeScript any usage across the codebase
- Remove unused npm dependencies
- Guard console statements in production builds
- Extract shared utility functions and constants
Week 5-7 — Mobile
- Capacitor iOS app build + App Store submission
- Google Play submission
Note: App Store and Google Play review times are outside anyone's
control. We understand submission and approval are two different
things.
WHAT WE'RE LOOKING FOR
- Supabase depth — real experience with RLS, migrations, edge
functions, and storage. Not surface-level.
- React 18 + TypeScript — comfortable refactoring large components
without breaking existing behavior
- Someone who moves fast, communicates clearly, and works well
from a spec without needing everything hand-held
- Capacitor experience is a strong plus but not a dealbreaker
- US-based preferred but will consider strong worldwide candidates
WHO THIS IS NOT FOR
- Designers or frontend-only developers
- Developers who need the scope defined for them
- Agencies — looking for an individual contributor only
BUDGET
Hourly. $40-60/hr depending on experience. Open to discussing
fixed price per phase if you prefer that structure.
TO APPLY YOU MUST ANSWER THESE 4 QUESTIONS
Applications without answers will not receive a response.
- Have you migrated a Supabase project before? Briefly describe
what was involved.
- Have you set up Cloudflare R2 or similar object storage?
- Do you have Capacitor iOS/Android experience? Be honest —
it is not required.
- What is your estimated hours for Week 1-2 alone?
Hey Chance,
I run a small dev team building SaaS MVPs. Recent project: huaspeed dot cc — full-stack VPN accelerator (Node.js, Express, WireGuard tunnels, Stripe payments, production deployment).
Your 4 questions:
Supabase migration?
Not Supabase-specific, but we've done production database migrations and auth rewrites. The patterns translate: dump → recreate → re-validate permissions → cut over. Aware of the RLS policy gotcha (breaks silently on ownership change). Would budget buffer for thorough policy testing.
Cloudflare R2 / similar?
Yes — S3-compatible storage setup, CDN-routed subdomains. Our approach: grep codebase for hardcoded URLs → build signed-URL pipeline → migrate with a script. The real work is the frontend URL hunt, not the R2 config.
Capacitor experience?
No direct Capacitor experience — being upfront. But the scope here is wrapping an existing web app + store submission. We've handled iOS provisioning/certificates and review processes before. Would allocate extra time for Apple ATS/quirk handling.
Week 1-2 hour estimate?
~110 hours for my team. Breakdown:
Anyone quoting under 100h for this is being optimistic — the Supabase migration alone needs real testing time.
Why us?
We ship products end-to-end, not just code. Huaspeed dot cc has real users, real payments, real infrastructure. We work from specs, communicate clearly, and deliver without hand-holding.
Available immediately. Prefer fixed price per phase, happy to discuss on a call this week.
— Cyber Free Bird
songwanxindeyouxiang1 at huaspeed dot cc
Is it still relevant?
Hey Chance, we have built and shipped with supabase for over a year now. We have setup very similar object storage utilizing supabase native S2 buckets, One of our devs has worked with cloudflare R2 before. Not fully with capacitor. We are a team of developers with capabilities ranging in different specialities. We work on a phase by phase rate would love to hop on a call and discuss more. You can visit our site at thundebirdlabs,co here to learn more (wont let me post links but the , is a . for .co), along with this my email is nick@thunderbird-labs . co m (once again ignore my weird spelling you can guess what im trying to write lol)
Great scope definition — rare to see a job post this well-structured.
Respecting the "no agencies" note, not applying, but wanted to drop
a few notes for anyone else reading this looking to do similar
Supabase hardening work.
Common gotchas I've seen on projects with this exact stack:
Supabase migration: RLS policies don't migrate cleanly when
project ownership changes. Budget 8-12 hours just for policy
re-validation — separate from the SQL migration itself. The
SECURITY DEFINER functions often break silently.
Cloudflare R2 + Supabase storage swap: The real work isn't the
R2 setup, it's hunting down hardcoded storage URLs scattered
through the frontend. Do a full codebase grep before touching
anything — pre-signed URL handling is where most teams lose
a day.
search_path injection fix: Don't patch one function — audit
every SECURITY DEFINER function in the project. Missing even
one leaves the whole attack surface open.
Capacitor iOS submission: Apple's ATS and bitcode requirements
hit Capacitor apps hard. TestFlight 2 weeks before final
submission, minimum. Google Play is usually smoother but throws
curveballs on permission declarations for media access.
On the 80-hour estimate for Week 1-2: that's optimistic unless
you've done a Supabase migration before. Realistic range is
100-120 hrs if it's your first one. Worth building in that
buffer upfront.
The "600-1000 line component refactor" in weeks 3-5 is where most
devs underestimate. Splitting without breaking existing behavior
takes meaningful test coverage — if the codebase doesn't have it
already, add 20-30% buffer there too.
Best of luck with the hire — whoever lands this has a clean spec
to work from, which is half the battle.
— Jillur
Hi — I’m interested in the role.
I haven’t shipped a dedicated Supabase project yet, but I’m very comfortable with backend-as-a-service systems like Firebase. The patterns (auth, database modeling, real-time data, serverless workflows) are familiar, and I can ramp up on Supabase quickly since the concepts translate directly.
Yes — I’ve used Vercel, Netlify, Firebase, and similar modern deployment stacks in production-style projects. I’m comfortable with CI/CD workflows, environment configs, and shipping fast.
My initial estimate is ~80 hours for the first phase, but I’d need to review the existing codebase to give a more precise breakdown. I usually prefer to evaluate architecture first before committing to time estimates.
I work fast, communicate clearly, and focus on shipping working features rather than overengineering.
Happy to jump in immediately. Looking forward to hearing from you.
This comment was deleted 3 months ago
This comment was deleted 4 months ago