/hydra

The open source Snowflake alternative. OLAP Postgres

Primary LanguageCApache License 2.0Apache-2.0

Hydra - the open source data warehouse

Get a 14-day Free Trial - Documentation - Demo - Website

The open source Snowflake alternative. OLAP Postgres.

Hydra is an open source data warehouse built on Postgres. It’s easy to use and designed for OLAP and HTAP workloads. Hydra serves analytical reporting with parallelized query execution and vectorization on columnar storage. Operational work and high-throughput transactions write to standard Postgres heap tables. All Postgres extensions, tools, and connectors work with Hydra.

Eliminate data silos today. Solve hard problems fast.

  • πŸ—ƒ hosted postgres database - docs
  • πŸ“Ž append-only columnar store - docs
  • πŸ“Š external tables - docs
  • πŸ“… postgres scheduler - docs
  • πŸ€Ήβ€β™€οΈ query parallelization
  • 🐎 vectorized execution of WHERE clauses
  • πŸ“ updates and deletes for columnar store
  • 🧹 vacuum stripe optimizations and space reclamation
  • 🏎️ vectorized execution of aggegate functions
  • πŸš… use of SIMD in vectorized execution
  • ↔️ separation of compute and storage

Where does Hydra fit

⏩ Quick Start

The Hydra Docker image is a drop-in replacement for postgres Docker image.

You can also try out Hydra locally using docker-compose.

git clone https://github.com/hydradatabase/hydra && cd hydra
cp .env.example .env
docker compose up
psql postgres://postgres:hydra@127.0.0.1:5432

Or

Managed in the cloud.

πŸ“„ Documentation

You can find our documentation here.

πŸ‘©πŸΎβ€πŸ€β€πŸ‘¨πŸ» Community

βœ… Status

  • Early Access: Closed, private testing
  • Open Alpha: Open for everyone
  • Open Beta: Hydra can handle most non-enterprise use
  • Production: Enterprise ready

We are currently in Early Access. Watch releases of this repo to get notified of updates.

follow the repo

πŸ›  Developing Hydra

Please see DEVELOPERS.md for information on contributing to Hydra and building the image.

πŸ“‘ License and Acknowledgments

Hydra is only possible by building on the shoulders of giants.

The code in this repo is licensed under:

The docker image is built on the Postgres docker image, which contains a large number of open source projects, including:

  • Postgres - the Postgres license
  • Debian or Alpine Linux image, depending on the image used
  • Hydra includes the following additional software in the image:
    • multicorn - BSD license
    • mysql_fdw - MIT-style license
    • parquet_s3_fdw - MIT-style license
    • pgsql-http - MIT license

As for any pre-built image usage, it is the image user's responsibility to ensure that any use of this image complies with any relevant licenses for all software contained within.