H2 Database Engine is an open source, embeddable database management system (RDMS) written in Java.
N/A
Progress OpenEdge
Score 8.3 out of 10
N/A
Progress OpenEdge is an application development environment to keep businesses running, that enables users to leverage technology advancements to more quickly deliver business applications.
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.
Openedge is very well suited for financial based applications for 2 reasons. First, it has very powerful transaction scoping that will commit or back out of all changes in a transaction at once. This ensure that your data is "in sync." Second, it offers after imaging roll forward and replication for environments that require high availability or powerful disaster recovery in place.
Openedge databases are practically bulletproof, even when shot down abnormally. The offer complete transaction scoping, before imagining, and also after imaging for roll foward capability.
Openedge has a very powerful and easy to learn 4GL programming language that can be used in a traditional or object oriented manner.
Openedge also has powerful web services components, fully integrating both SOAP and RESTful web services.
Openedge is completely scaleable from 1 user to a fully distributed global enterprise solution.
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.
The decision to use openedge with our particular product was made such a long time ago that I certainly was not around to make the decision. And most of the other products that would have been compared at the time are likely no longer around. Which does speak to the longevity and benefits of this product. When you look back and see how long the same product has been going forward with constant improvements and remaining relevant without major disruptive changes, it is worthy of some credit.
