Mentee : Piyush Raj

​

Mentor : Karun Agarwal

CODE4GovTECH 2023

Midpoint Showcase

Plugins, Disaster Recovery, Benchmarking

​

Table of Contents

1. Introduction
2. Project Description
3. Planned Features
4. Milestones Covered
5. Live Demo
6. Learnings

​

​

About WarpSQL

• One-click deployment of PostgreSQL on AWS, AZURE, GCP.
• Smooth setup with options for both native and containerized environments
• Latest extensions and PostgreSQL, all pre-configured and ready to use.

​

WarpSQL is a powerful solution that provides extensions to Postgres, conveniently packaged as a single deployment. It eliminates the need to install multiple separate databases by offering a comprehensive set of features in one place.

​

​

Planned Features

​

​

​

​

• Deployment solutions for Docker, AWS, Azure, and GCP.
• Disaster Recovery Management.
• Horizontal scaling of WarpSQL for high availability.
• Postgres Cluster Monitoring using Grafana.
• Benchmarking scripts.
• UI to Build Customized Images.

​

​

​

Milestones Covered

• Developed a Packer Template to create Docker images with selective extensions installation.
• Terraform script to launch a WarpSQL instance in EC2 on AWS with a single click.
• Created Packer templates to construct AWS AMI images.
• Implemented a workflow to build and test the AWS AMI images.
• workflow that comments on the size difference between the current Docker image and the one in a GitHub pull request.

​

​

Live Demo

Learnings

• Learned about EC2 instance management, different storage types in EC2, and the concept of AMI images. Studied AWS Identity and Access Management (IAM) and OIDC for security and access control.
• Terraform for infrastructure management.
• Packer for building images on multiple destinations.
• Developed skills in Bash scripting for infrastructure setup.
• Developed CI pipelines, gained understanding of workflow_run, artifacts, GitHub scripts, workflow security, and GitHub REST and GraphQL APIs.

​

​

​

​

Thank you!