Star Citizen Fan Site Rebuild
Budget: $250 – $750 USD
I have the complete PHP / MySQL source of an established Star Citizen fan portal and I want to port every single feature over to a modern stack: FastAPI for the backend, React JS on the client, and PostgreSQL 17 as the database.
Beyond replicating those original capabilities, this new codebase must move the project forward:
• Account system: Google and Discord OAuth, all wired to JWT-based sessions.
• Group module: admin can create or delete groups, assign roles inside them, and fine-tune permissions; these roles will later drive access control across the site.
• Reputation layer: actions on the site should feed a reputation score that we can surface in profiles and use for gating content.
• Access control: every route—both UI and API—needs guards that combine group role and reputation thresholds.
• Public & private REST APIs: each with rate-limited quotas, API-key issuance, key rotation, and a simple paid subscription flag that lifts limits.
• Loadout manager: players should be able to assemble, save, and share ship loadouts (we will discuss the exact data model once the core scaffold is in place).
The open-source reference gives you database schemas and UI flow, so you will not be starting from scratch; the job is rebuilding and extending it cleanly in Python 3.12+, React 18, and Postgres 17, while preserving all original functionality.
Deliverables
1. Containerised dev environment (Docker or similar) spinning up the full stack in one command.
2. Source code with clear module boundaries, typing, and inline docs.
3. OpenAPI collections for both APIs showing auth, quota errors, and success calls.
3. A short README walking through setup, env vars for OAuth, and how to run unit tests.
I can give you access to the current repo.
Beyond replicating those original capabilities, this new codebase must move the project forward:
• Account system: Google and Discord OAuth, all wired to JWT-based sessions.
• Group module: admin can create or delete groups, assign roles inside them, and fine-tune permissions; these roles will later drive access control across the site.
• Reputation layer: actions on the site should feed a reputation score that we can surface in profiles and use for gating content.
• Access control: every route—both UI and API—needs guards that combine group role and reputation thresholds.
• Public & private REST APIs: each with rate-limited quotas, API-key issuance, key rotation, and a simple paid subscription flag that lifts limits.
• Loadout manager: players should be able to assemble, save, and share ship loadouts (we will discuss the exact data model once the core scaffold is in place).
The open-source reference gives you database schemas and UI flow, so you will not be starting from scratch; the job is rebuilding and extending it cleanly in Python 3.12+, React 18, and Postgres 17, while preserving all original functionality.
Deliverables
1. Containerised dev environment (Docker or similar) spinning up the full stack in one command.
2. Source code with clear module boundaries, typing, and inline docs.
3. OpenAPI collections for both APIs showing auth, quota errors, and success calls.
3. A short README walking through setup, env vars for OAuth, and how to run unit tests.
I can give you access to the current repo.
Related categories:
PHP
JavaScript
MySQL
HTML
PostgreSQL
React.js
OAuth
Docker
API Development
FastAPI