FastAPI + Postgres + React SPA

overview

A decoupled architecture: Python FastAPI service exposing a JSON API, a React single-page app consuming it, and a native WebSocket endpoint for live message delivery. Sketched at overview depth.

For spec: Slack-like Messaging App

Frontend

React SPA (Vite)

Backend

FastAPI

Database

Postgres

ORM

SQLAlchemy + Alembic

Auth

JWT (python-jose)

Hosting

Render

5 tables8 routes0 modules4 packages0 env vars5 features uncovered

Packages

fastapipip

uvicornpip

sqlalchemypip

alembicpip

Feature implementations

Messaging

messaging

Messages table + WebSocket endpoint for per-channel subscription.

Tables

messages

Polymorphic on channel vs. DM

channels

channel_members

Routes

GET/api/channels

GET/api/messages

POST/api/messages

ANY/ws/channels/{channel_id}

WebSocket upgrade

Notifications

notifications

Delivered in-band over the same WebSocket connection.

Tables

notifications

Search

search

Postgres full-text search via tsvector.

Routes

GET/api/search

User System & Auth

user-system

Users authenticate with email+password, receive a JWT.

Tables

users

id, email, hashed_password, created_at

Routes

POST/api/auth/login

POST/api/auth/register

GET/api/me

Uncovered features

The spec includes features this implementation doesn't describe. Contributions welcome.

File StorageRoles & PermissionsAudit LoggingRate Limiting & Abuse PreventionOnboarding & Activation