Apex vs Heroku Postgres: What are the differences?
Developers describe Apex as "Serverless Architecture with AWS Lambda". Apex is a small tool for deploying and managing AWS Lambda functions. With shims for languages not yet supported by Lambda, you can use Golang out of the box. On the other hand, Heroku Postgres is detailed as "Heroku's Database-as-a-Service. Based on the most powerful open-source database, PostgreSQL". Heroku Postgres provides a SQL database-as-a-service that lets you focus on building your application instead of messing around with database management.
Apex can be classified as a tool in the "Serverless / Task Processing" category, while Heroku Postgres is grouped under "PostgreSQL as a Service".
Some of the features offered by Apex are:
- Supports languages Lambda does not natively support via shim, such as Go
- Binary install (useful for continuous deployment in CI etc)
- Project level function and resource management
On the other hand, Heroku Postgres provides the following key features:
- High Availability
Apex is an open source tool with 7.82K GitHub stars and 567 GitHub forks. Here's a link to Apex's open source repository on GitHub.
What is Apex?
What is Heroku Postgres?
Need advice about which tool to choose?Ask the StackShare community!
Why do developers choose Apex?
What are the cons of using Apex?
Sign up to get full access to all the companiesMake informed product decisions
Sign up to get full access to all the tool integrationsMake informed product decisions
I could spin up an Amazon EC2 instance and install PostgreSQL myself, review latest configuration best practices, sort Amazon EBS storage for data, set up a snapshot process etc.
Alternatively I could use Amazon RDS, Amazon RDS for PostgreSQL or Heroku Postgres and have most of that work handled for me, by a team of world experts...
Stores the admin database for the SRX apps - includes an audit log, error tracking, and SRX admin message log.
Will also store PRS rules when refactor is complete.
Rock solid transactional storage of user, purchase and course activity data. During development database dumps were easy to create and download locally for testing.
We use heroku PostgreSQL databases for testing alongside our sandboxed application(s) in heroku.
Extremely simple, practically a one-click setup.
4 years of experience using Heroku Postgres for data storage and management.