Need advice about which tool to choose?Ask the StackShare community!
CouchDB vs Heroku Postgres: What are the differences?
Developers describe CouchDB as "HTTP + JSON document database with Map Reduce views and peer-based replication". Apache CouchDB is a database that uses JSON for documents, JavaScript for MapReduce indexes, and regular HTTP for its API. CouchDB is a database that completely embraces the web. Store your data with JSON documents. Access your documents and query your indexes with your web browser, via HTTP. Index, combine, and transform your documents with JavaScript. 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.
CouchDB and Heroku Postgres are primarily classified as "Databases" and "PostgreSQL as a Service" tools respectively.
"JSON" is the top reason why over 42 developers like CouchDB, while over 27 developers mention "Easy to setup" as the leading cause for choosing Heroku Postgres.
CouchDB is an open source tool with 4.24K GitHub stars and 835 GitHub forks. Here's a link to CouchDB's open source repository on GitHub.
Luckycycle, FarmLogs, and Watsi are some of the popular companies that use Heroku Postgres, whereas CouchDB is used by BrightMachine, Bit Zesty, and Meltwater. Heroku Postgres has a broader approval, being mentioned in 74 company stacks & 39 developers stacks; compared to CouchDB, which is listed in 61 company stacks and 32 developer stacks.
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.
Good balance between easy to manage, pricing, docs and features.
DigitalOcean's offering is pretty solid. Easy to scale, great UI, automatic daily backups, decent pricing.
We implemented our first large scale EPR application from naologic.com using CouchDB .
Very fast, replication works great, doesn't consume much RAM, queries are blazing fast but we found a problem: the queries were very hard to write, it took a long time to figure out the API, we had to go and write our own @nodejs library to make it work properly.
It lost most of its support. Since then, we migrated to Couchbase and the learning curve was steep but all worth it. Memcached indexing out of the box, full text search works great.
Pros of CouchDB
- JSON43
- Open source30
- Highly available18
- Partition tolerant12
- Eventual consistency11
- Sync7
- REST API5
- Attachments mechanism to docs4
- Multi master replication4
- Changes feed3
- REST interface1
- js- and erlang-views1
Pros of Heroku Postgres
- Easy to setup29
- Follower databases3
- Dataclips for sharing queries3
- Extremely reliable3
Sign up to add or upvote prosMake informed product decisions
Cons of CouchDB
Cons of Heroku Postgres
- Super expensive2