BeetSql v3.2.1 最新版

BeetlSQL is a multifunctional Java DAO tool that surpasses MyBatis, integrating the strengths of Hibernate and Mybatis. It is ideal for developers who value SQL-centric operations and require automated generation of common SQL applications. The overarching goal of BeetlSQL is to provide a high-efficiency, easy-to-maintain, and high-performance database access architecture, ensuring a consistent coding approach across multiple databases within a system. It supports traditional databases such as MySQL, MariaDB, Oracle, PostgreSQL, DB2, SQL Server, H2, SQLite, Derby, and other internet big data platforms like HBase, ClickHouse, Cassandra, Hive, as well as IoT time series databases like Machbase, TD-Engine, and IotDB. It also supports SQL query modules like Drill, Presto, and Druid, and in-memory databases like Ignite and CouchBase.

BeetlSQL is not just a simple alternative to MyBatis or Hibernate, or a combination of both. It aims to compete and even surpass Spring Data, providing a unified data access architecture that works with traditional databases, internet big data, query modules, time series databases, and in-memory databases.

Suitable Customers

Database CRUD Tiredness: If you're tired of spending energy on simple database CRUD operations, BeetlSQL's built-in database CRUD functions can help.

SQL-Centric Developers: If you belong to the SQL-centric developer group, BeetlSQL offers excellent SQL management and embedded SQL features.

Architects Seeking Maintainability: If you have high standards for code maintainability, BeetlSQL is designed to maximize the maintainability of database access code.

Cross-Database Platform Products: For platform-level products that require cross-database support and compatibility with various customer databases, BeetlSQL supports multiple libraries, allowing developers to write once and run on various database systems.

Multi-Database Requirements: If your system needs to connect to multiple databases, such as product databases, order databases, or device metadata in MySQL, and device data in ClickHouse, BeetlSQL makes it easy to support various databases with a unified approach.

Evolution from Single to Multi-Database/Tables: If your system initially uses a single database and table and later requires multiple databases and tables, BeetlSQL can easily facilitate this transition without requiring too much attention from developers.

Software Features

Dynamic SQL Generation: BeetlSQL supports dynamic SQL generation, allowing developers to write SQL statements with flexibility and ease.

Support for Various SQL Dialects: It supports various SQL dialects, ensuring compatibility with different database systems.

ORM Support: BeetlSQL provides ORM support, making it easier for developers to map objects to database tables.

Easy Integration: It can be easily integrated into existing projects and frameworks.

How to Use

Setup: Include BeetlSQL in your project's dependencies.

Configuration: Configure BeetlSQL to connect to your database(s).

CRUD Operations: Use BeetlSQL's APIs to perform CRUD operations with ease.

Dynamic Queries: Utilize BeetlSQL's dynamic query capabilities for complex SQL operations.

ORM Mapping: Map your objects to database tables using BeetlSQL's ORM features.

By using BeetlSQL, developers can achieve higher productivity, maintainability, and performance in their database access operations.