SQLE 2.2309.0-pre3 Release Notes: New Quick SQL Audit, MySQL Audit Rules, and Full Release Details

SQL audit tool SQLE 2.2309.0-pre3 has been released, and this article provides a detailed interpretation of the release notes.

1. SQLE Project Introduction SQLE is an open‑source SQL audit tool for database users and administrators, supporting multi‑scenario audits, standardized release processes, native MySQL auditing, and extensible database types, with over 700 built‑in rules.

2. New Version Main Features

# Community Edition

1. Fast SQL Audit Users can submit SQL directly without creating a ticket and receive immediate audit results, including static analysis without a data source and ZIP file uploads; business tags can be added to audit records.

SQL audit function

2. New MySQL Audit Rules

Suggest splitting TEXT columns and storing them with primary keys in separate tables.

Place high‑selectivity columns first in composite indexes.

JOIN fields must have indexes.

When scanned rows exceed thresholds, filter conditions must include primary keys or indexes.

When query data volume exceeds thresholds, filter conditions must include primary keys or indexes.

Suggest splitting tables that exceed row thresholds.

Prohibit mathematical operations or functions on indexed columns.

Character set and collation of joined table fields must be consistent.

# Enterprise Edition

Optimizations

Optimized intelligent scanning tasks for MySQL slow‑log file types.

3. Full Release Information

Community and enterprise version feature comparisons, online demo links (admin/admin for community, user/admin for enterprise), and documentation URLs are provided.

Previous Versions

SQL Audit | SQLE 2.2308.0

SQL Audit | SQLE 2.2307.0

SQL Audit | SQLE 2.2306.0

SQL Audit | SQLE 2.2305.0

Reading Recommendations

Open‑Source Product Evaluation: SQL Release Capability

Common MySQL/Oracle SQL Development Rules

How to Quickly Use SQLE to Audit Various Databases

SQLE Compatibility with MySQL 8.0 Evaluation

About SQLE

SQLE is an open‑source SQL audit tool for database users and administrators, supporting multi‑scenario audits, standardized release processes, native MySQL auditing, and extensible database types.

SQLE Access

🔗 Github: https://github.com/actiontech/sqle

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

💻 Official Site: https://opensource.actionsky.com/sqle/

👥 WeChat technical group: add admin WeChat ActionOpenSource