CrateDB vs. H2 Database Engine

CrateDB

H2 Database Engine

2 Reviews and Ratings

Overview
Product	Rating	Most Used By	Product Summary	Starting Price
CrateDB	N/A	N/A	CrateDB is an open-source, distributed SQL database for relational and time-series data, from Crate.io headquartered in San Francisco. A solution for machine data, the vendor states CrateDB is purpose-built for the need to scale volume, variety and velocity of data while running aggregated complex real-time queries, anywhere and without driving up costs.	$53 per month
H2 Database	Score8 out of 10	N/A	H2 Database Engine is an open source, embeddable database management system (RDMS) written in Java.	N/A

Pricing

CrateDB

H2 Database

Shared S2: $53
per month
Shared S4: $103
per month
Shared S6: $153
per month
Dedicated CR1: $187.25
per month
Shared S12: $303
per month
Dedicated CR2: $362.45
per month
Dedicated CR3: $712.85
per month
Dedicated CR4: $ 1,413.65
per month
Open Source: Free for Self-Hosting
Custom: Custom
Custom

No answers on this topic

Pricing Offerings
CrateDB	H2 Database
Free Trial
No	No
Free/Freemium Version
Yes	No
Premium Consulting/Integration Services
No	No

No setup fee

No setup fee

—

—

Best Alternatives
	CrateDB	H2 Database
Small Businesses	MariaDB Platform Score9.1 out of 10	MariaDB Platform Score9.1 out of 10
Medium-sized Companies	PostgreSQL Score8.8 out of 10	PostgreSQL Score8.8 out of 10
Enterprises	SQLite Score8 out of 10	SQLite Score8 out of 10
All Alternatives	View all alternatives	View all alternatives

User Ratings
	CrateDB	H2 Database
Likelihood to Recommend	- (0 ratings)	8.0 (2 ratings)

User Testimonials
	CrateDB	H2 Database
Likelihood to Recommend	Crate.io Inc No answers on this topic	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 Verified User Read full review
Pros	Crate.io Inc No answers on this topic	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 Verified User Read full review
Cons	Crate.io Inc No answers on this topic	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 Verified User Read full review
Alternatives Considered	Crate.io Inc No answers on this topic	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 Verified User Read full review
Return on Investment	Crate.io Inc No answers on this topic	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 Verified User Read full review
ScreenShots