Social Platform 2000

Overview #

A full-stack forum application. The backend provides ASP.NET Core APIs with Entity Framework and Postgres; the frontend is a React app styled with Tailwind. Docker dev containers simplify setup.

flowchart TD
  User["End user"]
  Proxy["Reverse proxy<br/>HTTPS termination / API gateway"]

  subgraph Api["REST API (presentation layer)"]
    direction LR
    Ctrls["PostsController<br/>CategoryController<br/>CommentsController"]
  end

  subgraph Services["Service layer"]
    direction LR
    Svcs["PostService · CategoryService · CommentsService<br/><i>behind IPostService / ICategoryService / ICommentsService</i>"]
  end

  subgraph Infra["Infrastructure"]
    direction TB
    Wrapper["IRepositoryWrapper<br/><i>over IRepositoryBase</i>"]
    Repos["PostRepository · CategoryRepository · CommentsRepository"]
    Ctx["ApplicationDbContext (EF Core)"]
    Wrapper --> Repos
    Repos --> Ctx
  end

  DB[("PostgreSQL")]

  User --> Proxy
  Proxy --> Ctrls
  Ctrls --> Svcs
  Svcs --> Wrapper
  Ctx --> DB

erDiagram
  Categories ||--o{ Posts : "groups"
  Posts ||--o{ Comments : "has"
  Comments ||--o{ Comments : "replies to"

  Categories {
    int CategoryId PK
    string Title
    datetime CreatedDate
    datetime UpdatedDate
  }
  Posts {
    int PostId PK
    string Title
    string Content
    int CategoryId FK
    datetime CreatedDate
    datetime UpdatedDate
  }
  Comments {
    int CommentId PK
    string AuthorName
    string Content
    int PostId FK
    int ParentCommentId FK
    datetime CreatedDate
    datetime UpdatedDate
  }
  ApplicationUsers {
    guid Id PK
    string Username
    string PasswordHash
    datetime CreatedDate
    datetime UpdatedDate
  }

Highlights #

• ASP.NET Core API with Entity Framework and Postgres.
• React + Tailwind frontend for the forum experience.
• Dockerized dev container for consistent tooling.
• EF migrations for schema evolution; diagrams included for architecture and DB.

Notes #

• Dev container ready in VS Code; backend scripts handle migrations.
• Postgres assumed as the database; adjust connection strings per environment.