H2 Database Engine vs. Progress OpenEdge

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.

Incentivized

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.

Incentivized

• 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

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

Incentivized

• 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

• Lack of multi-threading capability has been a complaint among other developers here.

Incentivized

This language used since 1980

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.

Incentivized

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.

Incentivized

• 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

• The speed of development and ease of learning has had a positive impact on ROI
• The cost of use has had a negative one. In this era of free tools everywhere, paying for a product is a challenge to accept.

Incentivized