{
  "id": "stack-profile:social-media-platform",
  "_kind": "StackProfile",
  "_file": "domain/stack-profiles/deep-stacks-3.yaml",
  "_cluster": "domain",
  "attributes": {
    "displayName": "Social Media Platform Stack (React, GraphQL, PostgreSQL, Redis, Elasticsearch)",
    "description": "A social media and content-sharing platform architecture using React\nfor the web client, GraphQL (via Yoga or Apollo) for a flexible query\nlayer that lets mobile and web clients fetch exactly the data they need,\nand PostgreSQL for core relational data (users, posts, relationships).\nRedis handles feeds, caching, and real-time presence, while Elasticsearch\npowers full-text search over user-generated content. TypeScript provides\nend-to-end type safety across client and server. This stack scales\nhorizontally but requires careful denormalization of social-graph queries\nand a robust moderation pipeline. The primary tradeoff is operational\ncomplexity — feed ranking, content moderation, and abuse prevention\nadd significant infrastructure beyond the core data layer.\n",
    "composes": [
      "framework:react",
      "language:graphql",
      "language:typescript",
      "library:ioredis",
      "tool:elasticsearch",
      "library:yoga",
      "library:prisma"
    ]
  },
  "outgoingEdges": [
    {
      "from": "stack-profile:social-media-platform",
      "to": "framework:react",
      "kind": "composed_of"
    },
    {
      "from": "stack-profile:social-media-platform",
      "to": "language:graphql",
      "kind": "composed_of"
    },
    {
      "from": "stack-profile:social-media-platform",
      "to": "language:typescript",
      "kind": "composed_of"
    },
    {
      "from": "stack-profile:social-media-platform",
      "to": "library:ioredis",
      "kind": "composed_of"
    },
    {
      "from": "stack-profile:social-media-platform",
      "to": "tool:elasticsearch",
      "kind": "composed_of"
    },
    {
      "from": "stack-profile:social-media-platform",
      "to": "library:yoga",
      "kind": "composed_of"
    },
    {
      "from": "stack-profile:social-media-platform",
      "to": "library:prisma",
      "kind": "composed_of"
    },
    {
      "from": "stack-profile:social-media-platform",
      "to": "tool:docker",
      "kind": "composed_of"
    },
    {
      "from": "stack-profile:social-media-platform",
      "to": "role:fullstack-engineer",
      "kind": "used_by_role"
    },
    {
      "from": "stack-profile:social-media-platform",
      "to": "role:backend-engineer",
      "kind": "used_by_role"
    },
    {
      "from": "stack-profile:social-media-platform",
      "to": "role:mobile-engineer",
      "kind": "used_by_role"
    },
    {
      "from": "stack-profile:social-media-platform",
      "to": "workflow:feature-development",
      "kind": "follows_workflow"
    },
    {
      "from": "stack-profile:social-media-platform",
      "to": "workflow:design-review",
      "kind": "follows_workflow"
    },
    {
      "from": "stack-profile:social-media-platform",
      "to": "domain:web-development",
      "kind": "applies_to"
    },
    {
      "from": "stack-profile:social-media-platform",
      "to": "domain:media-entertainment",
      "kind": "applies_to"
    },
    {
      "from": "stack-profile:social-media-platform",
      "to": "skill-area:graphql-schema-design",
      "kind": "requires_skill_area"
    },
    {
      "from": "stack-profile:social-media-platform",
      "to": "skill-area:search-indexing",
      "kind": "requires_skill_area"
    },
    {
      "from": "stack-profile:social-media-platform",
      "to": "skill-area:caching-strategies",
      "kind": "requires_skill_area"
    },
    {
      "from": "stack-profile:social-media-platform",
      "to": "skill-area:backend-api-design",
      "kind": "requires_skill_area"
    },
    {
      "from": "stack-profile:social-media-platform",
      "to": "skill-area:frontend-development",
      "kind": "requires_skill_area"
    }
  ],
  "incomingEdges": []
}