rawrnot project
ProjectIN PROGRESSFull-stack creative platform: React 19 frontend, Vapor Swift backend, AI gateway, Cloud SQL PostgreSQL 15. 4-level hierarchy: Agencies → CRMClients → Projects → Deliverables.
Status Rollup
Children (15)
Owner on rawrnot project. Primary client/stakeholder for the raw'r'not platform.
Agency user role in rawrnot. Top of hierarchy: Agencies → CRMClients → Projects → Deliverables.
Client user role in rawrnot. Second tier in the Agencies → CRMClients → Projects → Deliverables hierarchy.
Guest user role in rawrnot. Read-only / limited access.
React 19 + Vite + Tailwind 4 creative platform frontend deployed on Cloud Run (europe-west1). Served via rawrnot-proxy Cloudflare Worker.
Vapor Swift backend + Cloud SQL PostgreSQL 15. TCP proxy fix deployed. Was crashing due to PSQLError Cloud SQL socket race on startup.
Node.js AI gateway for the rawrnot platform. 9 knowledge docs fixed in Dockerfile. Returns 404 on root (no root route) but service is up.
Cloud SQL PostgreSQL 15 instance — rawrnot primary database. db-custom-2-4096, 20GB, europe-west1, IP: 35.240.116.12. DATABASE_URL and DB_PASSWORD in Secret Manager.
Firebase Firestore on rawrnot GCP project. API enabled but not yet wired into the app.
Main rawrnot public GitHub repo. Description: 'rarwrnot'. Updated 2026-05-03.
GCP rawrnot project production environment. Cloud Run (europe-west1) + Cloud SQL + Artifact Registry + Secret Manager.
Local development environment for rawrnot at /Users/piqui/Rawrnot_Workspace/.
Google Cloud project rawrnot (95154903089). Hosts frontend, core-backend, ai-gateway, Cloud SQL, Artifact Registry. europe-west1.
Primary domain for raw'r'not. Cloudflare DNS. Routed via rawrnot-proxy Worker to Cloud Run frontend + /api to core-backend. HTTP 200 (frontend).
GCP billing for the rawrnot project: Cloud Run, Cloud SQL, Artifact Registry, Secret Manager, Cloud Build.