An excellent open source SQL inspection audit artifact! Never worry about writing SQL anymore

Write in front

The tool to be shared today is an open source artifact related to SQL. It can solve the common pain points between operation and maintenance and development to a certain extent (I believe that there may be small partners who have experience), for development and operation and maintenance It can be regarded as a kind of gospel.

It is a convenient and fast SQL statement review and inspection platform called Yearning, which provides a variety of practical functions including query audit, SQL inspection and review, SQL rollback, custom workflow, etc. It is easy to install and deploy, supports MySQL, and is currently compatible with 99% of the MySQL standard SQL syntax. Support native installation and containerized deployment.

The back-end logic of the Yearning platform is implemented using Go language, with simple syntax and powerful performance; the front-end interface is implemented using the Vue.js framework, and modern rendering technology brings a smooth and beautiful user interface.

This article GitHub https://github.com/rd2coding/Road2Coding has been included, and there are my own six programming directions (positions) self-study routes + knowledge points combing , interview my resume , , hardcore pdf notes , and my programmer life .

---

The main function

Yearning has the following main functions, many of which are very useful tools.

• Automated SQL statement audit, can automatically detect and execute SQL
• Automatically generate rollback statements after DDL/DML statements are executed
• SQL query function, support functions such as query work order, export, automatic completion/intelligent prompt, query statement audit and query result desensitization.
• Support LDAP login/DingTalk and mail message push
• Support custom review workflow
• Support fine-grained authority management and distribution

---

Installation and deployment

Yearning does not rely on any third-party SQL audit tool as an audit engine, and has implemented audit/rollback related logic internally. Only rely on MySQL database.

It provides a binary installation package, the address is https://github.com/cookieY/Yearning/releases, you can Assets to download, and its directory structure is:

Due to space limitations, you can refer to the source code and document address at the end of the text for the specific configuration file writing, platform initialization, and service startup process, just follow the steps.

---

Overview of some functional modules

Backstage Dashboard

This part mainly displays the background overview of the system. The left side is the function menu, and the right area will display the overview preview information of the number of users, data sources, work orders, and queries.

Database (source) management

The database is managed in the form of list management, and data sources can be added/edited/deleted by themselves.

SQL grammar and rule detection

Audit function

Query function

Support SQL syntax highlighting and automatic completion.

---

Source code and document address

The source code/document and the specific installation and usage methods can be referred to: https://github.com/cookiey/yearning

Interested friends can try to install and deploy.

---

postscript

In addition, I have recently spent a lot of effort to organize the programming learning resources for my own use.

They are all pure liver products, the catalog is as follows.

The content GitHub https://github.com/rd2coding/Road2Coding has been included, and there are also self-study routes for the 6 major programming directions that , my resume , , Several hardcore pdf notes , and My Programmer’s Life , welcome star.

It is not easy to organize, welcome support, see you next time!