amrittttt/warpsql

WarpSQL

WarpSQL

Opinionated extensions to Postgres packaged as a single docker deployment. Why install 10 DBs when you can have everything at once (maybe not everything).

Certified as Indie Hacker's best friend!!!

Current and future supported extensions

• PgVector
• TimescaleDB
• Citus
• PostGIS
• ZomboDB
• PLV8
• Pg Repack

Bootstrapped from TimescaleDB

Usage with Compose

version: '3.6'
services:
  warpsql:
    container_name: warpsql
    image: samagragovernance/postgres:latest-pg15
    restart: always
    ports:
      - "5432:5432"
    volumes:
      - ./pgdata:/var/lib/postgresql/data
    environment:
      POSTGRES_USER: warpSQLUser
      POSTGRES_PASSWORD: warpSQLPass

WarpSQL is a powerful solution that provides opinionated extensions to Postgres, conveniently packaged as a single Docker deployment. It eliminates the need to install multiple separate databases by offering a comprehensive set of features in one place (although not everything, as some features might not be included).

By utilizing WarpSQL, you can benefit from the following:

• Simplified setup: With WarpSQL, you can have all the necessary extensions for your Postgres database in one go, saving you time and effort.
• Seamless integration: WarpSQL includes popular extensions like PgVector, TimescaleDB, Citus, and PostGIS, allowing you to leverage their functionality seamlessly.
• Enhanced performance: The included extensions are carefully selected to optimize database performance, enabling you to work efficiently with large datasets.
• Extensibility: While WarpSQL already supports a range of extensions, it aims to expand its offerings to include even more powerful tools in the future, such as ZomboDB, PLV8, and Pg Repack. Get started with WarpSQL today and experience the convenience of a comprehensive Postgres solution.

Contribution

You can contribute to the development of WarpSQL using both Gitpod and Codespaces. Follow the steps below to set up your development environment and make contributions:

Gitpod

Click the "Open in Gitpod" button above or use the following link:Open in Gitpod

• Wait for the Gitpod environment to be created and initialized.
• Once the environment is ready, you can start working on the project.
• Make your desired changes or additions.
• Test your changes and ensure they meet the project's guidelines.
• Commit and push your changes to your forked repository.
• Create a pull request from your forked repository to the main WarpSQL repository.

GitHub Codespaces

You can use GitHub Codespaces to develop this project in the cloud.

• Click on the "Code" button.
• Select "Open with Codespaces" from the dropdown menu.
• Choose the appropriate Codespace configuration.
• Wait for the environment to be provisioned.

Once the environment is ready, you can start working on the project.

• Make your desired changes or additions.
• Test your changes and ensure they meet the project's guidelines.
• Commit and push your changes to your forked repository.
• Create a pull request from your forked repository to the main WarpSQL repository.
• We welcome contributions from the community and appreciate your support in improving WarpSQL!

Ensure CI passes

Before merging any contributions or changes, it's essential to ensure that the continuous integration (CI) tests pass successfully. CI helps maintain code quality standards and prevents the introduction of regressions. To ensure a smooth integration process, follow these steps:

• Make your desired changes or additions to the codebase.
• Run the relevant tests locally to verify that your changes are functioning as expected.
• Push your changes to the branch you're working on.
• The CI system will automatically run tests and checks on your code.
• Monitor the CI build status to ensure that all tests pass successfully.
• If the CI build fails, review the error messages and make the necessary fixes.
• Repeat steps 3-6 until the CI build passes successfully.
• Once the CI build is successful, you can proceed with merging your changes into the main WarpSQL repository.

Maintainers

Jayanth Kumar 💻