What users are saying about
2 Ratings
This review does not include a rating.
2 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener'>trScore algorithm: Learn more.</a>
Score 8 out of 100
This review does not include a rating.

Likelihood to Recommend

H2 Database

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.
Anonymous | TrustRadius Reviewer

HSQLDB (Hyper SQL Database)

No answers on this topic

Pros

H2 Database

  • 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.
Anonymous | TrustRadius Reviewer

HSQLDB (Hyper SQL Database)

No answers on this topic

Cons

H2 Database

  • 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.
Anonymous | TrustRadius Reviewer

HSQLDB (Hyper SQL Database)

No answers on this topic

Alternatives Considered

H2 Database

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.
Anonymous | TrustRadius Reviewer

HSQLDB (Hyper SQL Database)

No answers on this topic

Return on Investment

H2 Database

  • 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.
Anonymous | TrustRadius Reviewer

HSQLDB (Hyper SQL Database)

No answers on this topic

Pricing Details

H2 Database

General

Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No

HSQLDB (Hyper SQL Database)

General

Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No

Add comparison