AWS warpSQL deployment

[PiyushRaj927]

Related PR #94 This PR

1. Updates the packer script to build AMI images.
2. Introduces a Terraform script to launch of an AWS EC2 instance of WarpSQL.
3. Implements a workflow test to automate AMI image building and testing.

The workflow is using GitHub OIDC for AWS credentials(https://github.com/aws-actions/configure-aws-credentials/tree/v2.2.0/#assuming-a-role)

My suggestion is to run it in an environment where only approved workflows can be executed more details: https://docs.github.com/en/actions/deployment/targeting-different-environments/using-environments-for-deployment#deployment-protection-rules

[github-actions[bot]]

:bar_chart: bitnami Image Analysis (Commit: 2d6056ea85435c6a63679bf247fc66d627ac5fff )

Summary

• Current Size: 2.24 GiB [-0.44 % :small_red_triangle_down:]
• Previous Size : 2.25 GiB

[github-actions[bot]]

:bar_chart: normal Image Analysis (Commit: 2d6056ea85435c6a63679bf247fc66d627ac5fff )

Summary

• Current Size: 2.6 GiB [0.00 % :small_red_triangle_down:]
• Previous Size : 2.6 GiB

[github-actions[bot]]

:bar_chart: bitnami Image Analysis (Commit: 864dc4b40139f3c3cfe4d37d8b4367dd991224e3 )

Summary

• Current Size: 2.24 GiB [-0.44 % :small_red_triangle_down:]
• Previous Size : 2.25 GiB

[github-actions[bot]]

:bar_chart: normal Image Analysis (Commit: 864dc4b40139f3c3cfe4d37d8b4367dd991224e3 )

Summary

• Current Size: 2.6 GiB [0.00 % :small_red_triangle_down:]
• Previous Size : 2.6 GiB

[PiyushRaj927]

I have successfully tested the workflow for all the extensions except ZomboDB. Unfortunately, I encountered difficulties compiling it on an EC2 instance under the AWS free tier due to resource limitations. Workflow run: https://github.com/PiyushRaj927/WarpSQL/actions/runs/5670382808

[github-actions[bot]]

:bar_chart: bitnami Image Analysis (Commit: d453b905282fbeec447882be8d89808797b629c4 )

Summary

• Current Size: 2.24 GiB [-0.44 % :small_red_triangle_down:]
• Previous Size : 2.25 GiB

[github-actions[bot]]

:bar_chart: normal Image Analysis (Commit: d453b905282fbeec447882be8d89808797b629c4 )

Summary

• Current Size: 2.6 GiB [0.00 % :small_red_triangle_down:]
• Previous Size : 2.6 GiB

[github-actions[bot]]

:bar_chart: bitnami Image Analysis (Commit: 23d4e90c87fb4d560c11fa1dba3d903738e90529 )

Summary

• Current Size: 2.24 GiB [-0.44 % :small_red_triangle_down:]
• Previous Size : 2.25 GiB

[github-actions[bot]]

:bar_chart: normal Image Analysis (Commit: 23d4e90c87fb4d560c11fa1dba3d903738e90529 )

Summary

• Current Size: 2.6 GiB [0.00 % :small_red_triangle_down:]
• Previous Size : 2.6 GiB

[PiyushRaj927]

As we expand to more platforms, rebuilding certain extensions like ZomboDB and PostgreSQL for cloud images appears inefficient in terms of resources and time. A better approach would be to cache the build process to significantly speed up build times. Any other suggestions or comments on this approach?

[github-actions[bot]]

:bar_chart: bitnami Image Analysis (Commit: 12c6048d7ef2907196f8b6e53a60026455f2b74b )

Summary

• Current Size: 2.24 GiB [-0.44 % :small_red_triangle_down:]
• Previous Size : 2.25 GiB

[github-actions[bot]]

:bar_chart: normal Image Analysis (Commit: 12c6048d7ef2907196f8b6e53a60026455f2b74b )

Summary

• Current Size: 2.6 GiB [0.00 % :small_red_triangle_down:]
• Previous Size : 2.6 GiB

[github-actions[bot]]

:bar_chart: bitnami Image Analysis (Commit: b54fe995b43128d3f45867af94f996a0cf08bc4d )

Summary

• Current Size: 2.24 GiB [-0.44 % :small_red_triangle_down:]
• Previous Size : 2.25 GiB

[github-actions[bot]]

:bar_chart: normal Image Analysis (Commit: b54fe995b43128d3f45867af94f996a0cf08bc4d )

Summary

• Current Size: 2.6 GiB [0.00 % :small_red_triangle_down:]
• Previous Size : 2.6 GiB