rawrnot project

ProjectIN PROGRESS

Full-stack creative platform: React 19 frontend, Vapor Swift backend, AI gateway, Cloud SQL PostgreSQL 15. 4-level hierarchy: Agencies → CRMClients → Projects → Deliverables.

Status Rollup

11 LIVE
1 INACTIVE
1 PLANNED
1 IN PROGRESS
1 ACTIVE

Children (15)

AnyssaUser

Owner on rawrnot project. Primary client/stakeholder for the raw'r'not platform.

LIVE
Agencia (role)User

Agency user role in rawrnot. Top of hierarchy: Agencies → CRMClients → Projects → Deliverables.

LIVE
Cliente (role)User

Client user role in rawrnot. Second tier in the Agencies → CRMClients → Projects → Deliverables hierarchy.

LIVE
Guest (role)User

Guest user role in rawrnot. Read-only / limited access.

LIVE
rawrnot frontendApp

React 19 + Vite + Tailwind 4 creative platform frontend deployed on Cloud Run (europe-west1). Served via rawrnot-proxy Cloudflare Worker.

LIVE
rawrnot core-backendApp

Vapor Swift backend + Cloud SQL PostgreSQL 15. TCP proxy fix deployed. Was crashing due to PSQLError Cloud SQL socket race on startup.

LIVE
rawrnot ai-gatewayApp

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.

INACTIVE
rawrnot-db (PostgreSQL 15)Database

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.

LIVE
Firestore (rawrnot)Database

Firebase Firestore on rawrnot GCP project. API enabled but not yet wired into the app.

PLANNED
repo: rawrnotRepo

Main rawrnot public GitHub repo. Description: 'rarwrnot'. Updated 2026-05-03.

LIVE
rawrnot production (GCP europe-west1)Environment

GCP rawrnot project production environment. Cloud Run (europe-west1) + Cloud SQL + Artifact Registry + Secret Manager.

LIVE
rawrnot local devEnvironment

Local development environment for rawrnot at /Users/piqui/Rawrnot_Workspace/.

IN PROGRESS
GCP: rawrnotEnvironment

Google Cloud project rawrnot (95154903089). Hosts frontend, core-backend, ai-gateway, Cloud SQL, Artifact Registry. europe-west1.

LIVE
rawrnot.comdomain

Primary domain for raw'r'not. Cloudflare DNS. Routed via rawrnot-proxy Worker to Cloud Run frontend + /api to core-backend. HTTP 200 (frontend).

LIVE
GCP rawrnot Project BillingBilling

GCP billing for the rawrnot project: Cloud Run, Cloud SQL, Artifact Registry, Secret Manager, Cloud Build.

ACTIVE
Registry v1.0.0 · Updated 5/14/2026 · 155 entities