Apache Geode vs. H2 Database Engine

Overview
ProductRatingMost Used ByProduct SummaryStarting Price
Apache Geode
Score 7.0 out of 10
N/A
Apache Geode is a distributed in-memory database designed to support low latency, high concurrency solutions, available free and open source since 2002. With it, users can build high-speed, data-intensive applications that elastically meet performance requirements. Apache Geode blends techniques for data replication, partitioning and distributed processing.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 GeodeH2 Database Engine
Editions & Modules
No answers on this topic
No answers on this topic
Offerings
Pricing Offerings
Apache GeodeH2 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 GeodeH2 Database Engine
Top Pros

No answers on this topic

Top Cons

No answers on this topic

Features
Apache GeodeH2 Database Engine
NoSQL Databases
Comparison of NoSQL Databases features of Product A and Product B
Apache Geode
8.7
1 Ratings
1% below category average
H2 Database Engine
-
Ratings
Performance9.01 Ratings00 Ratings
Availability10.01 Ratings00 Ratings
Concurrency10.01 Ratings00 Ratings
Scalability8.01 Ratings00 Ratings
Data model flexibility7.01 Ratings00 Ratings
Deployment model flexibility8.01 Ratings00 Ratings
Best Alternatives
Apache GeodeH2 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 GeodeH2 Database Engine
Likelihood to Recommend
7.0
(1 ratings)
8.0
(2 ratings)
Usability
8.0
(1 ratings)
-
(0 ratings)
Support Rating
1.0
(1 ratings)
-
(0 ratings)
User Testimonials
Apache GeodeH2 Database Engine
Likelihood to Recommend
Apache
The biggest advantage of using Apache Geode is DB like consistency. So for applications whose data needs to be in-memory, accessible at low latencies and most importantly writes have to be consistent, should use Apache Geode. For our application quite some amount of data is static which we store in MySQL as it can be easily manipulated. But since this data is large R/w from DB becomes expensive. So we started using Redis. Redis does a brilliant job, but with complex data structures and no query like capability, we have to manage it via code. We are experimenting with Apache Geode and it looks promising as now we can query on complex data-structures and get the required data quickly and also updates consistent.
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
  • Super Fast data pull/push
  • Provided ACID transactions, so it works like a SQL Database
  • Provides replication & partitioning, so our data is never lost and extraction is super fast. NoSql like properties
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
  • Needs more supporting languages. Out of box Python, Nodejs adapters would be wonderful
  • Currently it supports just KV Store. But if we could cache documents or timeseries data would be great
  • Needs more community support, documentation.
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
Usability
Apache
Still Experimenting. Initial results are good. we need to figure out if we can completely replace Redis. Cost wise if it makes sense to keep both or replacement is feasible.
Read full review
Open Source
No answers on this topic
Support Rating
Apache
Never contacted support
Read full review
Open Source
No answers on this topic
Alternatives Considered
Apache
Still Experimenting. But looks promising as it has query capabilities over complex data structures
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
  • Still experimenting so difficult to quote
  • For a small size project/teams might be an overkill as it still has certain learning curve
  • For Medium to large projects with complex Data Structures that need to be queried with a fast o/p it definitely works
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