Hospital Management System

Situation

The system needed to store two distinctly different types of data — structured relational records (users, appointments, prescriptions) and long-form unstructured content like notifications that had no relational ties.

Decision

PostgreSQL handles all relational data where joins and referential integrity matter. DynamoDB stores content that is too lengthy or unstructured for a relational model — such as notifications — where a flexible schema and fast key-based access are more appropriate.

Situation

The client wanted to use AWS services and the system was in early build phase with low traffic.

Decision

Lambda and API Gateway over a traditional server. AWS charges only per invocation, so cost was near zero during development and low-traffic phases. The architecture also scales automatically without provisioning or managing servers.

Situation

The system needed secure authentication with user management, without building it from scratch.

Decision

Used AWS Cognito — a managed service that handles authentication, authorization, and user management out of the box. It eliminated the need to build and maintain auth infrastructure while meeting security requirements at near-zero cost.