Tagged articles
SQL Auditing
14 articles · Page 1 of 1
This article walks through the challenges of using goInception with OceanBase‑MySQL tenants, details the code modifications required to parse OB's Query Plan, shows how to expose the enhanced engine via a Python wrapper, and presents validation results demonstrating accurate, low‑latency SQL auditing.
OB-MySQLOceanBasePython
0 likes · 10 min read

Yearning is an open‑source Go + Vue MySQL audit platform that streamlines SQL review, approval, execution, and automatic rollback; this guide walks you through installing it on aimalinux or via Docker Compose, configuring DataGrip, and best practices for secure, traceable DBA workflows.
DataGripMySQLSQL Auditing
0 likes · 8 min read

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

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.
DB2SQL AuditingTOP SQL
0 likes · 5 min read

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.
ConcurrencyMySQLSQL Auditing
0 likes · 3 min read

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.
MySQLSQL AuditingTech Newsletter
0 likes · 4 min read

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.
Java integrationSQL AuditingSQLE
0 likes · 7 min read

This article describes how to implement a low‑overhead SQL audit feature for the Cobar database middleware by modifying its code, using an agent with Kafka, choosing UDP for inter‑process communication, and designing a custom ring‑buffer to achieve near‑baseline throughput with only minimal performance loss.
CobarJavaSQL Auditing
0 likes · 11 min read

This article traces the evolution of database autonomy from manual, knowledge‑driven operations through tool‑assisted and expert‑level stages to cloud‑native intelligent services, and details Tencent's DBbrain platform, its architecture, performance‑optimization, security, monitoring, cost‑based analysis, and future self‑healing capabilities.
AI OpsDBbrainDatabase Autonomy
0 likes · 29 min read


ITPUBMar 30, 2020 · Databases
Yearning is an open‑source MySQL audit platform that offers query auditing, SQL review, and workflow automation, providing a web‑based interface for managing tickets, permissions, and notifications, with detailed installation and configuration instructions for quick deployment.
MySQLSQL AuditingYearning
0 likes · 7 min read

This article outlines the journey of a financial services company from manual DBA tasks through tool‑assisted operations to a fully automated platform, detailing the platform’s technical stack, functional modules, metadata design principles, evolving SQL audit workflow, and future directions for intelligent database operations.
DBAPlatformSQL Auditing
0 likes · 17 min read

This article explains eight common reasons why Oracle SQL statements fail to use indexes, provides concrete rewrite techniques, shows how optimizer bugs can block index usage, and outlines practical steps for enforcing SQL development standards through automated audit tools.
Database PerformanceIndex OptimizationOracle
0 likes · 13 min read

This article provides a comprehensive guide to Oracle Data Guard, covering its disaster‑recovery concepts, RTO/RPO standards, hardware‑to‑application level design considerations, standby design options, sensitive data‑file operations, switchover/failover advice, SQL auditing with Snapshot Standby, and practical tips for building or rebuilding a Data Guard environment.
DG BrokerData GuardOracle
0 likes · 20 min read

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.
DBADevOpsSQL Auditing
0 likes · 29 min read
