Tag

SQL auditing

0 views collected around this technical thread.

Aikesheng Open Source Community
Aikesheng Open Source Community
May 25, 2024 · Databases

Improving SQL Quality Management: Problems, Case Study, and Best Practices with SQLE

The article explains what constitutes an SQL problem, presents a typical case of performance degradation caused by mismatched character sets, and outlines how the SQLE platform can help developers, testers, and DBAs systematically manage and improve SQL quality throughout the software lifecycle.

DBADatabase QualityDevOps
0 likes · 10 min read
Improving SQL Quality Management: Problems, Case Study, and Best Practices with SQLE
Aikesheng Open Source Community
Aikesheng Open Source Community
May 12, 2023 · Databases

SQLE 2.2305.0-pre2 Release Notes: New DB2 Metadata and TOP SQL Scanning Features

The SQLE 2.2305.0-pre2 release introduces enterprise‑grade DB2 table‑metadata and TOP SQL scanning tasks, expands audit rule support, provides detailed release notes and links to documentation, repositories, and demo environments for database users and administrators.

DB2Release NotesSQL auditing
0 likes · 5 min read
SQLE 2.2305.0-pre2 Release Notes: New DB2 Metadata and TOP SQL Scanning Features
Aikesheng Open Source Community
Aikesheng Open Source Community
Oct 15, 2022 · Databases

Weekly Tech Share Summary – Database Updates and SQL Auditing News

This weekly newsletter curates top community tech shares, featuring MySQL 8.0 updates, database localization insights, concurrency consistency strategies, a new SQL auditing tool release, development progress, upcoming plans, and invites community feedback on DBLE, DTLE, SQLE, and TXLE middleware.

DatabaseMySQLOpen-source
0 likes · 3 min read
Weekly Tech Share Summary – Database Updates and SQL Auditing News
Aikesheng Open Source Community
Aikesheng Open Source Community
Sep 24, 2022 · Databases

Weekly Database and Big Data Article Highlights

This weekly roundup presents a curated selection of high‑quality technical articles and resources on MySQL, database error‑log analysis, big‑data task optimization, SQL injection case studies, and upcoming SQLE development plans, offering readers up‑to‑date insights into database engineering and performance best practices.

Big DataDatabaseMySQL
0 likes · 4 min read
Weekly Database and Big Data Article Highlights
Aikesheng Open Source Community
Aikesheng Open Source Community
Aug 27, 2022 · Databases

Weekly SQLE Newsletter: New MySQL Audit Rules, RDS Slow‑Log Support, and Upcoming TiDB Plugin

The weekly SQLE newsletter curated by community reporter Yongzheng highlights recent MySQL audit rule additions, Alibaba Cloud RDS slow‑log support, links to several in‑depth technical articles, open‑source progress, and outlines development plans for the coming week.

Database ToolsMySQLSQL auditing
0 likes · 4 min read
Weekly SQLE Newsletter: New MySQL Audit Rules, RDS Slow‑Log Support, and Upcoming TiDB Plugin
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.

CI/CDDatabase ToolsOpen-source
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 integrationOpen-source
0 likes · 7 min read
Introducing SQLE: An Open‑Source SQL Quality Control Platform with Java Application Auditing
Efficient Ops
Efficient Ops
May 8, 2016 · Databases

Mastering Oracle DevOps: SQL Auditing Best Practices to Boost Performance

This article, based on a 2016 Global Operations Conference talk, outlines Oracle DevOps best practices through SQL auditing, presenting multiple real‑world cases, derived rules, and automation strategies that help DBA and development teams identify performance bottlenecks, enforce standards, and improve system stability.

DBADevOpsOracle
0 likes · 29 min read
Mastering Oracle DevOps: SQL Auditing Best Practices to Boost Performance
Efficient Ops
Efficient Ops
Nov 23, 2015 · Databases

How Tencent’s TMySQLParse Automates MySQL SQL Auditing and Cuts DBA Workload

This article explains the background, implementation, usage, and real‑world integration of TMySQLParse, a MySQL‑compatible SQL audit tool developed by Tencent to automatically detect syntax errors and high‑risk statements, thereby streamlining the game‑cloud change‑order workflow.

Database ToolsMySQLSQL auditing
0 likes · 12 min read
How Tencent’s TMySQLParse Automates MySQL SQL Auditing and Cuts DBA Workload