Hydra is a high-performance Postgres database designed for online transaction processing (OLTP) and serverless online analytical processing (OLAP).

Using Postgres (rowstore only)

  • Billing & payments

  • Logistics and transportation

  • Multi-tenant web applications

  • CRM & customer records

  • E-Commerce

Using the analytics schema (columnstore only)

  • Business Intelligence (BI) & Reporting

  • Revenue & sales prediction

  • Market research

  • Financial reporting

  • Customer segmentation

  • Marketing campaign analysis

  • Offline ML / AI training

“Realtime,” joining Postgres with the analytics schema (row and columnstore)

  • Monitoring & telemetry

  • Financial services

  • Observability & metrics

  • Cybersecurity

  • Web & product analytics

  • Online gaming

  • Time series data

  • Geospatial

  • IOT

  • Online ML / AI training

Non-Target use case

  • Edge processing

  • Multi-region active/active

  • Ephemeral use

  • Offline / occasionally connected computing