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

Call Center Workforce Optimization

Help Desk

Web and Video Conferencing

Customer Support

Functional Testing

Kubernetes Monitoring

Development

Business Intelligence (BI)

Collaboration

Enterprise Content Management

Integrated Workplace Management (IWMS)

PDF Editors

Privacy Policy Generators

Enterprise

Accounting

Accounts Payable

Finance and Accounting

Applicant Tracking

Corporate Learning Management

HR Management

Payroll

Stock Option Plan Administration

Talent Intelligence

Talent Management

Vendor Management Systems (VMS)

Workforce Analytics

Workforce Management

Human Resources

3D Printing

Cloud Storage

Complex Event Processing

Composable Infrastructure

Data Collaboration

Deception Technology

Fraud Detection

Integration Platform as a Service (iPaaS)

Internet Performance Monitoring

LAN Switches

Network Performance Monitoring

Remote Desktop

Robotic Process Automation (RPA)

SaaS Backup

Service Desk Outsourcing

Software Asset Management

Storage Management

Telecom Expense Management (TEM)

User Virtualization

Vector Databases

Web Scraping

Zero Trust Security Solutions

Information Technology

A/B Testing

Ad Serving & Retargeting

All-in-One Marketing

Content Management

Customer Advocacy

Digital Content Creation

Email Deliverability

Email Marketing

Employee Advocacy

Headless CMS

Marketing Automation

Referral Marketing

Social Media Management

Survey & Forms Building

Web Analytics

Marketing

Project Management

Professional Services

Customer Relationship Management (CRM)

Field Sales Software

Government Contracting

Social Commerce

Sales

Secure Access Service Edge (SASE)

Security

Awards Management

Card Management

Dealer Management

Healthcare Learning Management

Investment Portfolio Management

Medical Scheduling

Retail Analytics

Text Analysis

Vertical-Specific

Find top rated software and services based on in-depth reviews from verified users. 400+ software categories including PaaS, NoSQL, BI, HR, and more.

Apache Derby

Apache

SQLite

Open Source

PostgreSQL

PostgreSQL Global Development Group

Oracle Database

Oracle

Redis Software

Redis

MongoDB

MySQL

Apache Hive

MariaDB Platform

MariaDB

Elasticsearch

Elastic

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.

Open-Source Database

Likelihood to Recommend

Apache Tomcat

Amazon Relational Database Service (RDS)

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

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

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] 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.

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.

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

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.

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.

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.

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.

H2 Database

Overview

What is H2 Database?