Apache CouchDB vs. H2 Database Engine

Overview
ProductRatingMost Used ByProduct SummaryStarting Price
CouchDB
Score 6.2 out of 10
N/A
Apache CouchDB is an HTTP + JSON document database with Map Reduce views and bi-directional replication. The Couch Replication Protocol is implemented in a variety of projects and products that span computing environments from globally distributed server-clusters, over mobile phones to web browsers.N/A
H2 Database
Score 8.0 out of 10
N/A
H2 Database Engine is an open source, embeddable database management system (RDMS) written in Java.N/A
Pricing
Apache CouchDBH2 Database Engine
Editions & Modules
No answers on this topic
No answers on this topic
Offerings
Pricing Offerings
CouchDBH2 Database
Free Trial
NoNo
Free/Freemium Version
NoNo
Premium Consulting/Integration Services
NoNo
Entry-level Setup FeeNo setup feeNo setup fee
Additional Details
More Pricing Information
Community Pulse
Apache CouchDBH2 Database Engine
Top Pros
Top Cons
Features
Apache CouchDBH2 Database Engine
NoSQL Databases
Comparison of NoSQL Databases features of Product A and Product B
Apache CouchDB
7.9
2 Ratings
11% below category average
H2 Database Engine
-
Ratings
Performance8.02 Ratings00 Ratings
Availability8.52 Ratings00 Ratings
Concurrency8.52 Ratings00 Ratings
Security6.02 Ratings00 Ratings
Scalability8.02 Ratings00 Ratings
Data model flexibility7.02 Ratings00 Ratings
Deployment model flexibility9.02 Ratings00 Ratings
Best Alternatives
Apache CouchDBH2 Database Engine
Small Businesses
IBM Cloudant
IBM Cloudant
Score 8.1 out of 10
InfluxDB
InfluxDB
Score 8.5 out of 10
Medium-sized Companies
IBM Cloudant
IBM Cloudant
Score 8.1 out of 10
SQLite
SQLite
Score 9.1 out of 10
Enterprises
IBM Cloudant
IBM Cloudant
Score 8.1 out of 10
SQLite
SQLite
Score 9.1 out of 10
All AlternativesView all alternativesView all alternatives
User Ratings
Apache CouchDBH2 Database Engine
Likelihood to Recommend
9.0
(10 ratings)
8.0
(2 ratings)
Likelihood to Renew
9.0
(9 ratings)
-
(0 ratings)
Usability
8.0
(1 ratings)
-
(0 ratings)
Implementation Rating
9.0
(1 ratings)
-
(0 ratings)
User Testimonials
Apache CouchDBH2 Database Engine
Likelihood to Recommend
Apache
Great for REST API development, if you want a small, fast server that will send and receive JSON structures, CouchDB is hard to beat. Not great for enterprise-level relational database querying (no kidding). While by definition, document-oriented databases are not relational, porting or migrating from relational, and using CouchDB as a backend is probably not a wise move as it's reliable, but It may not always be highly available.
Read full review
Open Source
For running application tests it's well suited. H2 [Database Engine] can replace the real-world database solution for them easily and removes the requirement to set up a a separate database instance just for running unit tests. For using in actual production application one needs to consider scale. H2 is suitable if application runs in single instance and database is located in same machine as a file where that application runs. This means the application shouldn't have a large user base. However it's easy to switch to an actual MySQL instance if the need arises, it's most likely only a configuration change and doesn't require new code.
Read full review
Pros
Apache
  • It can replicate and sync with web browsers via PouchDB. This lets you keep a synced copy of your database on the client-side, which offers much faster data access than continuous HTTP requests would allow, and enables offline usage.
  • Simple Map/Reduce support. The M/R system lets you process terabytes of documents in parallel, save the results, and only need to reprocess documents that have changed on subsequent updates. While not as powerful as Hadoop, it is an easy to use query system that's hard to screw up.
  • Sharding and Clustering support. As of CouchDB 2.0, it supports clustering and sharding of documents between instances without needing a load balancer to determine where requests should go.
  • Master to Master replication lets you clone, continuously backup, and listen for changes through the replication protocol, even over unreliable WAN links.
Read full review
Open Source
  • Can run as an in-memory database.
  • Simple and quick to get started with, and is light weight (only 2MB).
  • SQL compliant so it compatible with most relational databases.
Read full review
Cons
Apache
  • NoSQL DB can become a challenge for seasoned RDBMS users.
  • The map-reduce paradigm can be very demanding for first-time users.
  • JSON format documents with Key-Value pairs are somewhat verbose and consume more storage.
Read full review
Open Source
  • There's a warning in official FAQ "Is it Reliable?"-section which makes it seem like H2 is not yet a mature product.
  • If raw SQL queries are used there maybe be differences between MySQL & H2. ORM library should be used.
  • Support seems to be community-based only.
Read full review
Likelihood to Renew
Apache
Because our current solution S3 is working great and CouchDB was a nightmare. The worst is that at first, it seemed fine until we filled it with tons of data and then started to create views and actually delete.
Read full review
Open Source
No answers on this topic
Usability
Apache
Couchdb is very simple to use and the features are also reduced but well implemented. In order to use it the way its designed, the ui is adequate and easy. Of course, there are some other task that can't be performed through the admin ui but the minimalistic design allows you to use external libraries to develop custom scripts
Read full review
Open Source
No answers on this topic
Implementation Rating
Apache
it support is minimal also hw requirements. Also for development, we can have databases replicated everywhere and the replication is automagical. once you set up the security and the rules for replication, you are ready to go. The absence of a model let you build your app the way you want it
Read full review
Open Source
No answers on this topic
Alternatives Considered
Apache
It has been 5+ years since we chose CouchDB. We looked an MongoDB, Cassandra, and probably some others. At the end of the day, the performance, power potential, and simplicity of CouchDB made it a simple choice for our needs. No one should use just because we did. As I said early, make sure you understand your problems, and find the right solution. Some random reading that might be useful: http://www.julianbrowne.com/article/viewer/brewers-cap-theorem https://www.couchbase.com/nosql-resources/why-nosql\ https://www.infoq.com/articles/cap-twelve-years-later-how-the-rules-have-changed
Read full review
Open Source
While both can run as an in-memory database, H2 Database Engine was just so much easier for us to use since we primarily use the Java stack and H2 Database Engine is also built with Java.
Read full review
Return on Investment
Apache
  • It has saved us hours and hours of coding.
  • It is has taught us a new way to look at things.
  • It has taught us patience as the first few weeks with CouchDB were not pleasant. It was not easy to pick up like MongoDB.
Read full review
Open Source
  • Doesn't take time from developers, once it's configs are set up for testing it works in everyone's development environments
  • Easy to integrate in application, no need to setup separate database software, no maintenance
  • No need to deal with infrastructure related issues/costs - database runs in same machine as the application that uses it.
Read full review
ScreenShots