AWS Typescript expert with Lambda PostgreSQL Integration -- 2
Budget: $30 – $250 AUD
### **Project Title:**
AWS Lambda Project Setup and Deployment with Prisma, API Gateway, and PostgreSQL Integration
### **Project Description:**
We are seeking an experienced AWS developer to set up and deploy a serverless application using AWS Lambda functions, Prisma ORM, and API Gateway. The goal is to establish a robust, secure, and scalable architecture that supports rapid development and easy deployment from a local development environment (VS Code).
### **Scope of Work:**
1. **Directory Structure Setup:**
- The provided codebase includes a directory structure that needs to be organized and extended to create a fully functional system. Below is the expected directory structure:
```bash
my-serverless-project/
├── src/
│ ├── lambdas/
│ │ ├── lambda1/
│ │ │ ├── handler.ts
│ │ │ ├── index.ts
│ │ └── lambda2/
│ │ ├── handler.ts
│ │ ├── index.ts
│ ├── common/
│ │ ├── prismaClient.ts
│ │ └── util/
│ │ ├── logger.ts
├── prisma/
│ ├── schema.prisma
├── node_modules/
├── tsconfig.json
├── package.json
└── serverless.yml
```
- **Objective**: Organize the existing code to fit into this structure, ensuring that common utilities, the Prisma client, and Lambda functions are correctly set up to work together.
2. **Prisma and PostgreSQL Integration:**
- The project involves working with 8-19 Prisma schema tables, which will be shared across all Lambda functions.
- Connect the Lambda functions to a PostgreSQL database using Prisma.
- Secure the database connection with appropriate networking configurations (e.g., VPC, security groups).
- Demonstrate the Lambda functions performing CRUD operations on the PostgreSQL database.
3. **AWS Lambda Setup:**
- Implement and deploy 6-8 Lambda services (functions) using the structure above.
- Ensure the Lambda functions can call one another to perform operations.
- Implement the necessary code to support inter-Lambda communication and API Gateway integration.
4. **API Gateway Configuration:**
- Configure AWS API Gateway to expose the Lambda functions via RESTful endpoints.
- Support multiple HTTP methods (GET, POST, PUT, DELETE) as required.
- Ensure that API Gateway and Lambda integration is seamless, secure, and supports easy updates.
5. **Security and Networking:**
- Set up a secure environment for the Lambda functions, including appropriate IAM roles and policies.
- Configure networking to ensure secure communication between the Lambdas and the PostgreSQL database.
- Implement best practices for security, including encryption at rest and in transit, and secure environment variable management.
6. **Deployment Automation:**
- Create an automated deployment pipeline that allows easy deployment from the local development environment (VS Code).
- Use the Serverless Framework or AWS SAM to manage the deployment process.
- Ensure that the deployment process is parameterized and supports different environments (e.g., dev, staging, production).
### **Deliverables:**
- A fully functional and secure AWS serverless application deployed and connected to a PostgreSQL database.
- Complete setup and configuration of AWS Lambda, API Gateway, and networking components using the provided directory structure.
- A production-ready system where 6-8 Lambda services are stitched together to interact with 8-19 Prisma schema tables.
- Documentation on how to:
- Develop, test, and deploy the application from a local development environment.
- Configure API Gateway and Lambdas for additional endpoints or functionalities.
- Manage database connections and Prisma schema updates.
- A short demonstration or walkthrough of the deployed solution.
### **Skills Required:**
- AWS Lambda
- AWS API Gateway
- Serverless Framework / AWS SAM
- Prisma ORM
- PostgreSQL
- TypeScript
- Networking & Security (VPC, IAM, etc.)
- DevOps (CI/CD, automated deployments)
- Familiarity with VS Code for development and deployment
### **Additional Notes:**
- The freelancer will be provided with a codebase that includes Lambda functions, Prisma schema, and other necessary components. The main task is to stitch this code together into a working system that can be deployed to AWS.
- The ideal candidate should have prior experience setting up similar serverless architectures on AWS.
- The solution should be designed with scalability, security, and ease of maintenance in mind.
- Familiarity with best practices for AWS Lambda and API Gateway is essential.
---
This version of the project description clearly outlines the scope and the specific requirements regarding the number of Prisma schema tables and Lambda services, making it easier for freelancers to understand the project's complexity and deliverables.
AWS Lambda Project Setup and Deployment with Prisma, API Gateway, and PostgreSQL Integration
### **Project Description:**
We are seeking an experienced AWS developer to set up and deploy a serverless application using AWS Lambda functions, Prisma ORM, and API Gateway. The goal is to establish a robust, secure, and scalable architecture that supports rapid development and easy deployment from a local development environment (VS Code).
### **Scope of Work:**
1. **Directory Structure Setup:**
- The provided codebase includes a directory structure that needs to be organized and extended to create a fully functional system. Below is the expected directory structure:
```bash
my-serverless-project/
├── src/
│ ├── lambdas/
│ │ ├── lambda1/
│ │ │ ├── handler.ts
│ │ │ ├── index.ts
│ │ └── lambda2/
│ │ ├── handler.ts
│ │ ├── index.ts
│ ├── common/
│ │ ├── prismaClient.ts
│ │ └── util/
│ │ ├── logger.ts
├── prisma/
│ ├── schema.prisma
├── node_modules/
├── tsconfig.json
├── package.json
└── serverless.yml
```
- **Objective**: Organize the existing code to fit into this structure, ensuring that common utilities, the Prisma client, and Lambda functions are correctly set up to work together.
2. **Prisma and PostgreSQL Integration:**
- The project involves working with 8-19 Prisma schema tables, which will be shared across all Lambda functions.
- Connect the Lambda functions to a PostgreSQL database using Prisma.
- Secure the database connection with appropriate networking configurations (e.g., VPC, security groups).
- Demonstrate the Lambda functions performing CRUD operations on the PostgreSQL database.
3. **AWS Lambda Setup:**
- Implement and deploy 6-8 Lambda services (functions) using the structure above.
- Ensure the Lambda functions can call one another to perform operations.
- Implement the necessary code to support inter-Lambda communication and API Gateway integration.
4. **API Gateway Configuration:**
- Configure AWS API Gateway to expose the Lambda functions via RESTful endpoints.
- Support multiple HTTP methods (GET, POST, PUT, DELETE) as required.
- Ensure that API Gateway and Lambda integration is seamless, secure, and supports easy updates.
5. **Security and Networking:**
- Set up a secure environment for the Lambda functions, including appropriate IAM roles and policies.
- Configure networking to ensure secure communication between the Lambdas and the PostgreSQL database.
- Implement best practices for security, including encryption at rest and in transit, and secure environment variable management.
6. **Deployment Automation:**
- Create an automated deployment pipeline that allows easy deployment from the local development environment (VS Code).
- Use the Serverless Framework or AWS SAM to manage the deployment process.
- Ensure that the deployment process is parameterized and supports different environments (e.g., dev, staging, production).
### **Deliverables:**
- A fully functional and secure AWS serverless application deployed and connected to a PostgreSQL database.
- Complete setup and configuration of AWS Lambda, API Gateway, and networking components using the provided directory structure.
- A production-ready system where 6-8 Lambda services are stitched together to interact with 8-19 Prisma schema tables.
- Documentation on how to:
- Develop, test, and deploy the application from a local development environment.
- Configure API Gateway and Lambdas for additional endpoints or functionalities.
- Manage database connections and Prisma schema updates.
- A short demonstration or walkthrough of the deployed solution.
### **Skills Required:**
- AWS Lambda
- AWS API Gateway
- Serverless Framework / AWS SAM
- Prisma ORM
- PostgreSQL
- TypeScript
- Networking & Security (VPC, IAM, etc.)
- DevOps (CI/CD, automated deployments)
- Familiarity with VS Code for development and deployment
### **Additional Notes:**
- The freelancer will be provided with a codebase that includes Lambda functions, Prisma schema, and other necessary components. The main task is to stitch this code together into a working system that can be deployed to AWS.
- The ideal candidate should have prior experience setting up similar serverless architectures on AWS.
- The solution should be designed with scalability, security, and ease of maintenance in mind.
- Familiarity with best practices for AWS Lambda and API Gateway is essential.
---
This version of the project description clearly outlines the scope and the specific requirements regarding the number of Prisma schema tables and Lambda services, making it easier for freelancers to understand the project's complexity and deliverables.