TrustRadius

Apache Parquet vs. H2 Database Engine

Overview
ProductRatingMost Used ByProduct SummaryStarting Price
Apache Parquet
Score 0.0 out of 10
N/A
Apache Parquet is an open source and free, column-oriented data file format designed for efficient data storage and retrieval. It provides data compression and encoding schemes with enhanced performance to handle complex data in bulk. Parquet is available in multiple languages including Java, C++, Python, etc.N/A
H2 Database
Score 8.0 out of 10
N/A
H2 Database Engine is an open source, embeddable database management system (RDMS) written in Java.N/A
Pricing
Apache ParquetH2 Database Engine
Editions & Modules
No answers on this topic
No answers on this topic
Offerings
Pricing Offerings
Apache ParquetH2 Database
Free Trial
NoNo
Free/Freemium Version
YesNo
Premium Consulting/Integration Services
NoNo
Entry-level Setup FeeNo setup feeNo setup fee
Additional Details——
More Pricing Information
Community Pulse
Apache ParquetH2 Database Engine
Considered Both Products
Apache Parquet

No answer on this topic

H2 Database
Verified User
Anonymous
Chose 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.
Verified User
Anonymous
Chose H2 Database
Both MySQL & H2 [Database Engine] are relational databases & 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 …
Best Alternatives
Apache ParquetH2 Database Engine
Small Businesses
IBM Cloudant
IBM Cloudant
Score 7.4 out of 10
InfluxDB
InfluxDB
Score 8.8 out of 10
Medium-sized Companies
IBM Cloudant
IBM Cloudant
Score 7.4 out of 10
SQLite
SQLite
Score 9.6 out of 10
Enterprises
IBM Cloudant
IBM Cloudant
Score 7.4 out of 10
SQLite
SQLite
Score 9.6 out of 10
All AlternativesView all alternativesView all alternatives
User Ratings
Apache ParquetH2 Database Engine
Likelihood to Recommend
-
(0 ratings)
8.0
(0 ratings)
User Testimonials
Apache ParquetH2 Database Engine
Likelihood to Recommend
No answers on this topic
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.
Verified User
Anonymous
Read full review
Pros
No answers on this topic
  • 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.
Verified User
Anonymous
Read full review
Cons
No answers on this topic
  • 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.
Verified User
Anonymous
Read full review
Alternatives Considered
No answers on this topic
Both MySQL & H2 [Database Engine] are relational databases & 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 & quicker to set up.
Verified User
Anonymous
Read full review
Return on Investment
No answers on this topic
  • 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.
Verified User
Anonymous
Read full review
ScreenShots