New ORM framework -- Introduction to beetlsql

It is necessary to read this article 1.8 minute .

Recently joined this company ORM The framework is not used MyBatis、Hibernate、 Neither JPA, It's called BeetlSQL Framework . This article is not an explanation of this framework （ I don't think it's necessary , I'll say later ）, But a brief introduction to it and the feeling of using it this week , Let you have a preliminary understanding of this framework .

Search online MyBatis、Hibernate、BeetlSQL Comparison of , The following picture appears ：

At first glance, I was very excited about this picture , And sent it to my friends to see （ I think the love of advanced technology is the instinct of every programmer ）, Unfortunately, after several searches, it was finally found that this picture came from BeetlSQL Author's hand …

Basically, there is very little information about this framework on the Internet , This means that if something goes wrong, it's hard for you to find the answer , Basically, we can only rely on our own experience and documents to solve , This is still a little unfriendly to junior programmers , That's why I won't explain this framework more .

The reason why I still want to write an article to roughly introduce it is as follows ：

• The reason why the company chose it , There must be his reason , Just for the time being, I don't know
• After a week's use and knowledge gained from documents , I found it was really good
• After a simple and easy introduction, let everyone know a new thing , It's also very good （ It's not like I used to have only those kinds of ORM）
• This is a framework developed by Chinese people

BeetlSQL The use of is somewhat similar MyBatisPlus（ The most basic addition, deletion, modification and query have been realized at the bottom , We don't need to write it ourselves ）.

Compare with Mybatis complex sql Is written in the book xml Inside , This BeetlSQL Is written in the book MD（markdown grammar ） Inside , Maybe I haven't fully adapted to , At present, I think it is still written in xml Inside good .

Not officially used Hibernate I don't know how the paging in it is used ,Mybatis Pagination of requires the introduction of a plug-in PageHelper（ It's not the only one ）, And this BeetlSQL It has its own paging function , It works like Mybatis+PageHelper It's just as simple .

Use these ORM frame , One aspect is that we can map the data in relation , Second, there is no need to operate the underlying JDBC Connect , Let's pay more attention to the realization of business .

from BeetlSQL Let's take a look at the documents , It does more for the connection , Multiple data sources , Sub database and sub table have their own implementation , I used to use MyBatisPlus I have done a simple multi data test. Although it feels very simple, it is not very perfect .

We use Mybatis The grammar inside, such as #{}、、 Wait for some grammar , stay BeetlSQL It has its own implementation , It's about the same , May be a little resistant to learning new grammar for the first time , But it's very simple .

For the basic operation, we put BeetlSQL It means MyBatisPlus, And more than it is for multiple data sources 、 Operation of sub database and sub table .

Here is BeetlSQL Documentation of ：

BeetlSQL Our goal is to provide development agility , Convenient maintenance , Run a high-speed database access framework , In the case of multiple libraries in a system , Provide a consistent way to write code .

BeetlSQL The goal is to replace the traditional Hibernate,JPA,MyBatis.

BeetlSQL It's not just a simple analogy MyBatis Or is it Hibernate, Or a combination of the two ,BeetlSQL The purpose is to benchmark or even surpass Spring Data, It is a unified framework for data access , Whether it's a traditional database , Big data , Or query engine or timing library , In-memory database .