Likelihood to Recommend 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.
Read full review I have had limited exposure to other development environments, but I have found Openedge to be well suited for the purposes that we are using it for. We have a windows client-server application that has been in use for over 20 years and has held it's age well. We also have a web based product using openedge appserver to access our backend code. The appserver functions well and we have been happy with it
Read full review Pros 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. Read full review 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. Read full review Cons 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. Read full review Needs to improve the documentation Licensing is costly Read full review Likelihood to Renew This language used since 1980
Read full review Alternatives Considered 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.
Read full review 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.
Read full review Return on Investment 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. Read full review Openedge is a good business partner. They provide excellent support, education, and marketing assistance. Openedge programming resources are readily available, both in the US and inexpensively overseas when additional staff is needed to complete projects. Openedge is just as powerful, but much less expensive than its rivals, like Oracle. Read full review ScreenShots