Trade offs/Tech choices

Explain any trade offs you have made and why you made certain tech choices...

Scalability
- Vertical Scaling vs. Horizontal Scaling:
  - Vertical Scaling: Involves upgrading existing server resources (CPU/RAM), limited by the maximum capacity of the machine.
  - Horizontal Scaling: Involves adding more servers to distribute the load, facilitating better scalability but requiring load balancing and data synchronization.
- Trade-off: Vertical scaling is simpler but limited, while horizontal scaling can handle more growth but requires more effort in management.
Load Balancer Choices
- Layer 4 Load Balancer (Transport Layer): Handles TCP traffic, offering high performance, but doesn't have visibility into HTTP request content.
- Layer 7 Load Balancer (Application Layer): Can make routing decisions based on HTTP request content, enabling functionalities like cookie-based session persistence.
- Trade-off: Layer 7 provides more features at the cost of slightly increased latency compared to Layer 4.
Database Choice
- SQL vs. NoSQL:
  - SQL (e.g., MySQL, PostgreSQL): Enforces data integrity and supports complex queries, but can be slower for write operations and scaling horizontally.
  - NoSQL (e.g., MongoDB, DynamoDB): Allows for horizontal scaling and can handle large amounts of unstructured data but may lack ACID compliance.
- Trade-off: SQL provides better relational support but may require more effort to scale, while NoSQL offers scalability at the cost of transactional integrity.