Heroku Postgres logo

Heroku Postgres

Heroku's Database-as-a-Service. Based on the most powerful open-source database, PostgreSQL
260
151
+ 1
37

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
111 companies reportedly use Heroku Postgres in their tech stacks, including Luckycycle, FarmLogs, and Watsi.

Developers
125 developers on StackShare have stated that they 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.

Amazon EC2
Amazon EC2
PostgreSQL
PostgreSQL
Amazon EBS
Amazon EBS
Amazon RDS for PostgreSQL
Amazon RDS for PostgreSQL
Heroku Postgres
Heroku Postgres
Amazon RDS
Amazon RDS

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

See more
Tim Nolet
Tim Nolet
Founder, Engineer & Dishwasher at Checkly · | 10 upvotes · 39.7K views
atChecklyHQChecklyHQ
PostgreSQL
PostgreSQL
Heroku
Heroku
Heroku Postgres
Heroku Postgres
Node.js
Node.js
Knex.js
Knex.js

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 · 10K views
atKatana MRPKatana MRP
JavaScript
JavaScript
Heroku
Heroku
Heroku Postgres
Heroku Postgres
Node.js
Node.js
LoopBack
LoopBack
React
React
Heroku Redis
Heroku Redis

We undertook the task of building a manufacturing ERP for small branded manufacturers. We needed to build a lot, fast with a small team, and have clear focus on product delivery. We chose JavaScript / Node.js ( React + LoopBack full stack) , Heroku and Heroku Postgres (also Heroku Redis ) . This decision has guided us to picking other key technologies. It has granted us high pace of product delivery and service availability while operating with a small team.

See more
Matt Harris
Matt Harris
Heroku Postgres
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
Tyler Harden
Tyler Harden
Software Engineer at datapile · | 1 upvotes · 3.1K views
atdatapiledatapile
Heroku Postgres
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 · 2.7K views
Heroku Postgres
Heroku Postgres

Created several tables for users, brands, deals, campaigns, and tracking. 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.
Heroku Redis
Heroku Redis is an in-memory key-value data store, run by Heroku, that is provisioned and managed as an add-on. Heroku Redis is accessible from any language with a Redis driver, including all languages and frameworks supported by Heroku.
See all alternatives

Heroku Postgres's Followers
151 developers follow Heroku Postgres to keep up with related blogs and decisions.
praveen kumar
Balazs Horanyi
Jonathan Savage
Jarred Witt
John Alton
Mohamma76685757
Aaron Luna
Maurizio Casalino
J D
Le Tuan