Writing in the front

The tool I want to share today is an open source artifact related to SQL. It can solve the common pain points between operation and development to a certain extent (I believe there may be some friends also experience). It is also a blessing for development and operation.

Ten years ago, it is a convenient platform for reviewing and checking SQL statements. Called ten years ago, it offers a variety of useful features including query audit, SQL review, SQL rollback, custom workflow, and more. Easy to install and deploy, support MySQL, currently compatible with 99% of MySQL standard SQL syntax. Native installation and container deployment are supported.

The back end logic on this platform is realized by Go language with concise syntax and powerful performance. The front-end interface is realized by vue. js framework, and modern rendering technology brings smooth and beautiful user interface.

In this paper, making github.com/rd2coding/R… Already included, it contains my organized 6 major programming direction (job) self-study route + knowledge points, interview test points, my resume, several core PDF notes, and my programmer life.

The main function

Ten years ago. Many of these are very useful tools.

  • Automatic SQL statement audit, SQL can be automatically detected and executed
  • A rollback statement is automatically generated after the DDL/DML statement is executed
  • SQL query function: supports work order query, export, automatic completion/intelligent prompt, query statement audit, and query result desensitization.
  • Support LDAP login/pinning and email message push
  • Support custom audit workflows
  • Supports fine-grained rights management and assignment

Install the deployment

This does not rely on any third party SQL audit tool as an audit engine and implements its own audit/rollback logic. Rely only on the MySQL database.

It provides a binary installation package at github.com/cookieY/Yea… Wire-x.x.x. linux-amd64.zip package from Assets. The directory structure is as follows:

Limited by space, the specific configuration file writing, platform initialization and service startup process can refer to the source code and document address at the end of the article, and follow the steps.

Overview of some functional modules

The background Dashboard

This section shows the overview of the system background. On the left is the function menu, and on the right is the overview preview information about users, data sources, work orders, and queries.

Database (source) management

Manage the database in a list management manner, adding/editing/deleting data sources.

SQL syntax and rule detection

auditing

Query function

Supports SQL syntax highlighting and automatic completion.

Source code and documentation address

The source code/documentation and specific installation and use methods can be found at github.com/cookiey/yea…

Interested partners can install deployment to try.

Afterword.

In addition, recently spent a lot of effort, the use of programming learning resources to do a big arrangement.

It’s pure liver. Here’s the list.

GitHub github.com/rd2coding/R… It also includes my resume, interview test points, several hardcore PDF notes, and my life as a programmer. Welcome star.

Sorting is not easy, welcome support, see you next time!