SQLE 1.2208.0-pre3 Release Notes: New MySQL Audit Rules and Scenario‑Based Auditing

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.

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. Added MySQL Audit Rules

Prohibit use of TIMESTAMP fields (2038 limitation and timezone conversion).

Disallow adding columns with AFTER/BFORE clauses (DDL with AFTER copies the whole table).

Limit IN clause values to fewer than N items (DECIMAL performance concerns).

Disallow ORDER BY in SELECT statements (ORDER BY heavily impacts MySQL performance).

Require CREATE_TIME with default CURRENT_TIMESTAMP and UPDATE_TIME with default CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP on table creation (standardize record lifecycle).

2. MySQL Audit Scenario‑Based Refactoring and Post‑Audit Mode

The tool now supports separate rule templates for different audit scenarios (pre‑audit and post‑audit). Users can configure rule templates, enable “disable online audit mode,” and thus avoid false‑positive checks on already‑executed SQL such as CREATE TABLE statements.

Images illustrating template configuration and task creation are included in the original article.

3. Complete Release Information

Features

[#755] Smart scan supports specifying a particular rule template.

[#716] MySQL audit scenario refactoring compatible with post‑audit mode.

[#734] Added several MySQL audit rules (listed above).

Optimizations

[#761][#757][#752] Enterprise edition report statistics enhancements.

Bug Fixes

[#708] Fixed false‑positive field‑missing errors for certain MySQL statements.

Links to previous versions, recommended reading, and community resources are provided at the end of the article.