Finalize PWA Pharmacy Locator

My progressive web app already helps citizens track down scarce medications by connecting them with nearby pharmacies. The core build (single-page index.html ~13 K lines) is live on Cloudflare Workers and backed by Supabase for PostgreSQL, RPCs, Edge Functions and Storage. OneSignal handles push notifications.

I’m looking for a professional who can take it across the finish line. The immediate focus is fixing the remaining issues—starting with hashing the PIN, currently stored in plaintext, using bcrypt—then moving through the rest of the punch list:

• Verify and, where needed, restore Supabase RPCs: cast_alert_vote, record_citizen_report, add_view
• Hunt down minor bugs such as orphaned storage files and race-condition edge cases
• Revoke any obsolete OneSignal keys and confirm the new configuration works end-to-end

After the codebase is clean, I need guidance and hands-on implementation for publishing. Because this is a PWA we’ll package and submit to:
• Google Play via TWA / Bubblewrap (Capacitor is also on the table)
• Apple App Store, ensuring we meet their stricter PWA requirements

I’ll supply repository access, Supabase and OneSignal credentials and my developer-program accounts once we agree on scope. Expect constructive code review comments, concise commits and a clear deployment checklist so the app can be maintained confidently after launch. Show More