Efficient React/Next.js Web Application Creation

Job ID: 39236847

Budget: $30 – $250 USD

React/Next.js App via SST.dev deploying into AWS.


**Objective:**
Build a proof-of-concept web application to render large datasets efficiently using React/Next.js (deployed via SST) and AWS infrastructure.

---

### ?️ **Frontend Requirements**
- Built using **React/Next.js** and deployed via **SST (Serverless Stack)**.
- Two main tabs:
- **Overview Tab**: Displays aggregated data from PostgreSQL (via API).
- **Report Tab**:
- Grouped by **US State**.
- On state selection, shows **vertical tabs** for that state’s products.
- Each product tab is **expandable** to display monthly sales history.
- Includes multi-select dropdowns for filtering:
- US State
- Product Group

---

### ?️ **Backend & Data Flow**
- Use **Amazon Aurora PostgreSQL** as the main data source.
- When the frontend requests a filtered report:
- A **Python Lambda function** is triggered.
- It fetches data from Aurora PostgreSQL and writes it to **AWS S3 as a CSV**.
- A **pre-signed S3 URL** is returned to the frontend.
- Frontend **polls the S3 URL** and renders the data table once available.

---

### ? **Other Requirements**
- No user login required; just a demo setup for POC.
- Must handle **large datasets** efficiently.
- Code should follow clean and modular structure using SST’s best practices.
- Deployment should be AWS-ready using SST (Mono-repo is mandatory).


Attaching here two csv sample data file to be imported automatically into the app on building and I should able to run it locally and see it in the AWS deployed.


Note: Only bid if you are having previous experience with sample to show you did worked on it, I want to award this right away to get the POC done in two days max (only to render the demo data to show that POC is possible and here is what I see as demo in similar manner from the author of sst.dev https://github.com/sst/demo-notes-app/tree/main - I want similar one but as per above spec)
Related categories: Python Amazon Web Services Node.js Next.js LaMDA