TrustRadius: an HG Insights company

H2 Database Engine vs. InterSystems Caché (legacy product)

Save this comparison

Save this comparison

Add Product

Recommended Comparisons

    Overview
    ProductRatingMost Used ByProduct SummaryStarting Price

    H2 Database

    Score8 out of 10
    N/AH2 Database Engine is an open source, embeddable database management system (RDMS) written in Java.N/A

    InterSystems Caché (legacy product)

    Score10 out of 10
    N/AInterSystems Caché® was a multi-modal operational database for transaction processing applications, that provided several APIs to operate with same data simultaneously: key-value, relational, object, document, and multidimensional.N/A
    Pricing
    H2 DatabaseInterSystems Caché (legacy product)
    Editions & Modules
    No answers on this topic
    No answers on this topic
    Offerings
    Pricing Offerings
    H2 DatabaseInterSystems Caché (legacy product)
    Free Trial
    NoYes
    Free/Freemium Version
    NoYes
    Premium Consulting/Integration Services
    NoNo
    Entry-level Setup FeeNo setup feeNo setup fee
    Additional Details——
    More Pricing Information
    Best Alternatives
    H2 DatabaseInterSystems Caché (legacy product)
    Small Businesses
    MariaDB Platform
    Score9.1 out of 10
    No answers on this topic
    Medium-sized Companies
    PostgreSQL
    Score8.8 out of 10
    No answers on this topic
    Enterprises
    SQLite
    Score8 out of 10
    No answers on this topic
    All AlternativesView all alternativesView all alternatives
    User Ratings
    H2 DatabaseInterSystems Caché (legacy product)
    Likelihood to Recommend
    8.0
    (2 ratings)
    4.0
    (4 ratings)
    User Testimonials
    H2 DatabaseInterSystems Caché (legacy product)
    Likelihood to Recommend
    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.
    Incentivized
    Read full review
    Discontinued Products
    It's definitely great for medical industries that need the vast amounts of features/security/performance, however if you need something simple then this would be too much. There is a learning curve, and if you come from more common database technologies, then there will be a lot of differences to handle. Simple database needs would be better fulfilled elsewhere, but Cache is for when you need to take the next step, whether that be in the volume, complexity, or security of ETL.
    Incentivized
    Read full review
    Pros
    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.
    Incentivized
    Read full review
    Discontinued Products
    • Performance
    • Robustness
    • Reliable
    Incentivized
    Read full review
    Cons
    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.
    Incentivized
    Read full review
    Discontinued Products
    • The IDE IntelliSense needs to be improved.
    Incentivized
    Read full review
    Alternatives Considered
    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.
    Incentivized
    Read full review
    Discontinued Products
    I've only worked with products that do one thing before, but there's so much that Cache offers versus piecing different services together manually. Not only does the product offer a more robust tool-set, but the support is wonderful and I've never encountered a better vendor in any industry in terms of how well they interact with their customers and care about helping you solve your problems. They want you to grow and to get better.
    Incentivized
    Read full review
    Return on Investment
    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.
    Incentivized
    Read full review
    Discontinued Products
    • Implementation time could be speeded up
    • It is very flexible and attractive
    Incentivized
    Read full review
    ScreenShots

    InterSystems Caché (legacy product) Screenshots

    Screenshot of The structure of InterSystems Caché Database Engine