Aikexing Open Source Community Weekly Newsletter – Updates, Technical Articles, and Event Recommendations

1 Community Updates

SQLE 3.2403.0‑pre3 has been released. The community edition now automatically checks browser version compatibility and provides incompatibility prompts, while the enterprise edition adds support for the Dameng database.

Automatic browser version compatibility checking (community edition)

Support for Dameng database (enterprise edition)

Last week’s work included adding Dameng support, feature optimizations, and bug fixes. This week’s focus is on QR‑code machine‑info viewing, dynamic‑key login for SQLE, and further bug fixes.

SQLE Professional Edition Launch

The SQLE Professional Edition is now available for free, supporting more than ten mainstream data sources.

2 Community Article Review

08 Issue – Two‑Phase Commit (2) – Commit Phase : The article introduces concepts related to the commit sub‑phase of the two‑phase commit protocol.

Technical Share – Locating Large Transactions via Binlog : Large transactions can be identified by examining binlog file size; a sudden increase that exceeds max_binlog_size indicates a large transaction.

Technical Translation – Does Adding a Primary Key Save Disk Space? : While MySQL does not require a primary key, its absence can degrade performance, especially in MGR and PXC architectures where primary keys are mandatory.

One‑Week Picks – MySQL Cost Estimator : The cost estimator, a core component of the Cost‑Based Optimizer, evaluates I/O and CPU costs for different access paths, tightly coupled with storage‑engine characteristics.

3 One‑Week Selections

Featured article: “Shallow Analysis of MySQL Cost Estimator” – explains the role of the estimator in query optimization.

Other highlighted reads include an OceanBase 500‑tenant memory analysis and a MySQL 8.0 replication slow‑log case study.

4 Event Recommendations

3/11‑3/17 – “Curator Book Recommendation” Second Issue : Collaboration with five high‑quality public accounts; participants can win books from the “Great Wisdom, Small Skills” series.

Beijing 3/16 – Open‑Source Database 2024 Showcase : The community will exhibit at the event, offering technical exchanges and giveaways.

Guangzhou 3/16 – SACC China System Architect Conference : Theme “Digital Transformation & Architecture Evolution” with tracks on multi‑cloud architecture, big‑data platforms, intelligent operations, and AIGC applications.

About SQLE

SQLE is a comprehensive SQL quality management platform covering development to production, supporting major open‑source, commercial, and domestic databases, and providing automated workflow capabilities to improve release efficiency and data quality.

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

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

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

WeChat group: Add admin WeChat “ActionOpenSource”.