[DMP 2024]: Support for Dynamically Built Images

[singhalkarun]

Ticket Contents

Description

Currently, WarpSQL CI builds PostgreSQL images with all extensions included, resulting in large image sizes with unused extensions. This approach also limits our ability to support additional extensions and maintain compatibility documentation between extension versions and PostgreSQL versions. To address this, we need to modify our existing build script and system to allow users to select extensions for their PostgreSQL images and provide a compatibility matrix for reference.

Goals & Mid-Point Milestone

Goals

• Develop a build system capable of creating custom PostgreSQL images based on user requirements, preferably utilizing GitHub Actions.
• Generate an automatically updated compatibility matrix for user reference.

Expected Outcome

WarpSQL users will have access to on-demand, optimized custom PostgreSQL images tailored to their needs.

Acceptance Criteria

• Build system successfully creates custom PostgreSQL images based on user specifications.
• Compatibility matrix is generated and accessible for user reference.

Implementation Details

The implementation is still in draft phase. Some initial ideas include:

• Developing a system similar to the ease of use provided by https://nixery.dev/ but within the ghcr.io container registry environment
• Utilizing multi-stage builds to optimize image size and performance.

Product Name

WarpSQL

Organisation Name

SamagraX

Domain

Open Source Library

Tech Skills Needed

Docker
Github Actions

Mentor(s)
@PiyushRaj927

Category

Databases

[AbhimanyuSamagra]

Do not ask process related questions about how to apply and who to contact in the above ticket. The only questions allowed are about technical aspects of the project itself. If you want help with the process, you can refer instructions listed on Unstop and any further queries can be taken up on our Discord channel titled DMP queries. Here's a Video Tutorial on how to submit a proposal for a project.