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

ClearDB

24
73
+ 1
28
Heroku Postgres

333
294
+ 1
38
Add tool

ClearDB vs Heroku Postgres: What are the differences?

What is ClearDB? Fault tolerant database-as-a-service in the cloud for your MySQL powered applications. 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'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.

ClearDB belongs to "SQL Database as a Service" category of the tech stack, while Heroku Postgres can be primarily classified under "PostgreSQL as a Service".

Some of the features offered by ClearDB are:

  • Global Multi-Master Design- ClearDB uses geo-distributed MySQL database configurations for the ultimate in database availability, survivability, and performance. Even if whole cloud regions go offline, your database will stay online.
  • Completely Fault Tolerant- ClearDB is the only cloud database in the market today that offers true multi-regional read/write mirroring with 100% uptime, even if networks or disks fail.
  • Native MySQL- Our clusters use native MySQL so that you don't have to worry about re-tuning your applications to work with ClearDB.

On the other hand, Heroku Postgres provides the following key features:

  • High Availability
  • Rollback
  • Dataclips

"Cloud SQL" is the primary reason why developers consider ClearDB over the competitors, whereas "Easy to setup" was stated as the key factor in picking Heroku Postgres.

According to the StackShare community, Heroku Postgres has a broader approval, being mentioned in 74 company stacks & 39 developers stacks; compared to ClearDB, which is listed in 5 company stacks and 3 developer stacks.

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)
Max Musing
Founder & CEO at BaseDash · | 1 upvotes · 29.9K views

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

See more
David Weinberg

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

See more
Get Advice from developers at your company using Private StackShare. Sign up for Private StackShare.
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
    Master / master replication
  • 1
    Great Support
  • 1
    Geographic redundancy
  • 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 Private StackShareLearn 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
    52
    70289
    GitHubPythonSlack+25
    7
    2949
    GitHubPythonDocker+24
    13
    16807
    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.
    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.
    See all alternatives