Tagged articles
66 articles
Page 1 of 1
Aikesheng Open Source Community
Aikesheng Open Source Community
Mar 14, 2024 · Databases

SQLE vs Yearning: Detailed Feature, Architecture, and Use‑Case Comparison

This article provides an in‑depth comparison of the open‑source SQL quality management platforms SQLE and Yearning, covering their architecture, supported data sources, UI design, SQL workbench capabilities, user management, ticket workflow, system settings, and overall suitability for different database environments.

Data QualityDatabase ManagementSQL
0 likes · 10 min read
SQLE vs Yearning: Detailed Feature, Architecture, and Use‑Case Comparison
Aikesheng Open Source Community
Aikesheng Open Source Community
Jan 11, 2024 · Databases

Step-by-Step Guide to Managing SQL Releases with SQLE

This article provides a detailed walkthrough of using the SQLE platform to create users, configure data sources, submit SQL tickets, perform reviews, and execute releases, illustrating each step with screenshots and practical tips for effective database change management.

Database ManagementSQLSQL Release
0 likes · 7 min read
Step-by-Step Guide to Managing SQL Releases with SQLE
Aikesheng Open Source Community
Aikesheng Open Source Community
Jan 8, 2024 · Databases

AIKOS Open Source Community Weekly Newsletter – SQLE Release, Community Updates, and Selected Database Articles

This newsletter announces the SQLE 3.2401.0-pre1 release with automatic data masking, shares recent community development work, outlines upcoming plans, and curates several technical articles covering MySQL EXPLAIN enhancements, transaction fundamentals, hardware considerations for database stability, consistent backup techniques, and efficient JDBC connection testing.

SQLSQLEcommunity
0 likes · 6 min read
AIKOS Open Source Community Weekly Newsletter – SQLE Release, Community Updates, and Selected Database Articles
Aikesheng Open Source Community
Aikesheng Open Source Community
Dec 14, 2023 · Databases

SQLE 3.0 Installation Guide: RPM and Docker Deployment

This article provides a step‑by‑step guide for installing the open‑source SQLE 3.0 SQL quality management platform using both RPM packages and Docker containers, covering environment preparation, configuration file adjustments, service startup, common issues, and troubleshooting tips.

DockerInstallationRPM
0 likes · 11 min read
SQLE 3.0 Installation Guide: RPM and Docker Deployment
Aikesheng Open Source Community
Aikesheng Open Source Community
Oct 30, 2023 · Databases

ActionTech Open Source Community Weekly Newsletter – SQLE Updates, Technical Articles, and Events

The newsletter announces the SQLE 3.0 release with new UI and demo environments, highlights the SQLE 2.2310.0‑pre3 update, reviews technical articles on MySQL cloning, OceanBase indexing, data replication, charset issues, and connection‑pool design, recaps recent conferences, and previews upcoming OB Cloud open class events.

DataReplicationOceanBaseSQL
0 likes · 8 min read
ActionTech Open Source Community Weekly Newsletter – SQLE Updates, Technical Articles, and Events
Aikesheng Open Source Community
Aikesheng Open Source Community
Sep 22, 2023 · Databases

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

The SQLE 2.2309.0-pre4 release introduces an enterprise‑level SQL lifecycle management panel, a rule knowledge base, new TDSQL audit rules, and intelligent metadata scanning tasks, while providing links to the repository, documentation, and demo environments for both community and enterprise editions.

Database AuditingRelease NotesRule Knowledge Base
0 likes · 8 min read
SQLE 2.2309.0-pre4 Release Notes – New Features, Rule Knowledge Base, and Full Release Information
Aikesheng Open Source Community
Aikesheng Open Source Community
Aug 25, 2023 · Databases

SQLE 2.2308.0 Release Notes – New Features for Community and Enterprise Editions

The SQLE 2.2308.0 release introduces intelligent SQL file scanning, per‑instance work‑order approvers, multi‑file MyBatis review in IntelliJ, zero‑cost Java probe integration, new OceanBase‑Oracle support, expanded TDSQL distributed rules, and numerous bug fixes and optimizations across both community and enterprise versions.

Database AuditingIntelliJRelease Notes
0 likes · 9 min read
SQLE 2.2308.0 Release Notes – New Features for Community and Enterprise Editions
Aikesheng Open Source Community
Aikesheng Open Source Community
Aug 4, 2023 · Databases

SQLE 2.2308.0-pre1 Release Notes and Feature Overview

The SQLE 2.2308.0-pre1 release introduces community and enterprise enhancements such as intelligent SQL file scanning, per‑instance workflow approver matching, and the ability to abort deployments on OceanBase and TDSQL data sources, accompanied by usage examples, command‑line instructions, and full release information.

Database AuditingOceanBaseRelease Notes
0 likes · 7 min read
SQLE 2.2308.0-pre1 Release Notes and Feature Overview
Aikesheng Open Source Community
Aikesheng Open Source Community
Jun 9, 2023 · Databases

SQLE 2.2306.0-pre1 Release Notes

The SQLE 2.2306.0-pre1 release introduces support for TDSQL InnoDB and Mycat data sources in enterprise edition, adds new features, UI optimizations, bug fixes, and provides detailed usage instructions and links to documentation, source code, and demo environments.

Database AuditingMycatRelease Notes
0 likes · 8 min read
SQLE 2.2306.0-pre1 Release Notes
Aikesheng Open Source Community
Aikesheng Open Source Community
May 6, 2023 · Databases

SQLE 2.2305.0‑pre1 Release Notes: Project Overview, New Features, and Full Release Details

The SQLE 2.2305.0‑pre1 release introduces a MySQL‑instance‑based smart scan for slow queries, adds configurable data source defaults, fixes several MySQL rule and workflow bugs, and provides comprehensive documentation, download links, and usage examples for both community and enterprise editions.

Database AuditingRelease NotesSQL
0 likes · 7 min read
SQLE 2.2305.0‑pre1 Release Notes: Project Overview, New Features, and Full Release Details
Aikesheng Open Source Community
Aikesheng Open Source Community
Apr 22, 2023 · Databases

Weekly Tech News Digest – Database and SQL Updates

This weekly roundup curates the latest high‑quality technical shares on databases, featuring articles about PolarDB HTAP acceleration, MySQL datetime precision, new MySQL releases, ChatGPT as a database client, and the SQLE platform's recent enhancements and upcoming plans.

SQLSQLEdatabase
0 likes · 4 min read
Weekly Tech News Digest – Database and SQL Updates
Aikesheng Open Source Community
Aikesheng Open Source Community
Apr 14, 2023 · Databases

SQLE 2.2304.0-pre2 Release Notes – Project Overview, New Features, and Full Release Information

The article introduces the SQLE 2.2304.0-pre2 preview release, outlines the tool’s purpose for database users and administrators, details new enterprise‑level features such as affected‑row statistics and enhanced rule severity display, lists added MySQL audit rules, and provides complete release information and resource links.

Database AuditingRelease NotesSQL
0 likes · 6 min read
SQLE 2.2304.0-pre2 Release Notes – Project Overview, New Features, and Full Release Information
Aikesheng Open Source Community
Aikesheng Open Source Community
Apr 3, 2023 · Databases

SQL Quality Management with Open-Source SQLE: Insights from the 2023 DAMS China Data Intelligence Management Summit

The 2023 DAMS China Data Intelligence Management Summit in Shanghai featured a technical presentation by Zhang Shenbo on an open‑source SQLE solution for SQL quality control, covering multi‑database auditing, automated review workflows, and practical tips to reduce DBA workload and cross‑department communication.

Data GovernanceData QualityDatabase Management
0 likes · 3 min read
SQL Quality Management with Open-Source SQLE: Insights from the 2023 DAMS China Data Intelligence Management Summit
Aikesheng Open Source Community
Aikesheng Open Source Community
Feb 17, 2023 · Databases

SQLE 2.2302.0-pre5 Release Notes and New Features

The preview release of SQLE version 2.2302.0-pre5 introduces optimized CloudBeaver integration, UI improvements, bug fixes, and provides detailed project information, release notes, and resources for database users and administrators.

CloudBeaver IntegrationDatabase AuditingRelease Notes
0 likes · 3 min read
SQLE 2.2302.0-pre5 Release Notes and New Features
Aikesheng Open Source Community
Aikesheng Open Source Community
Feb 3, 2023 · Databases

SQLE 2.2302.0-pre3 Release Notes and Feature Overview

The SQLE 2.2302.0-pre3 release introduces a preview version of the SQL audit tool with enhanced SQL Server audit plugin, new rule support, context-aware auditing, rollback generation, and several UI optimizations, while providing links to repositories, documentation, and demo environments.

Database SecurityRelease NotesSQL Server
0 likes · 4 min read
SQLE 2.2302.0-pre3 Release Notes and Feature Overview
Aikesheng Open Source Community
Aikesheng Open Source Community
Jan 13, 2023 · Databases

SQLE 2.2302.0-pre2 Release Notes: Project Overview, New Features, and Full Release Information

The article introduces the SQLE project, details the new preview version 2.2302.0-pre2 with features such as external data source import and DMP integration, and provides the complete release notes, optimization items, links to previous versions, and additional reading resources.

Data Source IntegrationDatabase AuditingRelease Notes
0 likes · 4 min read
SQLE 2.2302.0-pre2 Release Notes: Project Overview, New Features, and Full Release Information
Aikesheng Open Source Community
Aikesheng Open Source Community
Jan 6, 2023 · Databases

SQLE 2.2302.0-pre1 Release Notes and Feature Overview

The preview release of SQLE 2.2302.0-pre1 introduces manual deployment support, UI enhancements, and several bug fixes, providing a detailed overview of the project's purpose, new functionalities, and complete release information for database users and administrators.

Database AuditingRelease NotesSQL
0 likes · 5 min read
SQLE 2.2302.0-pre1 Release Notes and Feature Overview
Aikesheng Open Source Community
Aikesheng Open Source Community
Dec 23, 2022 · Databases

SQLE 2.2212.0-pre3 Release Notes and New Features

The SQLE 2.2212.0-pre3 pre‑release introduces DingTalk‑integrated workflow approvals, adds phone‑number based user binding, and includes several feature enhancements, optimizations, and bug fixes, with full release details, download links, and references to prior versions and related resources.

Database AuditingDingTalk IntegrationRelease Notes
0 likes · 4 min read
SQLE 2.2212.0-pre3 Release Notes and New Features
Aikesheng Open Source Community
Aikesheng Open Source Community
Oct 14, 2022 · Databases

SQLE 1.2210.0-pre1 Release Notes: New MySQL Audit Rules, Enhanced Scanning Filters, and UI Improvements

The SQLE 1.2210.0-pre1 preview release introduces new MySQL audit rules prohibiting rename/change operations and requiring LIMIT clauses, adds filter options to the intelligent scan task list, refines work‑order progress styling, and provides a detailed list of features, optimizations, and bug fixes.

Database AuditingRelease NotesSQLE
0 likes · 5 min read
SQLE 1.2210.0-pre1 Release Notes: New MySQL Audit Rules, Enhanced Scanning Filters, and UI Improvements
Aikesheng Open Source Community
Aikesheng Open Source Community
Sep 23, 2022 · Databases

SQLE 1.2209.0-pre3 Release Notes: Project Overview, New Features, and Full Release Information

The SQLE 1.2209.0-pre3 preview release introduces CloudBeaver integration, unified login, automated SQL compliance checks, and several bug fixes, while providing project background, detailed feature demonstrations, full release notes, and links to documentation, demos, and community resources.

CloudBeaverDatabase AuditingRelease Notes
0 likes · 4 min read
SQLE 1.2209.0-pre3 Release Notes: Project Overview, New Features, and Full Release Information
Aikesheng Open Source Community
Aikesheng Open Source Community
Aug 12, 2022 · Databases

SQLE 1.2208.0-pre2 Release Notes: Project Overview, New Features, and Full Release Information

The preview release SQLE 1.2208.0-pre2 introduces a comprehensive report statistics page for the enterprise edition, details the project's purpose, provides resource links, enumerates new feature items such as work‑order metrics and license usage, and lists bug fixes and links to prior versions.

Database AuditingRelease NotesSQLE
0 likes · 7 min read
SQLE 1.2208.0-pre2 Release Notes: Project Overview, New Features, and Full Release Information
Aikesheng Open Source Community
Aikesheng Open Source Community
Jul 29, 2022 · Databases

SQLE 1.2207.0 Release Notes and Feature Summary

The SQLE 1.2207.0 release introduces a redesigned dashboard, incremental intelligent scanning for slow‑log and TiDB audit logs, OceanBase MySQL‑mode audit plugin, JetBrains IDE audit plugin, along with numerous optimizations, bug fixes, and detailed release information for both community and enterprise editions.

Database AuditingIDE pluginOceanBase
0 likes · 7 min read
SQLE 1.2207.0 Release Notes and Feature Summary
Aikesheng Open Source Community
Aikesheng Open Source Community
Jul 22, 2022 · Databases

SQLE 1.2207.0-pre2 Release Notes: New IDE Plugin, Incremental Smart Scan, and Full Feature List

The SQLE 1.2207.0-pre2 preview release introduces a JetBrains IDE audit plugin, supports incremental smart scanning for slow logs and TiDB audit logs, provides updated dashboards, optimizations, bug fixes, and includes detailed deployment links and a complete list of new features and improvements.

Database AuditingIDE pluginIncremental Scan
0 likes · 6 min read
SQLE 1.2207.0-pre2 Release Notes: New IDE Plugin, Incremental Smart Scan, and Full Feature List
Aikesheng Open Source Community
Aikesheng Open Source Community
Jul 15, 2022 · Databases

SQLE 1.2207.0‑pre1 Release Notes: New OceanBase MySQL Support, Feature Updates, and Bug Fixes

The SQLE 1.2207.0‑pre1 pre‑release introduces OceanBase MySQL‑mode audit plugins, exclusive OceanBase rules, enhanced table‑name case checks, count(*) recommendations, adds TiDB audit‑log support, fixes several MySQL‑related bugs, and outlines future plans for more OceanBase and Oracle‑mode auditing capabilities.

Database AuditingOceanBaseRelease Notes
0 likes · 5 min read
SQLE 1.2207.0‑pre1 Release Notes: New OceanBase MySQL Support, Feature Updates, and Bug Fixes
Aikesheng Open Source Community
Aikesheng Open Source Community
Jun 27, 2022 · Databases

SQLE 1.2206.0-pre2 Release Notes: New Features, Full Release Information, and Future Plans

The preview release SQLE 1.2206.0-pre2 introduces enterprise‑level SQL drill‑down analysis, a refreshed login page, detailed release notes with new features and bug fixes, and outlines future plans to support more database types, while providing links to documentation, demos, and previous versions.

Bug FixesDatabase AuditingRelease Notes
0 likes · 4 min read
SQLE 1.2206.0-pre2 Release Notes: New Features, Full Release Information, and Future Plans
Aikesheng Open Source Community
Aikesheng Open Source Community
Jun 17, 2022 · Databases

SQLE 1.2206.0-pre1 Release Notes and New Feature Overview

The preview release SQLE 1.2206.0-pre1 introduces TiDB audit plugin support, TiDB‑specific rules, enhanced SQL syntax checks, and recommendations on primary‑key usage, while providing full release details, documentation links, and references to prior versions for database administrators and developers.

Database AuditingRelease NotesSQLE
0 likes · 6 min read
SQLE 1.2206.0-pre1 Release Notes and New Feature Overview
Aikesheng Open Source Community
Aikesheng Open Source Community
May 20, 2022 · Databases

SQLE 1.2205.0-pre3 Release Notes and Feature Overview

The article introduces the SQLE 1.2205.0-pre3 preview release, detailing the project's purpose, new enterprise‑edition SQL query features, complete release notes, and upcoming plans, while providing download links, documentation, and demo environments for users and administrators.

Database AuditingFeature OverviewRelease Notes
0 likes · 5 min read
SQLE 1.2205.0-pre3 Release Notes and Feature Overview
Aikesheng Open Source Community
Aikesheng Open Source Community
May 7, 2022 · Databases

SQLE 1.2205.0-pre1 Release Notes: Project Overview, New Features, and Full Release Information

The article introduces the SQLE 1.2205.0-pre1 release, detailing the project's purpose, new capabilities such as OAuth2 login integration and improved MySQL syntax‑error handling, and provides complete release notes, bug fixes, links to documentation, previous versions, and community resources.

Database AuditingOAuth2Release Notes
0 likes · 7 min read
SQLE 1.2205.0-pre1 Release Notes: Project Overview, New Features, and Full Release Information
Aikesheng Open Source Community
Aikesheng Open Source Community
Mar 31, 2022 · Databases

Introducing SQLE: An Open‑Source SQL Quality Control Platform and Its CI/CD Integration

This article introduces SQLE, an open‑source platform for end‑to‑end SQL development, testing, and deployment with fine‑grained resource and permission management, explains its key features such as MyBatis scanning, slow‑log analysis, and CI/CD integration via a scanner tool, and demonstrates its usage through Jenkins and the SQLE web UI.

SQLEci/cd
0 likes · 6 min read
Introducing SQLE: An Open‑Source SQL Quality Control Platform and Its CI/CD Integration
Aikesheng Open Source Community
Aikesheng Open Source Community
Mar 9, 2022 · Databases

Introducing SQLE: An Open‑Source SQL Quality Control Platform with Java Application Auditing

The article presents SQLE, an open‑source SQL quality‑control tool that supports end‑to‑end development, testing, and deployment, highlights new features in version 1.2202.0—including user‑group permissions, MySQL rules, and Java application auditing—and demonstrates a step‑by‑step integration workflow with code examples and screenshots.

Database ManagementJava integrationSQL Auditing
0 likes · 7 min read
Introducing SQLE: An Open‑Source SQL Quality Control Platform with Java Application Auditing
Aikesheng Open Source Community
Aikesheng Open Source Community
Jan 28, 2022 · Databases

SQLE 1.2201.0 Release Notes

The SQLE 1.2201.0 release introduces workflow optimizations, new MySQL and SQL Server audit rules, enhanced pre‑check capabilities, several UI improvements, and numerous bug fixes, while providing links to the source repository, documentation, and plugin development guide.

ReleaseNotesSQLEaudit
0 likes · 5 min read
SQLE 1.2201.0 Release Notes
Aikesheng Open Source Community
Aikesheng Open Source Community
Oct 29, 2021 · Databases

SQLE 1.2110.0-pre1 Release Notes

The pre‑release version 1.2110.0‑pre1 of the open‑source SQL audit tool SQLE is announced, detailing its project overview, repository links, new feature (Online DDL support), UI optimizations, and bug fixes, followed by promotional links and unrelated personal commentary.

SQLSQLEaudit
0 likes · 3 min read
SQLE 1.2110.0-pre1 Release Notes