SQLE 2.2309.0-pre4 Release Notes – New Features, Rule Knowledge Base, and Full Release Information

SQL audit tool SQLE 2.2309.0-pre4 was released today. The following is a detailed interpretation of the new version's release notes.

1. SQLE Project Introduction

SQLE, an open‑source project from the Aikexing community, is a SQL audit tool for database users and administrators. It supports multiple audit scenarios, a standardized release workflow, native MySQL auditing, and extensible database types, currently offering more than 700 built‑in rules.

2. New Version Main Features

# Enterprise Edition

1. New Project‑wide SQL Lifecycle Management Panel

The platform now provides a comprehensive SQL lifecycle management dashboard, showing total collected SQL, problematic SQL, and optimized SQL, enabling quick discovery and remediation of non‑compliant statements. Administrators can assign SQL to team members and manually close resolved items.

SQL Management Panel

2. New Rule Knowledge Base

A knowledge‑base page aggregates expertise from seasoned DBA and operations engineers, offering background, principles, optimization suggestions, and example SQL for each rule, helping developers understand and apply the rules more effectively.

Knowledge Base Page

Users can click the “View More” button on rule lists or audit result pages to access detailed explanations.

Rule List Page

Additionally, users can edit and contribute their own interpretations of rules, sharing valuable experience.

3. New TDSQL Audit Rules

Recommend splitting TEXT‑type fields into a separate table with the primary key.

Place high‑selectivity columns at the beginning of composite indexes.

JOIN fields must have indexes.

When scanning rows exceed a threshold, filter conditions must include a primary key or index.

When query data volume exceeds a threshold, filter conditions must include a primary key or index.

Tables exceeding row‑count thresholds should be split.

Prohibit arithmetic operations or functions on indexed columns.

Character set and collation of joined fields must match.

When using a composite index, the leading column must be used.

Prohibit IN or OR operations on the leftmost column of a composite index.

4. New Intelligent Metadata Scanning Tasks for Database Tables

The TDSQL data source now supports library‑table metadata scanning tasks, allowing automatic collection and analysis of table structures to detect and fix issues, thereby improving query performance.

Create Scanning Task

Table Structure Audit

3. Full Release Information

# Enterprise Edition New Features

[#943] Added full‑lifecycle SQL control feature.

[#958] Added rule knowledge‑base functionality.

[#974] Intelligent scanning now supports TDSQL metadata collection.

[#982] Added new TDSQL audit rules.

Resources

Type

Link

Repository

https://github.com/actiontech/sqle

Documentation

https://actiontech.github.io/sqle-docs/

Release Information

https://github.com/actiontech/sqle/releases

Plugin Development Docs

https://actiontech.github.io/sqle-docs/docs/dev-manual/plugins/howtodev

Community vs Enterprise Comparison

https://actiontech.github.io/sqle-docs/docs/support/compare

Online Demo – Community

http://demo.sqle.actionsky.com (admin / admin)

Online Demo – Enterprise

http://demo.sqle.actionsky.com:8889 (admin / admin)

Previous versions and recommended reading links are listed at the end of the original article.