BeetlSQL Overview: New Oracle12Style, Maven Dependency, Supported Databases, and Benchmark Results

BeetlSQL, developed since 2015, aims to offer an efficient data access framework with high development, maintenance, and runtime performance, comparable to MyBatis. It now adds Oracle12Style with new Fetch syntax for pagination and notes that Oracle defaults support tables, views, and synonyms.

The BeetlSQL version has been updated to the latest release, and the Maven dependency is shown below:

<dependency>
    <groupId>com.ibeetl</groupId>
    <artifactId>beetlsql</artifactId>
    <version>3.23.4-RELEASE</version>
</dependency>

BeetlSQL supports a broad spectrum of databases, including traditional relational databases (MySQL, MariaDB, Oracle, PostgreSQL, DB2, SQL Server, H2, SQLite, Derby, Shentong, Dameng, Huawei Gauss, RuanJinCang, PolarDB, GBase8s, GreatSQL), big data stores (HBase, ClickHouse, Cassandra, Hive, Greenplum), IoT time‑series databases (Machbase, TD‑Engine, IoTDB), and SQL query engines (Drill, Presto, Druid). It also works with in‑memory databases such as Ignite and CouchBase.

The framework provides extensive ORM capabilities, including complex multi‑table mappings, direct JDBC execution, template execution, file‑based SQL, insert operations, query chaining, pagination, primary‑key lookups, and automatic one‑to‑many associations.

Benchmark results (operations per millisecond) compare BeetlSQL with Hibernate, MyBatis, JPA, and Weed, covering various operations such as complex mapping, JDBC execution, template execution, file execution, inserts, lambda queries, one‑to‑many, pagination, and select‑by‑id. For example, BeetlSQL's beetlsqlExecuteJdbc achieves 496.413 ops/ms, while Hibernate's jdbcExecuteJdbc reaches 1041.376 ops/ms, and MyBatis's mybatisExecuteTemplate records 212.699 ops/ms.

Readers are encouraged to like and share the article if they found it helpful.