Heroku Postgres logo
Heroku's Database-as-a-Service. Based on the most powerful open-source database, PostgreSQL

What is Heroku Postgres?

Heroku Postgres provides a SQL database-as-a-service that lets you focus on building your application instead of messing around with database management.
Heroku Postgres is a tool in the PostgreSQL as a Service category of a tech stack.

Who uses Heroku Postgres?

Companies
74 companies use Heroku Postgres in their tech stacks, including Open Humans, PullReview, and Churn Buster.

Developers
38 developers use Heroku Postgres.

Heroku Postgres Integrations

PostgreSQL, Heroku, CircleCI, Stitch, and Backand are some of the popular tools that integrate with Heroku Postgres. Here's a list of all 8 tools that integrate with Heroku Postgres.

Why developers like Heroku Postgres?

Here’s a list of reasons why companies and developers use Heroku Postgres
Heroku Postgres Reviews

Here are some stack decisions, common use cases and reviews by companies and developers who chose Heroku Postgres in their tech stack.

Tim Nolet
Tim Nolet
Founder, Engineer & Dishwasher at Checkly · | 10 upvotes · 4.2K views
atChecklyHQ
Knex.js
Node.js
Heroku Postgres
Heroku
PostgreSQL

PostgreSQL Heroku Heroku Postgres Node.js Knex.js

Last week we rolled out a simple patch that decimated the response time of a Postgres query crucial to Checkly. It quite literally went from an average of ~100ms with peaks to 1 second to a steady 1ms to 10ms.

However, that patch was just the last step of a longer journey:

  1. I looked at what API endpoints were using which queries and how their response time grew over time. Specifically the customer facing API endpoints that are directly responsible for rendering the first dashboard page of the product are crucial.

  2. I looked at the Heroku metrics such as those reported by heroku pg:outlier and cross references that with "slowest response time" statistics.

  3. I reproduced the production situation as best as possible on a local development machine and test my hypothesis that an composite index on a uuid field and a timestampz field would reduce response times.

This method secured the victory and we rolled out a new index last week. Response times plummeted. Read the full story in the blog post.

See more
Priit Kaasik
Priit Kaasik
Engineering Lead at Katana MRP · | 8 upvotes · 4.7K views
atKatana MRP
Heroku Postgres
Heroku
JavaScript

We undertook the task of building a manufacturing ERP for small and tiny craft workshops. To have clear focus on product delivery we chose JavaScript , Heroku and Heroku Postgres . This decision has guided us to picking other key technologies. It has granted us high pace of product delivery and service availability.

See more
Josh Frye
Josh Frye
Senior Software Engineer at StackShare · | 5 upvotes · 8K views
atStackShare
PostgreSQL
Amazon RDS for Aurora
Heroku Postgres
#StackDecisionsLaunch

We migrated from Heroku Postgres to Amazon RDS for Aurora not long ago. The driving force behind the migration was the increased performance and cloud tuned PostgreSQL instances. Pricing was also a factor, as RDS delivers more value for the price. We have a staging and production cluster that can be scaled up or down as we need capacity. Snapshots, backups, and maintenance are handled automatically, though the timeframes are configurable. They offer automatic failover, and multi-az replication #StackDecisionsLaunch

See more
Tyler Harden
Tyler Harden
Software Engineer at datapile · | 1 upvotes · 1K views
atdatapile
Heroku Postgres

We use heroku PostgreSQL databases for testing alongside our sandboxed application(s) in heroku.

Extremely simple, practically a one-click setup. Heroku Postgres

See more
Kyle Fretwell
Kyle Fretwell
Founder at Pouch · | 1 upvotes · 1K views
Heroku Postgres

Created several tables for users, brands, deals, campaigns, and tracking. Heroku Postgres

See more
Matt Harris
Matt Harris
Heroku Postgres

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. Heroku Postgres

See more

Heroku Postgres's features

  • High Availability
  • Rollback
  • Dataclips
  • Automated Health Checks

Heroku Postgres Alternatives & Comparisons

What are some alternatives to Heroku Postgres?
MongoDB
MongoDB stores data in JSON-like documents that can vary in structure, offering a dynamic, flexible schema. MongoDB was also designed for high availability and scalability, with built-in replication and auto-sharding.
ClearDB
ClearDB uses a combination of advanced replication techniques, advanced cluster technology, and layered web services to provide you with a MySQL database that is "smarter" than usual.
Heroku
Heroku is a cloud application platform – a new way of building and deploying web apps. Heroku lets app developers spend 100% of their time on their application code, not managing servers, deployment, ongoing operations, or scaling.
Google Cloud SQL
MySQL databases deployed in the cloud without a fuss. Google Cloud Platform provides you with powerful databases that run fast, don’t run out of space and give your application the redundant, reliable storage it needs.
Amazon RDS for PostgreSQL
Amazon RDS manages complex and time-consuming administrative tasks such as PostgreSQL software installation and upgrades, storage management, replication for high availability and back-ups for disaster recovery. With just a few clicks in the AWS Management Console, you can deploy a PostgreSQL database with automatically configured database parameters for optimal performance. Amazon RDS for PostgreSQL database instances can be provisioned with either standard storage or Provisioned IOPS storage. Once provisioned, you can scale from 10GB to 3TB of storage and from 1,000 IOPS to 30,000 IOPS.
See all alternatives

Heroku Postgres's Stats

- No public GitHub repository available -