H2 vs. MySQL vs. MySQL Data Access Components vs. Oracle TimesTen Comparison Chart

Welcome to H2, the Java SQL database. In embedded mode, an application opens a database from within the same JVM using JDBC. This is the fastest and easiest connection mode. The disadvantage is that a database may only be open in one virtual machine (and class loader) at any time. As in all modes, both persistent and in-memory databases are supported. There is no limit on the number of database open concurrently, or on the number of open connections. The mixed mode is a combination of the embedded and the server mode. The first application that connects to a database does that in embedded mode, but also starts a server so that other applications (running in different processes or virtual machines) can concurrently access the same data. The local connections are as fast as if the database is used in just the embedded mode, while the remote connections are a bit slower.

Enjoy the highest performance and unlimited possibilities when working with MySQL. MySQL Data Access Components (MyDAC) is a library of components that provides direct access to MySQL and MariaDB from Delphi and C++Builder, including Community Edition, as well as Lazarus (and Free Pascal) on Windows, Linux, macOS, iOS, and Android for both 32-bit and 64-bit platforms. Applications based on MyDAC can connect directly to MySQL server or work through the MySQL client library. MySQL Data Access Components are designed to help programmers develop MySQL database applications faster and easier. MyDAC is a complete replacement for standard MySQL connectors and presents an efficient alternative to the Borland Database Engine (BDE) and standard dbExpress driver for access to MySQL.