SQLE 2.2212.0-pre1 Release Notes: Project Overview, New Features, and Full Release Information
The article introduces the open‑source SQLE tool, outlines its project background, details the new IDE plugin support for MyBatis XML and SQL file auditing, and provides a comprehensive list of features, optimizations, and bug fixes included in the 2.2212.0-pre1 preview release.
Version: 2.2212.0-pre1
Release Notes
SQL audit tool SQLE 2.2212.0-pre1 was released today. The following is a detailed interpretation of the new version's release notes. Note: this is a preview version; new features are for trial use only and a smooth upgrade is not guaranteed.
1. SQLE Project Introduction
SQLE, an open‑source project from the Aikexing community, is a SQL audit tool aimed at database users and administrators. It supports multi‑scenario auditing, standardized release processes, native MySQL audit, and extensible database types.
Resources
Type
URL
Repository
https://github.com/actiontech/sqle
Documentation
https://actiontech.github.io/sqle-docs-cn/
Release Information
https://github.com/actiontech/sqle/releases
Audit Plugin Development Docs
https://actiontech.github.io/sqle-docs-cn/3.modules/3.7_auditplugin/auditplugin_development.html
Community Edition Demo
http://demo.sqle.actionsky.com (admin / admin)
Enterprise Edition Demo
http://demo.sqle.actionsky.com:8889 (admin / admin)
2. New Version Main Features
1. IDE Plugin Supports Auditing MyBatis XML Files and SQL Files
The SQLE IDEA plugin (JetBrains series) now adds support for auditing MyBatis XML files. Developers can audit XML files directly within the IDE, quickly discovering non‑standard SQL. The plugin also supports auditing individual SQL snippets or full‑file audits, improving convenience.
Installation instructions are available at https://actiontech.github.io/sqle-docs-cn/3.modules/4.1_auxiliary_tool/jetbrains_plugin.html . After installing, right‑click the target XML or SQL file in the editor and select the SQLE audit option.
Audit results are displayed in a pop‑up window:
SQL file auditing works similarly; the screenshot below shows the result for an SQL file:
3. Complete Release Information
Features
[#1173] IDE plugin supports auditing MyBatis XML files and SQL files.
Optimizations
[#1182] Project member functionality improved: member dropdown now searchable, group members displayed in list.
[#1175][#1174][#1147][#1141] UI adjustments and refinements.
Bug Fixes
[#1162] Fixed issue where filtering project members after setting a user group displayed bound users incorrectly.
[#1158] Fixed inability to unbind audit rule templates when updating data sources.
[#1180] Fixed failure when executing specific PostgreSQL statements such as "create index ..." during release.
Previous Versions
SQLE v2.2211.0
SQLE v2.2211.0-pre4
Recommended Reading
Common MySQL/Oracle SQL Development Rules
How to Quickly Use SQLE for Various Database Audits
SQLE Compatibility Test with MySQL 8.0
Developing a Custom Rule in SQLE
Using SQLE for Development‑Stage SQL Audits
For more information and community discussion, join the official QQ group: 637150065 .
Aikesheng Open Source Community
The Aikesheng Open Source Community provides stable, enterprise‑grade MySQL open‑source tools and services, releases a premium open‑source component each year (1024), and continuously operates and maintains them.
How this landed with the community
Was this worth your time?
0 Comments
Thoughtful readers leave field notes, pushback, and hard-won operational detail here.