Database Architecture & Code Review for a Scalable PWA / Mobile App

Database Architecture & Code Review for a Scalable PWA / Mobile App Project Overview I am developing an anime and cosplay event platform. Current Architecture • WordPress (PWA) — Frontend • Supabase (PostgreSQL) — Primary Database • Google Sheets — Internal Data Management • Google Apps Script (GAS) — Synchronizes Google Sheets with Supabase Google Sheets is primarily used as an internal CMS for event management, while Supabase serves as the production database. The project is under active development, and more features will continue to be added over time. Current Features • Event database • User authentication • Event participation logs • Reviews • Member-only features • Sales recording & management for exhibitors • Analytics dashboard What I'm Looking For I am NOT looking for feature development. Instead, I want an experienced backend/database engineer to review the overall architecture before the project grows further. Scope of Review 1. Database Design Please review: • Table structure • Relationships • Primary / Foreign Keys • Normalization • Constraints • Indexes • Query performance • Naming consistency • Scalability • Maintainability 2. Future Scalability I plan to continue expanding this project. Future plans include: • Keeping WordPress as a PWA • Potentially replacing the frontend • Developing native iOS / Android apps • Supporting multiple clients from the same backend I want to confirm that the current database architecture is suitable for long-term growth. 3. Backend & Code Review Please review: • Supabase schema • SQL • Row Level Security (RLS) • Google Apps Script synchronization • REST API structure • Data validation • Security I'm primarily interested in architectural quality rather than coding style. 4. Risk Assessment Please identify: • Poor schema design • Data duplication • Performance bottlenecks • Migration risks • Security concerns • Technical debt • Maintainability issues 5. Recommendations Please provide practical recommendations, including: • Database improvements • Better schema design • API improvements • Future-proof architecture • Migration strategy (if necessary) The goal is to establish a solid long-term foundation before adding more features. Current Tech Stack • WordPress • Supabase (PostgreSQL) • Google Sheets • Google Apps Script • REST APIs • Claude Code (AI-assisted development) Possible future technologies: • Flutter • React Native • Native iOS / Android • Next.js Deliverables I expect: • Architecture review report • Database review • Code review • List of issues (Critical / High / Medium / Low) • Improvement recommendations • Optional discussion meeting Required Skills • Senior Backend Engineer • Database Architect • PostgreSQL • Supabase • SQL Optimization • API Design • Database Modeling • System Architecture • Performance Optimization • Security Best Practices Experience with WordPress and Google Apps Script is a plus. Ideal Candidate Experience with products such as: • SaaS • Social platforms • Marketplace applications • Event platforms • Large-scale consumer web services I am looking for someone who can evaluate an existing architecture and suggest improvements before the project scales. Please Include When applying, please provide: • Similar projects • Relevant architecture review experience • Your review process • Estimated hours • Hourly rate or fixed-price quote This project is intended as an architecture review, but it may lead to ongoing backend consulting or future development work.