Database As Code

This post introduces the concept about how one can manage PostgreSQL database as a Code using Terraform and GitOps Approach on any Environment/Infra:

🤔𝐂𝐨𝐦𝐩𝐨𝐧𝐞𝐧𝐭𝐬 𝐮𝐬𝐞𝐝:

1. Terraform PostgreSQL Provider : Allows you to manage various aspects like below:

   • User and Role Management.

   • Database Creation.

   • Granting Permissions to Users and Roles.

   • Extension Management on PostgreSQL.

   • Replication Management for HA and DR

2. GitHub 𝐀𝐜𝐭𝐢𝐨𝐧𝐬 𝐮𝐬𝐢𝐧𝐠 𝐒𝐞𝐥𝐟 𝐇𝐨𝐬𝐭𝐞𝐝 𝐨𝐫 𝐆𝐢𝐭𝐡𝐮𝐛 𝐇𝐨𝐬𝐭𝐞𝐝 𝐑𝐮𝐧𝐧𝐞𝐫𝐬: To bootstrap Terraform PostgreSQL provider for Deployment using Actions Workflow on any environment/infra.

GitHub Repo Reference: Database As Code