Need advice about which tool to choose?Ask the StackShare community!

ClearDB

27
83
+ 1
28
Heroku Postgres

634
311
+ 1
38
Add tool

ClearDB vs Heroku Postgres: What are the differences?

Introduction

ClearDB and Heroku Postgres are both popular database services used for storing and managing data in web applications. While they share similarities in terms of functionality, there are several key differences that set them apart. In this article, we will delve into the specific differences between ClearDB and Heroku Postgres.

  1. Pricing Models: ClearDB offers both free and paid plans, allowing users to choose the one that suits their needs best. On the other hand, Heroku Postgres follows a tiered pricing model, where users can select from different pricing tiers based on the amount of storage and performance required.

  2. Integration with Cloud Platforms: ClearDB is primarily associated with the Azure cloud platform, making it an excellent choice for developers who already utilize Azure services. On the contrary, Heroku Postgres is a native product of the Heroku platform, providing seamless integration and additional features specific to Heroku.

  3. Scalability: ClearDB allows users to scale their databases horizontally by adding read replicas, ensuring improved performance and redundancy. However, Heroku Postgres enables vertical scalability through its Continuous Protection feature, which automatically provisions more powerful database instances as the workload increases.

  4. Data Center Locations: ClearDB offers multiple data center locations around the world, allowing users to choose the one that best suits their geographical requirements. In contrast, Heroku Postgres primarily relies on the data center regions provided by the hosting platform (AWS, Azure, or Google Cloud), limiting the flexibility to select specific locations.

  5. Backup and Recovery: ClearDB provides automated backups and allows users to restore their databases to a previous state in case of data loss. Heroku Postgres offers continuous protection with rolling backups, allowing for point-in-time recovery and minimizing the risk of data loss.

  6. Support: ClearDB offers different support channels, including community forums, tickets, and phone support, to assist users with their database-related queries and concerns. On the other hand, Heroku Postgres leverages the existing support infrastructure provided by the Heroku platform, providing comprehensive support for its users.

In summary, ClearDB and Heroku Postgres differ in terms of pricing models, integration with cloud platforms, scalability options, data center locations, backup and recovery mechanisms, as well as support offerings.

Advice on ClearDB and Heroku Postgres

Considering moving part of our PostgreSQL database infrastructure to the cloud, however, not quite sure between AWS, Heroku, Azure and Google cloud. Things to consider: The main reason is for backing up and centralize all our data in the cloud. With that in mind the main elements are: -Pricing for storage. -Small team. -No need for high throughput. -Support for docker swarm and Kubernetes.

See more
Replies (2)
David Weinberg

Good balance between easy to manage, pricing, docs and features.

See more
Max Musing
Founder & CEO at BaseDash · | 1 upvotes · 45.4K views

DigitalOcean's offering is pretty solid. Easy to scale, great UI, automatic daily backups, decent pricing.

See more
Get Advice from developers at your company using StackShare Enterprise. Sign up for StackShare Enterprise.
Learn More
Pros of ClearDB
Pros of Heroku Postgres
  • 7
    Cloud SQL
  • 6
    Heroku
  • 4
    Fast
  • 3
    Great Backup
  • 3
    Easy to use
  • 2
    Scalability
  • 1
    Great Support
  • 1
    Geographic redundancy
  • 1
    Master / master replication
  • 29
    Easy to setup
  • 3
    Follower databases
  • 3
    Dataclips for sharing queries
  • 3
    Extremely reliable

Sign up to add or upvote prosMake informed product decisions

Cons of ClearDB
Cons of Heroku Postgres
    Be the first to leave a con
    • 2
      Super expensive

    Sign up to add or upvote consMake informed product decisions

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

    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.

    Need advice about which tool to choose?Ask the StackShare community!

    What companies use ClearDB?
    What companies use Heroku Postgres?
    See which teams inside your own company are using ClearDB or Heroku Postgres.
    Sign up for StackShare EnterpriseLearn More

    Sign up to get full access to all the companiesMake informed product decisions

    What tools integrate with ClearDB?
    What tools integrate with Heroku Postgres?

    Sign up to get full access to all the tool integrationsMake informed product decisions

    Blog Posts

    GitHubPythonNode.js+47
    54
    72276
    GitHubPythonSlack+25
    7
    3147
    GitHubPythonDocker+24
    13
    17001
    What are some alternatives to ClearDB and Heroku Postgres?
    MySQL
    The MySQL software delivers a very fast, multi-threaded, multi-user, and robust SQL (Structured Query Language) database server. MySQL Server is intended for mission-critical, heavy-load production systems as well as for embedding into mass-deployed software.
    Firebase
    Firebase is a cloud service designed to power real-time, collaborative applications. Simply add the Firebase library to your application to gain access to a shared data structure; any changes you make to that data are automatically synchronized with the Firebase cloud and with other clients within milliseconds.
    Amazon RDS
    Amazon RDS gives you access to the capabilities of a familiar MySQL, Oracle or Microsoft SQL Server database engine. This means that the code, applications, and tools you already use today with your existing databases can be used with Amazon RDS. Amazon RDS automatically patches the database software and backs up your database, storing the backups for a user-defined retention period and enabling point-in-time recovery. You benefit from the flexibility of being able to scale the compute resources or storage capacity associated with your Database Instance (DB Instance) via a single API call.
    Amazon Aurora
    Amazon Aurora is a MySQL-compatible, relational database engine that combines the speed and availability of high-end commercial databases with the simplicity and cost-effectiveness of open source databases. Amazon Aurora provides up to five times better performance than MySQL at a price point one tenth that of a commercial database while delivering similar performance and availability.
    Azure SQL Database
    It is the intelligent, scalable, cloud database service that provides the broadest SQL Server engine compatibility and up to a 212% return on investment. It is a database service that can quickly and efficiently scale to meet demand, is automatically highly available, and supports a variety of third party software.
    See all alternatives