Name: H2 Database Engine
Rating: 8 (2 reviews)
Author: Open Source

Help Desk

Web and Video Conferencing

Customer Support

PHP Frameworks

Text Editors

Development

Admissions and Enrollment

Online Proctoring Software

Education

Business Intelligence (BI)

Collaboration

Contract Analysis

Corporate Performance Management (CPM)

Payment Facilitation

Visitor Management

Whistleblowing

Enterprise

Accounting

Payment Hubs

Finance and Accounting

Applicant Tracking

Corporate Learning Management

Employer of Record (EOR)

HR Management

Payroll

Talent Intelligence

Talent Management

Workforce Analytics

Workforce Management

Human Resources

Cloud Storage

Complex Event Processing

Data Pipeline

Data Virtualization

Database-as-a-Service (DBaaS)

Disk Cloning

Endpoint Security

Enterprise Service Bus

Extended Detection and Response (XDR)

Firewall

Fraud Detection

Hosted Virtual Desktop

Integration Platform as a Service (iPaaS)

Interoperability

Network Performance Monitoring

Software Defined Networking (SDN)

Storage as a Service (STaaS)

User Virtualization

Information Technology

A/B Testing

Ad Serving & Retargeting

All-in-One Marketing

Channel Management

Content Management

Email Marketing

Marketing Attribution

Marketing Automation

Social Media Management

Survey & Forms Building

Translation

Web Analytics

Marketing

Project Management

Transcription

Professional Services

Customer Onboarding

Customer Relationship Management (CRM)

Proposal

Sales Intelligence

Sales

Data-Centric Audit Protection (DCAP)

Intrusion Detection

Operational Technology (OT) Security

Security

Aviation

Construction Accounting

Construction Takeoff and Estimating

Fleet Maintenance

Fleet Management

Insurance Policy Administration Systems

Online Fax

Population Health Management

Public Transportation

Telemedicine

Text Analysis

Vertical-Specific

medium

small

large

SQLite is an in-process library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine. The code for SQLite is in the public domain and is thus free for use for any purpose, commercial or private. SQLite is one of the most widely deployed databases in the world.

SQLite

Open-Source Database

Open Source

Apache Derby is an embedded relational database management system, originally developed by IBM and called IBM Cloudscape.

Apache Derby

Embedded Database

Apache

PostgreSQL (alternately Postgres) is a free and open source object-relational database system boasting over 30 years of active development, reliability, feature robustness, and performance. It supports SQL and is designed to support various workloads flexibly.

PostgreSQL

PostgreSQL Global Development Group

Top Rated 2023

MySQL is a popular open-source relational and embedded database, now owned by Oracle.

MySQL

Oracle

Redis is an open source in-memory data structure server and NoSQL database.

Cloud

Redis™*

NoSQL Databases

Performance

Availability

Concurrency

Scalability

Data model flexibility

Deployment model flexibility

Redis Labs™*

Oracle Database, currently in edition 23c, offers native support for property graph data structures and graph queries. If you're looking for flexibility to build graphs in conjunction with transactional data, JSON, Spatial, and other data types, we got you covered. Developers can now easily build graph applications with SQL using existing SQL development tools and frameworks.

Oracle Database

Relational Databases

MariaDB is an open-source relational database made by the original developers of MySQL, supported by the MariaDB Foundation and a community of developers. The community states recent additional capabilities as including clustering with Galera Cluster 4, compatibility with Oracle Database, and Temporal Data Tables, allowing one to query the data as it stood at any point in the past.

MariaDB Platform

MariaDB

MongoDB is an open source document-oriented database system. It is part of the NoSQL family of database systems. Instead of storing data in tables as is done in a "classical" relational database, MongoDB stores structured data as JSON-like documents with dynamic schemas (MongoDB calls the format BSON), making the integration of data in certain types of applications easier and faster.

Shared

Serverless

Dedicated

MongoDB

Apache Hive is database/data warehouse software that supports data querying and analysis of large datasets stored in the Hadoop distributed file system (HDFS) and other compatible systems, and is distributed under an open source license.

Apache Hive

Data Warehouse

Neo4j is an open source embeddable graph database developed by Neo Technologies based in San Mateo, California with an office in Sweden.

Community Edition

Enterprise Edition

Aura Free

Aura Professional

Aura Enterprise

Neo4j

Non-Relational Databases

Neo Technologies

H2 Database Engine is an open source, embeddable database management system (RDMS) written in Java.

H2 Database Engine

Open-source databases are growing in popularity and present a cost-saving alternative to conventionally licensed databases.

Likelihood to Recommend

Reviews

TrustRadius is a technology and business research firm based in Austin, Texas. The company is known as a review platform for verified B2B technology and software reviews through a proprietary algorithm and human verification.

TrustRadius

Sql queries

Database engine

Mature product

Use case

Nosql databases

Light weight

Relational databases

Simple setup

Easy to use

Simple and quick

Home

Open-Source Database Software

H2 Database

H2 Database Engine is primarily used for running application test cases by our development team. When changes are made to our codebase, we run automated test cases, and when the test case involves data manipulation, H2 Database Engine is used instead of a full blown database such as PostgreSQL. H2 Database Engine is lightweight, simple and runs in-memory, which makes it perfect for this use case.

Product Usage

Pros and Cons

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.

Things done well

There really is not a lot to say here as H2 Database Engine is not a general purpose database such as PostgreSQL or MySQL, so it has a niche use case for being an in-memory database, and it is very good at doing that. Perhaps one slight improvement would be some SQL queries that work with MySQL or PostgreSQL do not work with H2 Database Engine, and so if H2 Database Engine is used as an in-memory replacement for testing, that would create false negatives.
If H2 Database Engine can support some NoSQL databases, it would be fantastic.

Things done poorly

This really depends on the use case. For an in-memory replacement database for running unit test cases with, H2 Database Engine is an excellent option. However, if you are looking for a general purpose database for your production systems, then H2 Database Engine is not suited for this purpose.

Most Important Features 3.4.21

Improved code quality by allowing the team to run automated test cases.
Reduced infrastructure cost as we no longer need to have dedicated databases just for testing.

Return on Investment

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.

Alternatives

Other Software Used

H2 Database Engine 2021-05-26 22:46:51

Apache Tomcat

Amazon Relational Database Service (RDS)

[H2 Database Engine is] being used for two different purposes. One is for running unit tests for application during compilation phase. This application runs is MySQL database normally, but for unit test purposes that is impractical. In compilation phase an in-memory H2 database is constructed and application tests are run against that. Another purpose is a small authentication security web-application that runs in a single instance. In this case some authentication related details are stored in H2 database that is stored to disk.

Simple setup, only needs a dependency added to application & few config lines.
Quick startup
Easy to use, existing code for MySQL works with H2 too

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.

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.

Easy setup, developers don't need to setup databases for running tests
Persistence, although H2 is often referred as in-memory database, saving the database to disk is easy and data stays between application restarts
MySQL compatibility

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.

Both MySQL &amp; H2 [Database Engine] are relational databases &amp; use same query language. Application features can be implemented with both but if  it's expected that the application will be used by large user base or is complex MySQL is better. Cloud providers provide scaling support for MySQL and also it's more battle-tested. H2 is good when it's a small application as H2 is easier &amp; quicker to set up.

Amazon Relational Database Service (RDS), Apache Tomcat, MySQL

H2 Database Engine 2021-05-10 04:23:20

Operating Systems	Unspecified
Mobile Application	No

H2 Database

Overview

What is H2 Database?

H2 Database Engine is the in-memory database for your automated tests

For simplicity

Product Details