Heimdall Database Proxy vs Odyssey
Heimdall Database Proxy
heimdalldata.comOdyssey
pg-odyssey.techSide by side
| Figure | Heimdall Database Proxy | Odyssey |
|---|---|---|
| Price from | — | — |
| Free plan | — | — |
| Free trial | Yes | — |
| Open source | — | — |
| macOS | — | Yes |
| Linux | Yes | Yes |
| Self-hosted | Yes | Yes |
| Plans published | 3 | 0 |
| Spec score · Database Proxy Software | 7.7 (#10) | 7.5 (#17) |
| Authentication | The overview says the proxy supports authentication and authorization through Active Directory integration. | Odyssey supports SSL/TLS, md5 and clear-text authentication, and PAM and LDAP authentication. |
| Deployment | The proxy can be deployed as a transparent sidecar process and is described as usable on-premise or in the cloud. | Odyssey can be installed from the PGDG repository, run from a public Docker image, or built locally. |
| Purpose | The Database Proxy is a data access layer that routes, caches, and secures SQL queries between an application and its database. | Odyssey is an advanced, multithreaded PostgreSQL connection pooler and request router. |
| Read/write routing | It routes reads to replicas and writes to primary databases, with replication-lag detection to support consistency. | Target session attributes can route connections to PostgreSQL hosts according to read-write or read-only requirements. |
| Support | The download page directs users to Heimdall Data for technical support and says technical support requires upgrading the Greenplum Community Edition to Enterprise. | Users can report issues on the project page or ask usage and development questions in the Telegram community; the project says responses may not be quick. |
Plans
Heimdall Database Proxy
- Enterprise EditionPriced on request
- Enterprise Plus EditionPriced on request
- Standard EditionPriced on request
In their own words
Heimdall Database Proxy
Heimdall Database Proxy is a data access layer between an application and its database, routing, caching, and securing SQL queries. It can send reads to replicas and writes to primary databases, with replication-lag detection to support consistency. Frequently used queries can be cached with automatic expiry and invalidation rules to reduce database load and latency. Connection pooling can reduce front-side to back-side connections by up to a 1000:1 ratio. The proxy provides live SQL visibility, bottleneck identification, and auto-tuning recommendations, and can run as a transparent sidecar on-premise or in the cloud. Supported databases include MySQL, PostgreSQL, Amazon RDS, Oracle, SQL Server, MariaDB, DB2, Greenplum, and Redshift. Listed cloud integrations include AWS, Azure, Oracle, Google Cloud, and Redis. Active Directory integration supports authentication and authorization. Enterprise Plus includes data masking, GDPR auditing, and honey-tokens. A free Greenplum Community Edition is available for Greenplum use, with pooling, LDAP synchronization for one server, and SQL performance analytics. The AWS Marketplace listing offers a free 30-day trial; technical support for the Community Edition requires an Enterprise upgrade.