BestHub
Sign in
Tagged articles
2782 articles
Page 4 of 28
Alibaba Cloud Developer
Alibaba Cloud Developer
Jun 5, 2025 · Databases

Enable Native Multimodal AI Search with SQL on PolarDB

This article explains how to use standard SQL on PolarDB PostgreSQL to directly invoke multimodal AI services for image feature extraction and vectorization, eliminating data migration and complex toolchains while providing low‑threshold integration, flexible scenario adaptation, full‑link security, and serverless, pay‑as‑you‑go deployment.

Polardbdatabase integrationmultimodal AI
0 likes · 6 min read
Enable Native Multimodal AI Search with SQL on PolarDB
Java Tech Enthusiast
Java Tech Enthusiast
Jun 3, 2025 · Backend Development

Common MySQL Index Failure Scenarios and How to Diagnose Them

This article presents a series of MySQL interview questions and answers that illustrate typical situations where indexes become ineffective—such as leading wildcards in LIKE, NOT IN, NOT EXISTS, functions, inequality operators, OR conditions, mismatched ORDER BY, large result sets, and explains how to analyze execution plans and use FORCE INDEX to improve performance.

DatabaseMySQLindex
0 likes · 8 min read
Common MySQL Index Failure Scenarios and How to Diagnose Them
Programmer Xu Shu
Programmer Xu Shu
Jun 3, 2025 · Databases

Unlock MySQL InnoDB Secrets: How Row Formats Store Your Data

This article explains how MySQL InnoDB transforms a simple INSERT statement into a complex on‑disk record by detailing the COMPACT row format, record header, variable‑length field list, NULL bitmap, and overflow handling, helping developers optimize storage and performance.

Database StorageInnoDBMySQL
0 likes · 10 min read
Unlock MySQL InnoDB Secrets: How Row Formats Store Your Data
Practical DevOps Architecture
Practical DevOps Architecture
May 29, 2025 · Databases

Quick Solutions for MySQL Table Locks

This guide outlines a step‑by‑step method to diagnose and release MySQL table locks by checking open tables, inspecting running processes, querying InnoDB transaction and lock tables, and generating KILL statements to terminate blocking sessions.

Database AdministrationMySQLTroubleshooting
0 likes · 3 min read
Quick Solutions for MySQL Table Locks
Architect's Guide
Architect's Guide
May 29, 2025 · Databases

Understanding Database Indexes: How Indexes Accelerate Queries

This article explains the evolution of data storage, the fundamentals of computer storage devices, and how database indexes—especially clustered and non‑clustered indexes—leverage binary search to dramatically speed up query performance while outlining their drawbacks and common SQL optimization techniques.

DatabaseOptimizationindex
0 likes · 13 min read
Understanding Database Indexes: How Indexes Accelerate Queries
Instant Consumer Technology Team
Instant Consumer Technology Team
May 27, 2025 · Artificial Intelligence

How to Build a Text‑to‑SQL Assistant: From Prompt Tricks to Enterprise‑Ready Solutions

This comprehensive guide explains the Text2SQL concept, showcases real‑world scenarios, compares three implementation architectures—including a simple prompt‑based method, a LangChain‑based pipeline, and an enterprise‑grade Vanna solution—while providing practical tips, security measures, and advanced enhancements for deploying robust natural‑language‑to‑SQL systems.

DatabaseLLMText2SQL
0 likes · 26 min read
How to Build a Text‑to‑SQL Assistant: From Prompt Tricks to Enterprise‑Ready Solutions
Lin is Dream
Lin is Dream
May 25, 2025 · Databases

Master MySQL Row-to-Column Pivot: From Basics to Advanced Aggregations

This article walks through using MySQL to pivot rows into columns, covering storage concepts, practical CASE‑WHEN aggregation techniques, and detailed SQL examples for sum, count, average and max calculations, while also discussing performance considerations for medium‑scale and large‑scale data workloads.

Data WarehouseMySQLOLAP
0 likes · 7 min read
Master MySQL Row-to-Column Pivot: From Basics to Advanced Aggregations
ITPUB
ITPUB
May 23, 2025 · Databases

Why Storing 2 Billion Phone Numbers Requires VARCHAR(20) Over INT/BIGINT

When designing a database for billions of phone numbers, using INT or BIGINT leads to overflow, data‑integrity loss, and inefficient queries, while VARCHAR(20) preserves formatting, supports international extensions, simplifies validation, and avoids common development pitfalls.

Database Designdata integrityphone number storage
0 likes · 10 min read
Why Storing 2 Billion Phone Numbers Requires VARCHAR(20) Over INT/BIGINT
Sohu Tech Products
Sohu Tech Products
May 21, 2025 · Databases

How to Quickly Diagnose MySQL InnoDB Deadlocks in 3 Simple Steps

This guide walks you through locating MySQL deadlock logs, analyzing their contents to pinpoint transaction timing, order, and lock details, and identifying the root cause of the deadlock, including special locking scenarios that can trigger deadlocks.

InnoDBMySQLdatabase troubleshooting
0 likes · 16 min read
How to Quickly Diagnose MySQL InnoDB Deadlocks in 3 Simple Steps
Architect
Architect
May 17, 2025 · Databases

Storing 2 Billion Phone Numbers: Why VARCHAR(20) Is Preferable to INT/BIGINT

The article explains why using a VARCHAR(20) column to store billions of phone numbers is safer and more flexible than INT or BIGINT, covering range limits, data integrity, query convenience, interview expectations, and common pitfalls such as insufficient field length, charset issues, missing indexes, and lack of encryption.

BIGINTdata integrityphone number storage
0 likes · 10 min read
Storing 2 Billion Phone Numbers: Why VARCHAR(20) Is Preferable to INT/BIGINT
MaGe Linux Operations
MaGe Linux Operations
May 17, 2025 · Databases

Master MySQL: Full Guide to Theory, Commands & Real-World Practices

This comprehensive MySQL tutorial covers everything from core concepts and architecture to practical CRUD operations, advanced queries, indexing, transaction control, stored procedures, triggers, replication, performance tuning, backup strategies, and real-world use cases, providing a complete roadmap for developers and DBAs.

DatabaseMySQLStored Procedures
0 likes · 25 min read
Master MySQL: Full Guide to Theory, Commands & Real-World Practices
Sohu Tech Products
Sohu Tech Products
May 14, 2025 · Databases

How to Quickly Diagnose MySQL InnoDB Deadlocks in 3 Simple Steps

This guide walks you through locating the deadlock log, analyzing its contents to determine the time, order, and involved SQL statements, and pinpointing the root cause of MySQL InnoDB deadlocks, including special locking scenarios and how to interpret lock structures.

InnoDBLock AnalysisMySQL
0 likes · 16 min read
How to Quickly Diagnose MySQL InnoDB Deadlocks in 3 Simple Steps
360 Zhihui Cloud Developer
360 Zhihui Cloud Developer
May 14, 2025 · Artificial Intelligence

How AI Powers an Intelligent SQL Assistant for Query Optimization

This article details the design and implementation of an AI‑driven Intelligent SQL Assistant that automates query parsing, index recommendation, execution‑plan visualization, and supports SQL generation, diagnosis, and explanation across multiple dialects, while outlining its layered architecture, core modules, code examples, and future enhancements.

AIdiagnosticsprompt engineering
0 likes · 14 min read
How AI Powers an Intelligent SQL Assistant for Query Optimization
StarRocks
StarRocks
May 13, 2025 · Artificial Intelligence

How StarRocks MCP Server Enables LLMs to Query Databases Without Custom Plugins

StarRocks MCP Server provides a universal adapter that lets large language models like Claude, OpenAI, and Gemini execute SQL queries directly against StarRocks, simplifying data Q&A, intelligent analysis, and automated reporting by eliminating the need for bespoke plugins or complex prompt engineering.

AI agentsLLMMCP
0 likes · 14 min read
How StarRocks MCP Server Enables LLMs to Query Databases Without Custom Plugins
Code Ape Tech Column
Code Ape Tech Column
May 13, 2025 · Backend Development

Elegant Multi‑Tenant Data Isolation with MyBatis‑Plus in SaaS Applications

This article explains the concept of SaaS multi‑tenant architecture, compares three data‑isolation designs, and demonstrates how to implement elegant tenant‑level data isolation in Java using MyBatis‑Plus’s tenant plugin, complete with configuration, handler code, SQL examples, and troubleshooting tips.

BackendData IsolationJava
0 likes · 15 min read
Elegant Multi‑Tenant Data Isolation with MyBatis‑Plus in SaaS Applications
Architecture Digest
Architecture Digest
May 11, 2025 · Backend Development

Integrating Dataway with Spring Boot for Zero‑Code API Configuration

This tutorial walks through adding Dataway to a Spring Boot project, covering Maven dependencies, configuration properties, required database tables, data‑source setup, Hasor module integration, enabling Hasor, launching the application, and creating and testing APIs using both SQL and DataQL without writing any service code.

API ConfigurationDataQLDataway
0 likes · 14 min read
Integrating Dataway with Spring Boot for Zero‑Code API Configuration
Java Tech Enthusiast
Java Tech Enthusiast
May 10, 2025 · Databases

Efficient Strategies for Deleting Massive Data from Large Database Tables

The article outlines why deleting tens of millions of rows in one statement harms performance and reliability, then presents safe, efficient tactics—such as indexed batch deletes, partition drops, creating a new table, or using TRUNCATE—plus pre‑deletion planning, post‑delete validation, monitoring, and space reclamation.

DatabasePartitioningbackup
0 likes · 11 min read
Efficient Strategies for Deleting Massive Data from Large Database Tables
Spring Full-Stack Practical Cases
Spring Full-Stack Practical Cases
May 10, 2025 · Databases

10 Powerful SQL Optimization Techniques to Boost Query Performance

This article presents ten practical SQL optimization techniques—including replacing DISTINCT with GROUP BY, using UNION ALL instead of OR, avoiding functions on indexed columns, leveraging EXISTS over IN, creating covering indexes, partitioning large tables, and more—each illustrated with before-and-after code examples to dramatically improve query speed and reduce server load.

MySQLPerformance OptimizationQuery Tuning
0 likes · 10 min read
10 Powerful SQL Optimization Techniques to Boost Query Performance
Architect
Architect
May 9, 2025 · Databases

How We Reduced Thousands of Slow SQL Queries to Double‑Digit Levels

This article details a real‑world case study of the activity middle‑platform system’s slow‑SQL problem, explaining the definition, causes, and harmful impacts of slow queries, then outlines step‑by‑step mitigation strategies—including data cleanup, partitioning, indexing, query refactoring, and scheduling—to dramatically reduce slow‑SQL occurrences from thousands to double‑digit counts.

DatabaseOptimizationindexing
0 likes · 17 min read
How We Reduced Thousands of Slow SQL Queries to Double‑Digit Levels
php Courses
php Courses
May 8, 2025 · Backend Development

Using mysqli_fetch_assoc to Retrieve Query Results in PHP

This tutorial demonstrates how to connect to a MySQL database in PHP using mysqli_connect, execute queries with mysqli_query, and retrieve each row as an associative array using mysqli_fetch_assoc, providing complete code examples and a full script for efficient backend data handling.

DatabaseMySQLMySQLi
0 likes · 4 min read
Using mysqli_fetch_assoc to Retrieve Query Results in PHP
Selected Java Interview Questions
Selected Java Interview Questions
May 7, 2025 · Backend Development

Easy-Data-Scope: A Simple Data‑Permission Library for MyBatis and Spring Boot

This article introduces easy-data-scope, a lightweight Java library that enables dynamic SQL‑based data permission control for MyBatis, MyBatis‑Plus, and MyBatis‑Flex, showing how to set up the project, configure dependencies, define annotations, and apply various permission scenarios with code examples.

Data PermissionMyBatisSpring Boot
0 likes · 9 min read
Easy-Data-Scope: A Simple Data‑Permission Library for MyBatis and Spring Boot
Aikesheng Open Source Community
Aikesheng Open Source Community
May 7, 2025 · Databases

Differences in Manual Statistics Collection for OceanBase: DBMS_STATS vs ANALYZE Across Versions

This article explains the differences between manual statistics collection methods in OceanBase 3.x and 4.x, compares DBMS_STATS and ANALYZE commands across MySQL and Oracle modes, provides version‑specific tables, detailed code examples for table, partition, and schema level collection, and shows how to verify statistics.

ANALYZEDBMS_STATSOceanBase
0 likes · 9 min read
Differences in Manual Statistics Collection for OceanBase: DBMS_STATS vs ANALYZE Across Versions
IT Services Circle
IT Services Circle
May 6, 2025 · Databases

Efficient Strategies for Deleting Massive Data from Large Tables

This article explains the risks of bulk deletions on million‑row tables and provides a step‑by‑step guide—including pre‑deletion planning, indexing, backup, batch deletion, partitioning, table recreation, TRUNCATE, and post‑deletion verification—to safely and quickly remove large volumes of data while minimizing lock contention, log growth, CPU spikes, replication lag, and rollback complications.

Batch DeleteDatabasesPartitioning
0 likes · 11 min read
Efficient Strategies for Deleting Massive Data from Large Tables
Full-Stack Internet Architecture
Full-Stack Internet Architecture
May 2, 2025 · Databases

Demonstrating MySQL Deadlock with a Practical Example

This article explains MySQL deadlocks by creating a test table, running two concurrent transactions—one using SLEEP to hold a lock and another attempting the same resource—to reproduce a deadlock error, and discusses how this approach aids debugging and understanding of transaction conflicts.

DatabaseMySQLdeadlock
0 likes · 4 min read
Demonstrating MySQL Deadlock with a Practical Example
Java Backend Full-Stack
Java Backend Full-Stack
May 1, 2025 · Databases

Common Interview Question: When Does a MySQL Index Fail? Hands‑On Demo

This article walks through a mini‑project that creates a student table, adds indexes, populates it with 100 k rows, and then demonstrates six concrete scenarios—such as leading wildcards, arithmetic on indexed columns, functions, type mismatches, composite‑index misuse, and encoding differences—that cause MySQL indexes to become ineffective, showing the EXPLAIN output for each case.

Database PerformanceEXPLAINMySQL
0 likes · 8 min read
Common Interview Question: When Does a MySQL Index Fail? Hands‑On Demo
Full-Stack Internet Architecture
Full-Stack Internet Architecture
May 1, 2025 · Databases

Common Scenarios Where MySQL Indexes Fail

This article explains various situations that cause MySQL indexes to become ineffective—such as leading wildcard LIKE queries, calculations on indexed columns, use of functions, data type mismatches, improper use of composite indexes, and character set differences—providing example SQL, execution plans, and practical testing steps.

Database OptimizationMySQLPerformance tuning
0 likes · 7 min read
Common Scenarios Where MySQL Indexes Fail
Java Tech Enthusiast
Java Tech Enthusiast
Apr 30, 2025 · Databases

Storing 2 Billion Phone Numbers: Int vs String, Schema Design and Pitfalls

When designing a schema for two‑billion phone numbers, use a VARCHAR(20) column with utf8mb4 Unicode, a unique index, and proper validation/encryption rather than a 32‑bit INT, because strings preserve leading zeros, international prefixes, extensions, and support business extensibility, fault tolerance, and future changes.

BIGINTDatabase DesignInterview
1 likes · 7 min read
Storing 2 Billion Phone Numbers: Int vs String, Schema Design and Pitfalls
DeWu Technology
DeWu Technology
Apr 28, 2025 · Databases

GreptimeDB Distributed Architecture, Transparent Caching, and Flow‑Based Real‑Time Analytics

GreptimeDB solves front‑end observability challenges with a distributed architecture (frontend, datanode, flownode, metasrv), transparent two‑level caching, elastic scaling, and an SQL‑based flow engine for real‑time multi‑granularity aggregation and approximate counting, delivering millisecond query latency and cost‑effective storage.

GreptimeDBHyperLogLogReal-time Analytics
0 likes · 12 min read
GreptimeDB Distributed Architecture, Transparent Caching, and Flow‑Based Real‑Time Analytics
php Courses
php Courses
Apr 28, 2025 · Databases

Python Database Programming: SQLite and MySQL Basics

This tutorial explains how to use Python's sqlite3 module and MySQL connectors to perform essential database operations such as connecting, creating tables, inserting, querying, updating, deleting records, and managing transactions for both SQLite and MySQL.

MySQLSQLitesql
0 likes · 7 min read
Python Database Programming: SQLite and MySQL Basics
Big Data Tech Team
Big Data Tech Team
Apr 27, 2025 · Big Data

10 Advanced Hive SQL Use Cases: Windows, Skew, JSON, and More

This article presents ten practical Hive SQL scenarios—including window functions for ranking, LAG for time‑interval analysis, random‑salt techniques to mitigate data skew, dynamic partition writes, JSON parsing with UDFs, retention calculations, consecutive‑login detection, regex‑based path analysis, CUBE multi‑dimensional aggregation, and ORC storage optimizations—each accompanied by optimization tips and complete code examples.

Data WarehouseHivePerformance Optimization
0 likes · 9 min read
10 Advanced Hive SQL Use Cases: Windows, Skew, JSON, and More
Code Ape Tech Column
Code Ape Tech Column
Apr 27, 2025 · Backend Development

Using easy-data-scope for Dynamic SQL Data Permissions in Spring Boot

This guide demonstrates how to integrate the easy-data-scope library into a Spring Boot project to implement dynamic, annotation‑driven SQL data permissions with MyBatis, covering project setup, dependency configuration, core interfaces, annotation options, and practical query examples.

BackendData PermissionJava
0 likes · 7 min read
Using easy-data-scope for Dynamic SQL Data Permissions in Spring Boot
Senior Tony
Senior Tony
Apr 24, 2025 · Databases

How to Effectively Monitor and Optimize Slow SQL in Real Projects

The article explains a systematic interview‑ready approach to handling slow SQL: collect queries via Druid, MySQL slow‑query log or cloud exporters, prioritize by total execution time, analyze EXPLAIN output (type, key, rows, filtered, extra), and apply index, FORCE INDEX, join‑order, or off‑loading techniques for optimization.

IndexesMySQLOptimization
0 likes · 9 min read
How to Effectively Monitor and Optimize Slow SQL in Real Projects
IT Xianyu
IT Xianyu
Apr 24, 2025 · Databases

PostgreSQL DBA Guide: Permission Minimization, Log Analysis with pgBadger, and Security Hardening

This tutorial explains why DBAs need security hardening and log analysis, shows how to configure minimal‑privilege roles and precise permissions in PostgreSQL, demonstrates how to detect and revoke redundant privileges, and provides a step‑by‑step guide to installing and using pgBadger for log analysis and automated reporting.

DBAPermission managementPostgreSQL
0 likes · 8 min read
PostgreSQL DBA Guide: Permission Minimization, Log Analysis with pgBadger, and Security Hardening
ITPUB
ITPUB
Apr 19, 2025 · Databases

Can SQL Run Tetris? Exploring a Recursive CTE Tetris Implementation

This article showcases a spectacular PostgreSQL query that implements the classic Tetris game using recursive CTEs, provides the full source code, highlights a known long‑run disk‑usage issue, and then presents several other impressive SQL snippets and a concise checklist for writing high‑quality SQL.

Database OptimizationPostgreSQLSQL Best Practices
0 likes · 25 min read
Can SQL Run Tetris? Exploring a Recursive CTE Tetris Implementation
IT Xianyu
IT Xianyu
Apr 18, 2025 · Databases

Comprehensive Guide to SQL Basics, Advanced Queries, and Performance Optimization

This article provides a thorough tutorial on SQL fundamentals, including statement order, core clause rules, templates for SELECT/INSERT/UPDATE/DELETE, practical multi‑table query cases, join and subquery techniques, common pitfalls, index optimization strategies, experimental performance data, and a structured learning path for mastering database development.

JoinsPerformance tuningSubqueries
0 likes · 7 min read
Comprehensive Guide to SQL Basics, Advanced Queries, and Performance Optimization
Aikesheng Open Source Community
Aikesheng Open Source Community
Apr 16, 2025 · Databases

Troubleshooting MySQL Transaction Lock Waits: Diagnosis and Resolution

This article explains how to reproduce a MySQL InnoDB lock‑wait scenario, use system tables such as information_schema.processlist, innodb_trx, sys.innodb_lock_waits and performance_schema to locate the blocking transaction, and finally resolve the issue by killing the offending session, while also providing quick‑check queries and parameter tuning advice.

InnoDBLock WaitMySQL
0 likes · 9 min read
Troubleshooting MySQL Transaction Lock Waits: Diagnosis and Resolution
Aikesheng Open Source Community
Aikesheng Open Source Community
Apr 15, 2025 · Databases

Understanding Full-Link Tracing in OceanBase: Concepts, Mechanisms, and Usage

This article explains OceanBase's full‑link tracing feature, covering its definition, internal working principle, trace‑log structure, span and tag details, configuration steps, and how to view trace data via the show‑trace command or the OCP visual interface, helping DBAs quickly diagnose performance issues.

Database PerformanceFull‑Link TracingOCP
0 likes · 16 min read
Understanding Full-Link Tracing in OceanBase: Concepts, Mechanisms, and Usage
IT Xianyu
IT Xianyu
Apr 15, 2025 · Databases

What Does a DBA Do? A Beginner’s Guide to Database Administration, Core Skills, and Career Path

This article explains the role of a DBA using a library analogy, outlines essential database fundamentals, Linux commands, hardware choices, common pitfalls, cloud‑era advantages, intelligent operations, and provides a detailed career roadmap with salary insights for aspiring database administrators.

Cloud DatabasesDatabase AdministrationLinux commands
0 likes · 6 min read
What Does a DBA Do? A Beginner’s Guide to Database Administration, Core Skills, and Career Path
Java Tech Enthusiast
Java Tech Enthusiast
Apr 14, 2025 · Databases

SQL Optimization Steps and Common Scenarios

To improve MySQL performance, first identify slow queries via logs, then examine their EXPLAIN plans and profiling data, understand optimizer traces, and apply fixes such as proper left‑most indexing, avoiding implicit conversions, large offsets, unsuitable IN/ORDER BY patterns, range‑blocking, NOT‑IN predicates, and consider alternative storage or pagination strategies for complex or massive datasets.

MySQLindexingperformance
0 likes · 10 min read
SQL Optimization Steps and Common Scenarios
macrozheng
macrozheng
Apr 11, 2025 · Databases

Why MySQL count() Slows Down on Large Tables and How to Speed It Up

This article explains how MySQL's count() works across storage engines, why InnoDB scans rows and can time out on massive tables, and presents practical alternatives such as using EXPLAIN rows, a dedicated count table, batch processing, or binlog‑to‑Hive for efficient row‑count estimation.

COUNTInnoDBMyISAM
0 likes · 14 min read
Why MySQL count() Slows Down on Large Tables and How to Speed It Up
Selected Java Interview Questions
Selected Java Interview Questions
Apr 10, 2025 · Backend Development

Understanding PageHelper Issues and ThreadLocal Pitfalls in MyBatis

This article analyzes unexpected behaviors caused by PageHelper in a Java backend project, such as duplicate user registration, limited query results, and password‑reset errors, and explains how ThreadLocal pagination parameters, startPage(), and cleanup mechanisms lead to these problems while offering practical debugging tips.

BackendMyBatisThreadLocal
0 likes · 11 min read
Understanding PageHelper Issues and ThreadLocal Pitfalls in MyBatis
Code Ape Tech Column
Code Ape Tech Column
Apr 10, 2025 · Databases

Comprehensive Guide to SQL Optimization Steps and Common Scenarios

This article explains why SQL statements become performance bottlenecks as data grows, outlines a systematic optimization workflow—including slow‑query identification, EXPLAIN analysis, profiling, and tracing—and discusses practical solutions for index usage, query rewriting, pagination, range queries, and large‑scale data handling in MySQL.

Database OptimizationEXPLAINIndexes
0 likes · 12 min read
Comprehensive Guide to SQL Optimization Steps and Common Scenarios
Sohu Tech Products
Sohu Tech Products
Apr 9, 2025 · Databases

Six Critical MySQL Index Pitfalls and How to Fix Them

This article analyzes six common MySQL query performance traps—type conversion, function usage, left‑most prefix, implicit charset conversion, left‑most match, and optimizer mis‑selection—illustrates each with real‑world SQL examples, explains why they degrade performance, and provides concrete remediation steps and verification tools.

DatabaseMySQLTroubleshooting
0 likes · 5 min read
Six Critical MySQL Index Pitfalls and How to Fix Them
Java Architect Essentials
Java Architect Essentials
Apr 7, 2025 · Backend Development

Advanced MyBatis Dynamic SQL Techniques: foreach, if, choose, trim, selectKey, and SQL Fragments

This article provides a comprehensive guide to MyBatis dynamic SQL tags—including foreach, if, choose, trim, selectKey, and reusable SQL fragments—explaining their attributes, usage patterns, and code examples to help developers write cleaner, more reliable XML mappers and avoid common pitfalls.

Backend DevelopmentDynamic SQLJava
0 likes · 19 min read
Advanced MyBatis Dynamic SQL Techniques: foreach, if, choose, trim, selectKey, and SQL Fragments
IT Services Circle
IT Services Circle
Apr 3, 2025 · Databases

Six Common MySQL Index Pitfalls and Their Remedies

This article examines six common MySQL indexing pitfalls—type mismatches, function usage, left‑prefix violations, implicit charset conversions, range query issues, and optimizer mis‑choices—and provides concrete SQL fixes and verification tools to improve query performance.

DatabaseIndex OptimizationMySQL
0 likes · 5 min read
Six Common MySQL Index Pitfalls and Their Remedies
Aikesheng Open Source Community
Aikesheng Open Source Community
Apr 1, 2025 · Databases

Resolving Column Length Expansion Errors in OceanBase: Charset and Collation Considerations

This article explains why altering a column length in OceanBase may trigger an "Alter charset or collation type not supported" error, analyzes the underlying charset and collation settings, and provides a solution that explicitly specifies charset and collation to ensure successful column expansion across versions.

CharsetColumn ExpansionDatabase
0 likes · 6 min read
Resolving Column Length Expansion Errors in OceanBase: Charset and Collation Considerations
IT Architects Alliance
IT Architects Alliance
Mar 29, 2025 · Information Security

Database Data Masking Techniques: SQL, Java, and MyBatis-Mate Sensitive-Jackson Comparison

The article explains why data masking is essential for protecting sensitive information, then details three implementation methods—SQL, Java (with open‑source plugins), and the MyBatis‑Mate‑Sensitive‑Jackson ORM extension—comparing their principles, code examples, advantages, limitations, performance, suitable scenarios, and cost considerations.

DatabaseInformation SecurityJava
0 likes · 17 min read
Database Data Masking Techniques: SQL, Java, and MyBatis-Mate Sensitive-Jackson Comparison
Cognitive Technology Team
Cognitive Technology Team
Mar 28, 2025 · Databases

Index Condition Pushdown (ICP) Optimization in MySQL

Index Condition Pushdown (ICP) is a MySQL query‑optimization technique that pushes eligible WHERE predicates to the storage engine so that index entries can filter rows early, reducing row fetches and server‑engine communication.

DatabasesMySQLindex condition pushdown
0 likes · 5 min read
Index Condition Pushdown (ICP) Optimization in MySQL
Liangxu Linux
Liangxu Linux
Mar 27, 2025 · Databases

How Chat2DB Uses AI to Simplify Database Management and SQL Generation

Chat2DB is an open‑source AI‑enhanced database client that turns natural language into SQL, auto‑generates table schemas and test data, offers a smart editor, visual chart creation, Excel analysis, and supports multi‑platform installation for dozens of databases.

AIChat2DBDatabase Management
0 likes · 7 min read
How Chat2DB Uses AI to Simplify Database Management and SQL Generation
Alibaba Cloud Big Data AI Platform
Alibaba Cloud Big Data AI Platform
Mar 26, 2025 · Databases

Master Hologres: End-to-End SQL Diagnosis & Optimization for Stable Cloud Data

This guide walks through a five-stage approach to Hologres performance—pre-emptive real-time monitoring, active SQL log analysis for long queries, post-mortem slow-query diagnostics, long-term SQL and meta governance, and cost-focused table/index reviews—helping teams boost instance stability and efficiency.

Cost ManagementHologresOptimization
0 likes · 14 min read
Master Hologres: End-to-End SQL Diagnosis & Optimization for Stable Cloud Data
JD Tech
JD Tech
Mar 24, 2025 · Backend Development

SQL Coloring Plugin for MyBatis: Design, Implementation, and Usage Guide

This article describes a lightweight, non‑intrusive MyBatis plugin that adds identifiable coloring comments to SQL statements—embedding statementId, pFinderId, and optional custom data—to simplify SQL source tracing, improve slow‑SQL analysis, and support SELECT, INSERT, UPDATE, DELETE operations with minimal performance overhead.

BackendJavaMyBatis
0 likes · 12 min read
SQL Coloring Plugin for MyBatis: Design, Implementation, and Usage Guide
IT Xianyu
IT Xianyu
Mar 24, 2025 · Databases

Comparison of Oracle, PostgreSQL, and MySQL: Features, Installation, and Basic Operations

This article compares Oracle, PostgreSQL, and MySQL across core features, typical use cases, transaction support, storage engines, licensing, provides simplified installation steps, demonstrates basic SQL operations such as creating tables, inserting and querying data, and highlights key differences like auto‑increment handling and string‑matching functions.

InstallationMySQLOracle
0 likes · 7 min read
Comparison of Oracle, PostgreSQL, and MySQL: Features, Installation, and Basic Operations
ITPUB
ITPUB
Mar 21, 2025 · Databases

What New SQL Features Did SQLite Add Between Versions 3.22 and 3.26?

This article reviews the SQL enhancements introduced in SQLite from version 3.22.0 through 3.26.0, covering boolean literals, window functions, the FILTER clause, upsert syntax, and column‑renaming support, while comparing SQLite's capabilities to other major database engines.

Boolean LiteralsDatabase FeaturesFILTER clause
0 likes · 11 min read
What New SQL Features Did SQLite Add Between Versions 3.22 and 3.26?
Alibaba Cloud Big Data AI Platform
Alibaba Cloud Big Data AI Platform
Mar 20, 2025 · Databases

Unlock Real‑Time Analytics with Hologres Dynamic Table: A Quick‑Start Guide

This article introduces Hologres Dynamic Table, explains its typical real‑time data‑warehouse scenarios, outlines the underlying architecture and its challenges, details the incremental and full‑refresh modes, provides usage steps, best‑practice recommendations, demo scenarios, and compares it with competing solutions.

Dynamic TableHologresIncremental Refresh
0 likes · 17 min read
Unlock Real‑Time Analytics with Hologres Dynamic Table: A Quick‑Start Guide
php Courses
php Courses
Mar 17, 2025 · Backend Development

Using PHP mysqli_query to Execute MySQL Queries

This article explains how to use PHP's mysqli_query function to perform MySQL operations such as SELECT, INSERT, UPDATE, and DELETE, providing a step‑by‑step example that creates a database connection, executes a SELECT query, processes results, and closes the connection.

MySQLMySQLisql
0 likes · 5 min read
Using PHP mysqli_query to Execute MySQL Queries
Mike Chen's Internet Architecture
Mike Chen's Internet Architecture
Mar 12, 2025 · Databases

Comprehensive MySQL Core Commands Tutorial

This article provides a step‑by‑step guide to essential MySQL operations, covering connection methods, database creation and deletion, user management, password changes, data manipulation, query techniques, indexing strategies, performance tips, and backup procedures, all illustrated with complete command examples.

DatabaseMySQLbackup
0 likes · 7 min read
Comprehensive MySQL Core Commands Tutorial
Ma Wei Says
Ma Wei Says
Mar 11, 2025 · Big Data

Mastering DWS Layer Design: Principles, Steps, and Best Practices

This article explains the role of the DWS layer in data warehouses, outlines design principles, step‑by‑step modeling, naming conventions, field design, provides concrete DDL/ETL examples, common pitfalls, and how to build reusable, performant summary tables for analytics.

Big DataDWS LayerData Warehouse
0 likes · 15 min read
Mastering DWS Layer Design: Principles, Steps, and Best Practices
Selected Java Interview Questions
Selected Java Interview Questions
Mar 9, 2025 · Backend Development

Introduction to Manticore Search: Features, Performance, and Usage

Manticore Search is a high‑performance, open‑source C++ search engine that builds on Sphinx, offering real‑time indexing, SQL support, distributed search, and significant speed advantages over Elasticsearch, with simple installation via Linux packages or Docker and extensive plugin ecosystems for various applications.

Backend DevelopmentDockerFull-Text Search
0 likes · 6 min read
Introduction to Manticore Search: Features, Performance, and Usage
Raymond Ops
Raymond Ops
Mar 7, 2025 · Databases

Master MySQL Backups: Commands for Single, Multiple, and All Databases

This guide explains how to use mysqldump to back up a single MySQL database, multiple databases, or all databases, includes options for specific tables, compression with gzip, adding drop statements, exporting only schema, and provides restore procedures and a sample automated backup script.

Database BackupMySQLmysqldump
0 likes · 11 min read
Master MySQL Backups: Commands for Single, Multiple, and All Databases
Aikesheng Open Source Community
Aikesheng Open Source Community
Mar 6, 2025 · Databases

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

SQLE 4.2502.0 has been officially released, introducing SQL compliance rewriting, a performance tracker, a syntax rule knowledge graph, new community and enterprise features, detailed upgrade instructions, and comprehensive version logs highlighting enhancements, bug fixes, and support for multiple database platforms.

ComplianceDatabase GovernancePerformance Tracking
0 likes · 12 min read
SQLE 4.2502.0 Release: New Features, Upgrade Guide, and Version Log
Architect's Guide
Architect's Guide
Mar 6, 2025 · Databases

Common Practices for Database Sharding and Pagination Optimization

This article explains typical sharding strategies—hash, range, and middle‑table—describes SDK, Proxy, and Sidecar middleware forms, and presents several pagination optimization techniques such as global query rewriting, average pagination, disabling cross‑page queries, secondary queries, and using intermediate tables to improve performance in distributed databases.

Databasepaginationsql
0 likes · 17 min read
Common Practices for Database Sharding and Pagination Optimization
Su San Talks Tech
Su San Talks Tech
Mar 4, 2025 · Databases

Master DBeaver: Free Open-Source Database Management Tool Tutorial

This guide introduces the free, open‑source DBeaver tool, explains how to download and install it, demonstrates configuring themes, creating data sources, managing tables, executing SQL, and highlights its support for many databases while noting limitations of the community edition.

DBeaverDatabase ManagementTutorial
0 likes · 7 min read
Master DBeaver: Free Open-Source Database Management Tool Tutorial
Big Data Tech Team
Big Data Tech Team
Feb 27, 2025 · Databases

Master Essential SQL Techniques for Data Analyst Interviews

This article presents a comprehensive guide to essential SQL skills for data‑analysis positions, covering join operations, difference detection, duplicate removal, missing‑value handling, multi‑condition and fuzzy filtering, aggregation, conditional calculations, trimming, cost computation, and includes a collection of practical interview questions with sample queries.

Database QueriesSQL Basicssql
0 likes · 10 min read
Master Essential SQL Techniques for Data Analyst Interviews
macrozheng
macrozheng
Feb 26, 2025 · Databases

Boost Your SQL Workflow with Chat2DB’s AI‑Powered Database Management

This article introduces Chat2DB, an AI‑enhanced SQL client and reporting tool, walks through its key features, Docker‑based installation, practical usage with a SpringBoot‑Vue e‑commerce project, and demonstrates how its built‑in AI can generate SQL queries automatically.

AIChat2DBDatabase Management
0 likes · 4 min read
Boost Your SQL Workflow with Chat2DB’s AI‑Powered Database Management
Aikesheng Open Source Community
Aikesheng Open Source Community
Feb 25, 2025 · Databases

Understanding CPU Allocation Logic in OceanBase 4.x and How to Modify the cpu_count Configuration

This article explains the background of tenant creation failures caused by insufficient CPU resources in OceanBase, details the calculation of usable CPU in version 4.x, shows how to query CPU usage with SQL, describes related configuration parameters, and provides step‑by‑step procedures for modifying cpu_count and testing over‑commit scenarios across different OceanBase versions.

CPUOceanBaseconfiguration
0 likes · 12 min read
Understanding CPU Allocation Logic in OceanBase 4.x and How to Modify the cpu_count Configuration
Python Programming Learning Circle
Python Programming Learning Circle
Feb 20, 2025 · Databases

Python Database Interaction: Common Patterns and a Practical User Registration Example

This article introduces ten common Python database interaction patterns—from basic CRUD operations and table creation to advanced transaction handling, batch inserts, and stored procedures—culminating in a complete user‑registration system example that demonstrates how to combine these techniques effectively.

CRUDDatabasePostgreSQL
0 likes · 10 min read
Python Database Interaction: Common Patterns and a Practical User Registration Example
Aikesheng Open Source Community
Aikesheng Open Source Community
Feb 18, 2025 · Databases

Parsing Delete Undo Log in MySQL 8.0.32 InnoDB

This article explains how to read and parse the Undo log generated by a DELETE operation in MySQL 8.0.32 InnoDB, covering preparation, log extraction, detailed field parsing, locating the primary index record, and the step‑by‑step rollback of secondary and primary index records.

Database InternalsInnoDBMySQL
0 likes · 10 min read
Parsing Delete Undo Log in MySQL 8.0.32 InnoDB
Ma Wei Says
Ma Wei Says
Feb 14, 2025 · Databases

Master MySQL Regex: All REGEXP Functions Explained

This guide explains MySQL's regular‑expression capabilities—including REGEXP, NOT REGEXP, REGEXP_LIKE, REGEXP_REPLACE, REGEXP_SUBSTR, REGEXP_INSTR and their RLIKE equivalents—covering syntax, multibyte safety, match‑type flags, and practical usage examples.

MySQLRegExpregex
0 likes · 7 min read
Master MySQL Regex: All REGEXP Functions Explained
IT Services Circle
IT Services Circle
Feb 13, 2025 · Databases

Resolving ORA-000060 Deadlock in Oracle Batch Updates with MyBatis

The article describes a production deadlock (ORA-000060) caused by unsorted, duplicate user_id rows in a file processed in parallel batch updates, shows MyBatis XML code, illustrates conflicting thread execution, and provides practical solutions such as sorting the input and deduplicating records.

Batch UpdateDatabaseMyBatis
0 likes · 4 min read
Resolving ORA-000060 Deadlock in Oracle Batch Updates with MyBatis
Code Ape Tech Column
Code Ape Tech Column
Feb 13, 2025 · Databases

Using SQL‑92 Row‑by‑Row Comparison in MySQL to Query Multi‑Agency Product Sales

The article explains how to design a MySQL table for product sales statistics and compares several query strategies—including loop queries, OR concatenation, mixed filtering, and finally SQL‑92 row‑by‑row comparison—to efficiently retrieve sales data for multiple business units and their dynamic product lists while respecting development constraints.

Database DesignMySQLRow Comparison
0 likes · 7 min read
Using SQL‑92 Row‑by‑Row Comparison in MySQL to Query Multi‑Agency Product Sales