What users are saying about
2 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow noopener'>Customer Verified: Read more.</a>
Top Rated
256 Ratings
2 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener'>trScore algorithm: Learn more.</a>
Score 8 out of 100

PostgreSQL

<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow noopener'>Customer Verified: Read more.</a>
Top Rated
256 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener'>trScore algorithm: Learn more.</a>
Score 8.8 out of 100

Likelihood to Recommend

H2 Database

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.
Anonymous | TrustRadius Reviewer

PostgreSQL

PostgreSQL is ideal for handling databases that contain large volumes of information due to its efficiency, speed and above all because of the good management it makes of our resources, it also behaves very well in distributed environments of high demand, if you want a database of stable data and excellent performance PostgreSQL is one of the best.
Moris Mendez | TrustRadius Reviewer

Pros

H2 Database

  • 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.
Anonymous | TrustRadius Reviewer

PostgreSQL

  • Reliability - There is absolutely no issue with uptime or data integrity.
  • Flexibility - The wide range of data types which are supported gives us immense flexibility in terms of what data we can store.
  • Speed - Even at our busiest, we are able to count on the performance of the engine matching our needs.
  • Internal features - Thanks to the wealth of internal features, we have less external dependencies to perform common business tasks.
Don Burks | TrustRadius Reviewer

Cons

H2 Database

  • 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.
Anonymous | TrustRadius Reviewer

PostgreSQL

  • The performance of PostgreSQL has been enhanced through the years, but always is better to have as much performance as we can.
  • The replication services could be done directly within the database, and more easily.
  • The Object Orientation of the Database could be extended, and albeit it manages inheritance of tables, and accepts XML and JSON as primary types, it would be wonderful if one could attach methods more easily to tables (to make them more like classes), and instances (rows for example).
Javier Blanque | TrustRadius Reviewer

Likelihood to Renew

H2 Database

No score
No answers yet
No answers on this topic

PostgreSQL

PostgreSQL 9.0
Based on 1 answer
As a needed software for day to day development activities
Ojoswi Basu | TrustRadius Reviewer

Usability

H2 Database

No score
No answers yet
No answers on this topic

PostgreSQL

PostgreSQL 9.0
Based on 6 answers
Postgresql is the best tool out there for relational data so I have to give it a high rating when it comes to analytics, data availability and consistency, so on and so forth. SQL is also a relatively consistent language so when it comes to building new tables and loading data in from the OLTP database, there are enough tools where we can perform ETL on a scalable basis.
Anonymous | TrustRadius Reviewer

Reliability and Availability

H2 Database

No score
No answers yet
No answers on this topic

PostgreSQL

PostgreSQL 9.0
Based on 2 answers
PostgreSQL's availability is top notch. Apart from connection time-out for an idle user, the database is super reliable.
Ojoswi Basu | TrustRadius Reviewer

Performance

H2 Database

No score
No answers yet
No answers on this topic

PostgreSQL

PostgreSQL 7.0
Based on 2 answers
The data queries are relatively quick for a small to medium sized table. With complex joins, and a wide and deep table however, the performance of the query has room for improvement.
Ojoswi Basu | TrustRadius Reviewer

Support Rating

H2 Database

No score
No answers yet
No answers on this topic

PostgreSQL

PostgreSQL 9.4
Based on 13 answers
AWS, Heroku, and Digital Ocean all provide Postgres-as-a-service, where you pretty much never need to administrate it yourself but they do it for you. The Postgres community also has developed awesome and reasonably priced extensions, such as Citus DB and CockroachDB in case you need additional support for running it. If you need documentation, Postgres's docs are super thorough and their official forms are active.
Anonymous | TrustRadius Reviewer

Online Training

H2 Database

No answers on this topic

PostgreSQL

The online training is request based. Had there been recorded videos available online for potential users to benefit from, I could have rated it higher. The online documentation however is very helpful. The online documentation PDF is downloadable and allows users to pace their own learning. With examples and code snippets, the documentation is great starting point.
Ojoswi Basu | TrustRadius Reviewer

Implementation Rating

H2 Database

No score
No answers yet
No answers on this topic

PostgreSQL

PostgreSQL 9.0
Based on 3 answers
The online documentation of the PostgreSQL product is elaborate and takes users step by step.
Ojoswi Basu | TrustRadius Reviewer

Alternatives Considered

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.
Anonymous | TrustRadius Reviewer

PostgreSQL

Postgres stacks up just [fine] along the other big players in the RDBMS world. It's very popular for a reason. It's very close to MySQL in terms of cost and features - I'd pick either solution and be just as happy. Compared to Oracle it is a MUCH cheaper solution that is just as usable.
Anonymous | TrustRadius Reviewer

Scalability

H2 Database

No score
No answers yet
No answers on this topic

PostgreSQL

PostgreSQL 8.0
Based on 1 answer
The DB is reliable, scalable, easy to use and resolves most DB needs
Ojoswi Basu | TrustRadius Reviewer

Return on Investment

H2 Database

  • 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.
Anonymous | TrustRadius Reviewer

PostgreSQL

  • By pushing a lot of logic into database views and triggers, PostgreSQL provides the ability to write much slimmer and more maintainable controller code, reducing development costs.
  • PostgreSQL's upsert capabilities enabled us to go to scale much more easily and quickly, allowing us to increase our number of customers.
David McCann | TrustRadius Reviewer

Pricing Details

H2 Database

General

Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No

PostgreSQL

General

Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No

Add comparison