1 of 8

Mentee : Piyush Raj

Mentor : Karun Agarwal

CODE4GovTECH 2023

Midpoint Showcase

Plugins, Disaster Recovery, Benchmarking

2 of 8

Table of Contents

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

3 of 8

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.

4 of 8

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.

5 of 8

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.

6 of 8

Live Demo

7 of 8

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.

8 of 8

Thank you!