SQLE 4.2502.0 Release: New Features, Upgrade Guide, and Version Log

After 498 days since SQLE 3.0, the SQLE 4.2502.0 official version has been released, marking the entry of SQLE into the 4.0 era.

🎈 Main New Features Overview

1. SQL Compliance Rewriting – Intelligent rewriting of non‑standard SQL statements saves manual debugging time and reduces database maintenance costs. Detailed description

2. SQL Performance Tracker – Visual analysis of execution history and efficiency changes enables rapid identification of performance bottlenecks, shortening troubleshooting time. Detailed description

3. Syntax Rule Knowledge Graph – Graphical decomposition of database syntax standards allows users without deep expertise to easily grasp compliance points. Detailed description

4. Complete New Function Introduction

Community Edition

Added rule performance consumption label

Enterprise Edition

SQL Compliance Rewriting

Cost trend chart & execution plan comparison

Database syntax knowledge graph

Disable local password login, unified identity authentication

Two‑factor authentication (bank‑level security)

⚠️ Upgrade Instructions

New installation of SQLE 4.2502.0 can skip this section. SQLE 4.x introduces non‑compatible changes; SQLE 3.x requires manual upgrade steps and will no longer receive official releases. Users are advised to upgrade to 4.x.

Upgrade operation: https://actiontech.github.io/sqle-docs/docs/deploy-manual/upgrade/

Upgrade notes:

⚠️ Back up metadata before upgrading.

⚠️ Ensure no work orders are being deployed; upgrading during SQL deployment may cause failures.

✔️ For cluster deployments, pause all SQLE services on every node before upgrading.

⚠️ Switching from non‑cluster to cluster mode requires a new license.

✔️ For enterprise edition upgrades, contact ActionSky (contact details at the end of the article).

📜 Version Log

Community Edition

New Features

[#2891] Support for new MySQL rules

[#2897] Added performance consumption tag for audit rules

Optimizations

[#2882] Database plugin rule error hints

[#2906] New classification tags for MySQL rules

[#2888] Optimized performance impact of row‑count judgment

[#2860] Improved error display during audit

[#2868] Improved error display for intelligent scanning

[#2857] Rule optimization: when scanned rows exceed threshold, filter conditions must include primary key or index

Bug Fixes

[#2915] Fixed connection leak caused by SQL analysis

[#2867] Fixed error with HAVING clause in audit

[#2884] Fixed missing classification in audit rule error messages

[#2851] Fixed persistent previous connection status after data source connectivity test

[#2895] Fixed duplicate scan task instance prompts

[#2855] Fixed panic issue in MySQL audit rules

[#2846] Fixed inability to select audit rule templates under a project

[#2797] Fixed inability to enable debug mode in logs

[#2863] Fixed language inconsistency in menu and homepage

[#2865] Fixed admin user unable to access SQLE operation records page

[#2933] Fixed project admin operation restrictions

Enterprise Edition

New Features

Support disabling local password login

SMS two‑factor authentication

Multi‑dimensional knowledge base view

Support for ActionDB data source audit plugin

Cost trend chart in SQL execution plan

SQL rewrite capability

Optimizations

Optimized entry for SQL rewrite

Improved slow‑log viewing method

Optimized SQL with performance issues

Enhanced knowledge graph display and content

Cost trend chart now compares historical execution plan costs

SQL Server plugin no longer requires separate dotnet installation

Unified version management for plugins

Removed redundant menus from project navigation

Bug Fixes

Fixed OAuth2 third‑party login session issue

Fixed permission issue for designated approvers in workflow templates

Fixed SQL Server custom function support blocking work orders

Fixed missing comparison values in global dashboard description

Fixed Oracle TOP SQL intelligent scan failure

Fixed meaningless numbering in HANA audit results

Fixed empty content in report statistics for database‑type work order composition

Fixed permission control error in audit workflow template

Fixed coding platform connectivity test error

Fixed SQL control page instance scan task jump failure

Fixed non‑SQLE permissions appearing in permission list

Fixed user‑created same‑name user causing SQL workbench service exception

Fixed unauthorized users seeing operation and audit titles

🧩 Version Selection

Community Edition: Lightweight MySQL development governance tool for individuals and small teams.

Professional Edition: Multi‑data‑source governance platform for medium‑size teams.

Enterprise Edition: Enterprise‑grade data asset compliance platform for large organizations.

Online demo environments are available for community and enterprise editions.

Community demo: http://demo.sqle.actionsky.com/ (username: admin, password: admin)

Enterprise demo: http://demo.sqle.actionsky.com:8889/

Professional edition installation package can be obtained by completing the survey questionnaire (QR code or original link).

Resources:

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

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

Official website: https://opensource.actionsky.com/sqle/

Community group: ActionOpenSource

Commercial support: https://www.actionsky.com/sqle