BestHub
Sign in
Tagged articles
2769 articles
Page 3 of 28
Aikesheng Open Source Community
Aikesheng Open Source Community
Sep 16, 2025 · Databases

Why Oracle VARCHAR2 Fails at 4000 Bytes and How to Fix It

This article analyzes a real‑world OceanBase‑to‑Oracle incremental sync failure caused by VARCHAR2 length limits, explains the role of NLS_LENGTH_SEMANTICS and MAX_STRING_SIZE, and provides three practical solutions—including extending string size, using CLOB fields, and PL/SQL workarounds—to reliably insert data exceeding 4000 bytes.

DatabaseSyncLengthSemanticsOracle
0 likes · 11 min read
Why Oracle VARCHAR2 Fails at 4000 Bytes and How to Fix It
Senior Brother's Insights
Senior Brother's Insights
Sep 11, 2025 · Databases

How to Eliminate the N+1 Query Problem with JOINs in SQLite

This article explains the N+1 query performance issue, demonstrates a naïve Python/SQLite implementation that triggers N+1 queries, compares its runtime, and then shows how using SQL JOINs, GROUP BY, and nested data structures can dramatically improve query efficiency and reduce latency.

JOINN+1 QuerySQLite
0 likes · 9 min read
How to Eliminate the N+1 Query Problem with JOINs in SQLite
Raymond Ops
Raymond Ops
Sep 11, 2025 · Databases

Master MySQL: Installation Guide Across Linux Distros & Key Features

This comprehensive guide introduces MySQL’s core concepts, architecture, and features, then walks you through step‑by‑step installation and configuration on popular Linux distributions—including Rocky, AlmaLinux, CentOS, Ubuntu, Debian, and openSUSE—covering network setup, repository configuration, and post‑install security tweaks.

InstallationLinuxdatabase
0 likes · 69 min read
Master MySQL: Installation Guide Across Linux Distros & Key Features
macrozheng
macrozheng
Sep 11, 2025 · Databases

Why IN/NOT IN Can Kill Your SQL Performance and How to Fix It

This article explains why using IN and NOT IN in SQL queries often leads to poor performance and incorrect results, demonstrates common pitfalls with real examples, and shows safer alternatives such as EXISTS, NOT EXISTS, and JOIN to write efficient and reliable database queries.

Database PerformanceEXISTSIN
0 likes · 6 min read
Why IN/NOT IN Can Kill Your SQL Performance and How to Fix It
Python Programming Learning Circle
Python Programming Learning Circle
Sep 8, 2025 · Big Data

Unlocking E‑Commerce Insights: How Python & SQL Reveal User Behavior and Boost Sales

This article analyzes a JD e‑commerce dataset using Python and MySQL to calculate key metrics such as PV, UV, conversion rates, attrition, daily activity, hourly trends, user‑behavior funnels, purchase intervals, retention rates, product sales, and RFM segmentation, and then offers data‑driven recommendations to improve traffic, conversion, and user loyalty.

PythonRFMconversion funnel
0 likes · 37 min read
Unlocking E‑Commerce Insights: How Python & SQL Reveal User Behavior and Boost Sales
Raymond Ops
Raymond Ops
Sep 7, 2025 · Databases

Understanding MySQL 8 Directory Structure and Table Storage

This article explains the main directory layout of MySQL 8, the locations of data files, configuration files, system databases, and how InnoDB and MyISAM storage engines represent tables and indexes on the file system, including the use of system and file‑per‑table tablespaces.

ConfigurationDatabase DirectoryInnoDB
0 likes · 13 min read
Understanding MySQL 8 Directory Structure and Table Storage
ITPUB
ITPUB
Sep 6, 2025 · Databases

Why OFFSET Slows Your API and How Keyset Pagination Boosts Speed

The article explains how using OFFSET for pagination can cause severe performance degradation as data grows, and demonstrates how switching to keyset (seek) pagination, optionally combined with cursor encoding, index‑only OFFSET, or materialized views, dramatically reduces query latency.

Database OptimizationKeyset Paginationmysql
0 likes · 8 min read
Why OFFSET Slows Your API and How Keyset Pagination Boosts Speed
Liangxu Linux
Liangxu Linux
Sep 6, 2025 · Databases

Why PostgreSQL Is Overtaking MySQL: Survey Data and Real‑World Insights

A recent Stack Overflow survey shows PostgreSQL surpassing MySQL in popularity, and the article explains the technical advantages, real‑world performance tests, and evolving use cases that make PostgreSQL the preferred choice for many developers while still acknowledging MySQL’s enduring role for beginners.

data analysisdatabase comparisonmysql
0 likes · 5 min read
Why PostgreSQL Is Overtaking MySQL: Survey Data and Real‑World Insights
Aikesheng Open Source Community
Aikesheng Open Source Community
Sep 4, 2025 · Artificial Intelligence

How GPT‑5, DeepSeek‑V3.1 and SQLShift Stack Up in the August 2025 SQL LLM Benchmark

The August 2025 SCALE benchmark evaluates new AI models—including the GPT‑5 family, DeepSeek‑V3.1, and the SQLShift tool—across SQL understanding, optimization, and dialect conversion, revealing distinct strengths, weaknesses, and the growing advantage of specialized tools over generic large language models.

AIDeepSeekGPT-5
0 likes · 15 min read
How GPT‑5, DeepSeek‑V3.1 and SQLShift Stack Up in the August 2025 SQL LLM Benchmark
Tencent Cloud Developer
Tencent Cloud Developer
Sep 3, 2025 · Databases

Deep Dive into GORM: Architecture, Internals, and Common Pitfalls

This article provides a comprehensive overview of Go's powerful GORM ORM library, covering its core concepts, architecture, internal logic, common pitfalls, practical tips, and advanced features such as soft deletes, transaction handling, batch operations, and integration with trpc-go, helping developers master GORM's inner workings.

Batch InsertGORMGo
0 likes · 26 min read
Deep Dive into GORM: Architecture, Internals, and Common Pitfalls
Su San Talks Tech
Su San Talks Tech
Sep 3, 2025 · Databases

Why Does MySQL GROUP BY Slow Down and How to Fix It

This article explains why a MySQL GROUP BY query can degrade from seconds to minutes as data grows, shows how to locate the bottlenecks with EXPLAIN and profiling tools, and provides practical indexing, query rewriting, temporary‑table tuning, batch aggregation, and distributed‑database strategies to restore performance.

GROUP BYindexingmysql
0 likes · 13 min read
Why Does MySQL GROUP BY Slow Down and How to Fix It
Code Mala Tang
Code Mala Tang
Sep 1, 2025 · Databases

Boost SQL Query Performance: Practical Tips and Code Examples

This article presents a collection of practical techniques—such as using SELECT TOP, avoiding DISTINCT, preferring IN over OR, indexing key columns, and leveraging stored procedures—to dramatically improve SQL query speed and reduce database load.

databaseindexesquery optimization
0 likes · 10 min read
Boost SQL Query Performance: Practical Tips and Code Examples
Linux Tech Enthusiast
Linux Tech Enthusiast
Aug 28, 2025 · Databases

Can Weak Backup & Recovery Skills Cost You Your Probation?

The article explains why mastering database backup and recovery—including failure types, logical vs. physical backups, flashback, full and partial restores, a weekly backup strategy, RMAN configuration, shell scripts, and monitoring queries—is essential for avoiding costly mistakes and passing a new‑job probation.

BackupOracleRMAN
0 likes · 7 min read
Can Weak Backup & Recovery Skills Cost You Your Probation?
MaGe Linux Operations
MaGe Linux Operations
Aug 26, 2025 · Databases

How I Cut MySQL Query Time from 20 Seconds to 200 Milliseconds

In this detailed case study, the author walks through a real‑world MySQL slow‑query incident, analyzes execution plans, logs, and profiling data, and applies a four‑step optimization strategy—including index creation, query rewriting, covering indexes, and materialized views—to reduce execution time from 20 seconds to 200 milliseconds, achieving over 100× speedup.

indexingmysqlslow-query
0 likes · 23 min read
How I Cut MySQL Query Time from 20 Seconds to 200 Milliseconds
Selected Java Interview Questions
Selected Java Interview Questions
Aug 22, 2025 · Databases

How to Recover Accidentally Deleted MySQL Data Using Binlog

This guide explains how to restore mistakenly deleted MySQL rows by leveraging binary logs, covering binlog activation, mode configuration, locating relevant log files, extracting the original INSERT statements or generating reverse DELETE statements, and using open‑source tools to automate the recovery process.

BackupBinlogData Recovery
0 likes · 17 min read
How to Recover Accidentally Deleted MySQL Data Using Binlog
Big Data Tech Team
Big Data Tech Team
Aug 21, 2025 · Big Data

Crack ByteDance Data Warehouse Engineer Interviews: 30+ Essential Questions

This article compiles the complete set of interview questions used in ByteDance's data warehouse engineer hiring process, covering three interview rounds with topics ranging from self‑introduction and window functions to data skew, shuffle mechanisms, warehouse architecture, data quality, and governance, plus interviewers' feedback and recommended preparation tips.

ByteDancedata-warehouseinterview-questions
0 likes · 6 min read
Crack ByteDance Data Warehouse Engineer Interviews: 30+ Essential Questions
Laravel Tech Community
Laravel Tech Community
Aug 20, 2025 · Databases

Three Powerful Ways to Perform Cumulative Queries in SQL

This article explains three techniques for performing cumulative queries in SQL—using a subquery, a Cartesian product with grouping, and a window function—detailing when each method is appropriate, especially for MySQL versions lacking native window support.

Subquerycartesian joincumulative query
0 likes · 2 min read
Three Powerful Ways to Perform Cumulative Queries in SQL
Aikesheng Open Source Community
Aikesheng Open Source Community
Aug 18, 2025 · Databases

Unlocking LeetCode’s Hardest SQL Problem with Window Functions

This article examines LeetCode problem 185 – the hardest SQL challenge – by preparing the Employee and Department tables, presenting two solution approaches (a subquery and a window‑function version), benchmarking their performance on large test data, and explaining why window functions are the superior choice in MySQL 8+.

LeetCodemysqlperformance
0 likes · 10 min read
Unlocking LeetCode’s Hardest SQL Problem with Window Functions
Alibaba Cloud Big Data AI Platform
Alibaba Cloud Big Data AI Platform
Aug 15, 2025 · Big Data

How MaxCompute Extends SQL to Match BigQuery – New Features & Compatibility

This article details the challenges of migrating 100,000+ SQL statements from BigQuery to MaxCompute for a leading Southeast Asian tech group, explains the new MaxCompute SQL syntax, auto‑partition and ingestion‑time tables, enhanced built‑in functions, and the BigQuery compatibility mode that ensures seamless query behavior.

BigQueryCompatibilityData Migration
0 likes · 15 min read
How MaxCompute Extends SQL to Match BigQuery – New Features & Compatibility
Liangxu Linux
Liangxu Linux
Aug 13, 2025 · Databases

Unlock MySQL Mastery: A Complete Theory & Hands‑On Guide

This comprehensive guide walks you through MySQL fundamentals and advanced features, covering database architecture, storage engines, data types, CRUD operations, complex queries, transactions, indexing, performance tuning, replication, JSON handling, full‑text search, and best practices for security and backup.

CRUDTutorialdatabase
0 likes · 27 min read
Unlock MySQL Mastery: A Complete Theory & Hands‑On Guide
Huawei Cloud Developer Alliance
Huawei Cloud Developer Alliance
Aug 8, 2025 · Databases

GaussDB-Powered Database Textbook: Transforming Teaching & Practice

Facing gaps in database education, Beijing Information Technology University launched a GaussDB‑based textbook project to blend theory with hands‑on practice, producing a four‑part, thirteen‑chapter resource that covers fundamentals, SQL, design, and management, while supporting curriculum reform and industry collaboration.

Curriculum ReformDatabase EducationDatabase Management
0 likes · 10 min read
GaussDB-Powered Database Textbook: Transforming Teaching & Practice
Spring Full-Stack Practical Cases
Spring Full-Stack Practical Cases
Aug 8, 2025 · Databases

Master SQL Execution Order, Joins, CTEs & Window Functions

This article provides a comprehensive guide to essential SQL concepts for backend developers and data engineers, covering query execution order, core commands, various join types, common table expressions (including recursive CTEs), window functions, and performance optimization techniques such as table scans and indexing, complete with practical code examples and visual illustrations.

CTEJoinsdatabase
0 likes · 10 min read
Master SQL Execution Order, Joins, CTEs & Window Functions
Volcano Engine Developer Services
Volcano Engine Developer Services
Aug 7, 2025 · Operations

How to Collect and Analyze JuiceFS Access Logs with Volcengine TLS

This article explains how to gather JuiceFS access logs using the LogCollector agent, parse and structure them with TLS, design index fields, build analytical dashboards, run advanced SQL queries for write‑IO distribution, sequential‑read ratios, overwrite detection, file‑lifecycle analysis, and set up real‑time monitoring and alerting for performance anomalies.

JuiceFSLogCollectorTLS
0 likes · 22 min read
How to Collect and Analyze JuiceFS Access Logs with Volcengine TLS
Aikesheng Open Source Community
Aikesheng Open Source Community
Aug 7, 2025 · Databases

Unlock MySQL REST Service: Step‑by‑Step Installation and API Guide

This tutorial walks you through installing MySQL REST Service on Oracle Linux, configuring the metadata schema, using MySQL Shell in VS Code, loading the component, managing variables, handling X‑protocol settings, creating services, and authenticating via MRS, MySQL Internal, cookie or JWT, with full command‑line examples and code snippets.

AuthenticationJSONMySQL Shell
0 likes · 17 min read
Unlock MySQL REST Service: Step‑by‑Step Installation and API Guide
Alibaba Cloud Big Data AI Platform
Alibaba Cloud Big Data AI Platform
Aug 5, 2025 · Big Data

How MaxQA Supercharges Query Performance for Large‑Scale Data Warehouses

This article details the migration of Southeast Asia's leading tech group GoTerra from Google BigQuery to Alibaba Cloud MaxCompute, explaining the performance challenges, the MaxQA accelerator architecture, optimization techniques, resource‑quota strategies, and future enhancements that together double query efficiency while reducing costs.

Big Datadata-warehouseperformance optimization
0 likes · 19 min read
How MaxQA Supercharges Query Performance for Large‑Scale Data Warehouses
Alibaba Cloud Native
Alibaba Cloud Native
Aug 5, 2025 · Cloud Native

Master JSON Log Analysis in Alibaba Cloud SLS: Flatten, Index & AI Query

This guide explains how to efficiently process and analyze massive JSON logs in Alibaba Cloud Log Service (SLS) by flattening data before storage, configuring indexes, leveraging powerful JSON extraction functions, using unnest for array analysis, and employing the AI‑driven SQL Copilot to generate optimal queries, all with practical code examples.

AIJSONLog Service
0 likes · 12 min read
Master JSON Log Analysis in Alibaba Cloud SLS: Flatten, Index & AI Query
Alibaba Cloud Developer
Alibaba Cloud Developer
Aug 5, 2025 · Databases

How PolarDB IMCI Unifies Vector Search and Embedding in One SQL Engine

This article explains how PolarDB IMCI integrates vector indexing and embedding directly into the database kernel, offering a unified, transactional, and real‑time vector lifecycle management service that lets developers build RAG knowledge bases and AI applications using only standard SQL, dramatically reducing development and operational complexity.

AIPolardbRAG
0 likes · 11 min read
How PolarDB IMCI Unifies Vector Search and Embedding in One SQL Engine
Aikesheng Open Source Community
Aikesheng Open Source Community
Aug 5, 2025 · Artificial Intelligence

How Model Size Shapes SQL Mastery: Insights from 1.5B‑32B LLMs

This article examines how the parameter count of large language models influences their ability to generate and understand SQL, comparing small (1.5B), medium (7B), and large (32B) models through a complex query case study, and highlights the trade‑offs between accuracy, reasoning depth, and resource consumption.

Artificial IntelligenceModel Scalingsql
0 likes · 14 min read
How Model Size Shapes SQL Mastery: Insights from 1.5B‑32B LLMs
Aikesheng Open Source Community
Aikesheng Open Source Community
Aug 4, 2025 · Artificial Intelligence

July 2025 AI SQL Benchmark: New Leaders & Deep Dive into Large SQL & DB Migration

The July 2025 SCALE report evaluates the latest AI large models on advanced SQL tasks, introduces new entrants like Claude 3.5 Sonnet and Gemini 2.5 stable releases, upgrades the benchmark with large‑SQL and domestic database conversion metrics, and provides detailed rankings and analyses of model performance across optimization, dialect translation, and understanding.

AIsql
0 likes · 11 min read
July 2025 AI SQL Benchmark: New Leaders & Deep Dive into Large SQL & DB Migration
Java Baker
Java Baker
Aug 4, 2025 · Operations

How to Build Real‑Time and Offline Data Reconciliation for System Consistency

This article explains why cross‑system data inconsistencies occur, defines key reconciliation metrics—completeness, timeliness, and automatic repair—and provides step‑by‑step designs for both real‑time (seconds‑to‑minutes) and offline (hour‑to‑day) reconciliation, including message‑driven triggers, batch processing, and SQL examples for detecting and fixing mismatches.

Data ReconciliationOfflineOperations
0 likes · 8 min read
How to Build Real‑Time and Offline Data Reconciliation for System Consistency
Alibaba Cloud Big Data AI Platform
Alibaba Cloud Big Data AI Platform
Jul 29, 2025 · Big Data

How GoTerra Cut Costs and Boost Speed: BigQuery‑to‑MaxCompute Performance Secrets

This article details the real‑world migration of a leading Southeast Asian tech group from BigQuery to MaxCompute, exposing the three major challenges, the data‑driven performance‑optimization methodology, and the concrete techniques—Auto Partition, UNNEST redesign, large‑query graph optimizations, and intelligent tuning—that delivered dramatic cost reductions and query‑speed gains.

Auto PartitionBig DataData Warehouse Migration
0 likes · 17 min read
How GoTerra Cut Costs and Boost Speed: BigQuery‑to‑MaxCompute Performance Secrets
Wukong Talks Architecture
Wukong Talks Architecture
Jul 25, 2025 · Databases

Testing T‑SQL Compatibility in KingbaseES: Key Findings and Tips

This article walks through installing KingbaseES's SQL Server compatible edition, evaluates core T‑SQL features such as GO, PRINT, RAISERROR, THROW, statement terminators, and trailing commas in CREATE TABLE, provides practical code examples, and offers solutions to common Windows installation errors.

KingbaseESSQL Server compatibilityT-SQL
0 likes · 15 min read
Testing T‑SQL Compatibility in KingbaseES: Key Findings and Tips
php Courses
php Courses
Jul 22, 2025 · Databases

10 Must‑Know Advanced SQL Tricks to Boost Your Development Efficiency

This article presents ten essential advanced SQL techniques—including EXPLAIN, window functions, CTEs, bulk operations, index optimization, transactions, JSON handling, temporary tables, proper NULL handling, and recursive queries—to help developers write more efficient, maintainable, and powerful database code.

Advanced QueriesCTEDatabase Optimization
0 likes · 8 min read
10 Must‑Know Advanced SQL Tricks to Boost Your Development Efficiency
IT Xianyu
IT Xianyu
Jul 22, 2025 · Databases

Master DataGrip: Connect, Insert, Update, and Delete PostgreSQL in Minutes

This guide walks you through using JetBrains DataGrip on AlmaLinux to connect to a PostgreSQL server, then demonstrates step‑by‑step how to insert, modify, and delete records via the graphical interface and optional SQL console, highlighting key settings and safety tips.

AlmaLinuxCRUDDataGrip
0 likes · 10 min read
Master DataGrip: Connect, Insert, Update, and Delete PostgreSQL in Minutes
Su San Talks Tech
Su San Talks Tech
Jul 21, 2025 · Databases

Master MySQL Table Lookups and Index Condition Pushdown

The article explains MySQL’s table lookup (回表) and index condition pushdown (索引下推), illustrating their mechanisms with sample tables, SQL statements, execution plans, performance drawbacks, and practical techniques such as covering indexes to reduce I/O and improve query efficiency.

Database OptimizationTable Lookupindex condition pushdown
0 likes · 9 min read
Master MySQL Table Lookups and Index Condition Pushdown
Architect
Architect
Jul 20, 2025 · Databases

Master Druid Monitoring: Configure, Filter, and Remove Ads in Spring Boot

This guide explains how to integrate Alibaba Druid as a Java database connection pool, add Maven dependencies, configure core properties, enable SQL and slow‑SQL monitoring, set up WebStatFilter and Spring AOP monitoring, remove the built‑in advertisement, and retrieve monitoring data via DruidStatManagerFacade.

Connection PoolDatabase MonitoringDruid
0 likes · 15 min read
Master Druid Monitoring: Configure, Filter, and Remove Ads in Spring Boot
MaGe Linux Operations
MaGe Linux Operations
Jul 19, 2025 · Databases

Master MySQL 8.0 Performance: 20+ Proven Optimization Tips

This guide presents more than twenty practical MySQL 8.0 optimization recommendations—including hardware tuning, InnoDB configuration, index design, query rewriting, security hardening, monitoring, backup strategies, and benchmarking—to help engineers dramatically improve database throughput, latency, and stability.

Database OptimizationInnoDBmysql
0 likes · 15 min read
Master MySQL 8.0 Performance: 20+ Proven Optimization Tips
Senior Tony
Senior Tony
Jul 19, 2025 · Databases

Why Your MySQL Index Fails: 8 Common Pitfalls and How to Fix Them

This article examines eight typical situations that cause MySQL indexes to become ineffective—such as violating the leftmost‑prefix rule, leading‑wildcard LIKE patterns, OR conditions, functions, calculations, implicit type conversions, large result sets, and mismatched ORDER BY directions—providing SQL examples, execution‑plan screenshots, and practical explanations.

Index Optimizationdatabasemysql
0 likes · 11 min read
Why Your MySQL Index Fails: 8 Common Pitfalls and How to Fix Them
Big Data Tech Team
Big Data Tech Team
Jul 17, 2025 · Big Data

Master Hive SQL: 10 Advanced Use Cases & Performance Optimizations for Hive 3.x

This article presents ten practical Hive SQL advanced scenarios—including session segmentation, funnel conversion, median calculation, array explosion, hierarchical recursion, deduplication, small‑file merging, conditional aggregation, approximate statistics, and data‑quality checks—each with full SQL code, key technical points, and optimization tips for Hive 3.x.

data-warehousehiveoptimization
0 likes · 9 min read
Master Hive SQL: 10 Advanced Use Cases & Performance Optimizations for Hive 3.x
IT Services Circle
IT Services Circle
Jul 17, 2025 · Databases

Understanding MySQL Table Lookups and Index Condition Pushdown

This article explains the concepts of table lookups (回表) and index condition pushdown (索引下推) in MySQL, demonstrates how they work with example tables and queries, discusses their performance impact, and provides practical techniques such as covering indexes and selective column queries to minimize costly table lookups.

Database OptimizationTable Lookupindex condition pushdown
0 likes · 8 min read
Understanding MySQL Table Lookups and Index Condition Pushdown
StarRocks
StarRocks
Jul 16, 2025 · Cloud Native

Build a Decoupled Storage‑Compute Data Platform with StarRocks and MinIO

This step‑by‑step tutorial shows how to deploy StarRocks and MinIO in a decoupled storage‑compute architecture using Docker Compose and Kubernetes, configure local caching, create storage volumes, load public datasets, and run SQL queries to explore the combined data.

Data LakehouseDecoupled StorageDocker Compose
0 likes · 14 min read
Build a Decoupled Storage‑Compute Data Platform with StarRocks and MinIO
Java Tech Enthusiast
Java Tech Enthusiast
Jul 14, 2025 · Databases

13 Proven SQL Optimization Tricks to Supercharge Your Queries

This article presents a comprehensive set of practical SQL optimization techniques—including proper indexing, selective column retrieval, efficient joins, query planning, and database‑specific features—to dramatically improve query speed, reduce resource consumption, and enhance overall application performance.

Joinsindexesperformance
0 likes · 12 min read
13 Proven SQL Optimization Tricks to Supercharge Your Queries
MaGe Linux Operations
MaGe Linux Operations
Jul 13, 2025 · Databases

Unlock MySQL Mastery: Deep Dive into Architecture, SQL & Performance

Explore the comprehensive structure of MySQL, from its layered architecture and storage engines to detailed SQL language components, while learning essential DDL, DML, DQL, and DCL commands, performance tuning techniques, security best practices, and advanced features such as window functions, CTEs, and role-based access control.

databasemysqlperformance
0 likes · 26 min read
Unlock MySQL Mastery: Deep Dive into Architecture, SQL & Performance
Architect's Tech Stack
Architect's Tech Stack
Jul 8, 2025 · Databases

Master MySQL Full-Text Search: Indexes, Queries, and Advanced Techniques

This article explains MySQL's InnoDB full‑text search, covering the theory of inverted indexes, how to create and use full‑text indexes with various MATCH…AGAINST modes, Boolean operators, query expansion, relevance calculation, and index removal, illustrated with practical SQL examples and diagrams.

Full‑Text Searchdatabaseinverted index
0 likes · 12 min read
Master MySQL Full-Text Search: Indexes, Queries, and Advanced Techniques
Alibaba Cloud Observability
Alibaba Cloud Observability
Jul 7, 2025 · Information Security

Tracing Malicious Attacks with Alibaba Cloud SLS SQL and Automated Multi‑Cloud Defense

This article walks through a real‑world case where a large platform suffered a massive traffic‑based attack, showing how Alibaba Cloud Log Service (SLS) SQL can extract high‑frequency IPs, join them with user identifiers, perform geographic analysis, and automatically update AWS and Alibaba WAF rules to block malicious sources.

SLSattack tracingcloud security
0 likes · 13 min read
Tracing Malicious Attacks with Alibaba Cloud SLS SQL and Automated Multi‑Cloud Defense
Architect's Tech Stack
Architect's Tech Stack
Jul 7, 2025 · Databases

Boost MyBatis Batch Inserts: Why foreach Slows Down and How to Fix It

This article explains why using MyBatis foreach for bulk inserts can cause severe performance degradation, analyzes the underlying parsing and executor issues, and provides practical solutions such as using ExecutorType.BATCH and limiting batch sizes to achieve fast, reliable batch insertion.

Batch InsertExecutorType.BATCHMyBatis
0 likes · 8 min read
Boost MyBatis Batch Inserts: Why foreach Slows Down and How to Fix It
Alibaba Cloud Native
Alibaba Cloud Native
Jul 2, 2025 · Information Security

Tracing Malicious Attacks on Large Platforms with Alibaba Cloud SLS SQL

This article walks through a real‑world case where a large platform suffered a massive traffic‑based attack, showing how to extract high‑frequency IPs, join logs by trace_id, perform geographic analysis, and automate blacklist updates across Alibaba Cloud and AWS using SLS SQL and Python SDKs.

Information SecuritySLSattack tracing
0 likes · 12 min read
Tracing Malicious Attacks on Large Platforms with Alibaba Cloud SLS SQL
php Courses
php Courses
Jul 2, 2025 · Databases

8 Proven PHP Database Query Optimization Techniques to Boost Performance

This article presents eight practical, proven techniques—such as prepared statements, proper indexing, selective column retrieval, pagination, efficient joins, query caching, batch operations, and EXPLAIN analysis—to dramatically improve the performance of database queries in PHP web applications, reducing load times and server strain.

Database OptimizationPHPPrepared Statements
0 likes · 6 min read
8 Proven PHP Database Query Optimization Techniques to Boost Performance
Architect's Must-Have
Architect's Must-Have
Jul 2, 2025 · Databases

Understanding Database Indexes: Structures, Types, and Best Practices

This article explains the fundamentals of database indexes, covering their purpose, underlying data structures such as B‑Tree, B+‑Tree, and hash tables, the advantages and drawbacks, different index categories in MySQL, and practical SQL examples for primary, secondary, and unique indexes.

B-TreeDatabase Indexeshash table
0 likes · 9 min read
Understanding Database Indexes: Structures, Types, and Best Practices
Su San Talks Tech
Su San Talks Tech
Jun 30, 2025 · Databases

10 Proven Index Design Rules to Supercharge Database Performance

This article presents ten practical rules for designing database indexes—covering business‑scenario analysis, the left‑most prefix principle, avoiding over‑indexing, using covering indexes, data‑type choices, function traps, prefix indexes, NULL handling, maintenance scripts, and monitoring—each illustrated with SQL examples, diagrams, and real‑world performance gains.

Query Tuningcovering indexdatabase indexing
0 likes · 13 min read
10 Proven Index Design Rules to Supercharge Database Performance
ITPUB
ITPUB
Jun 28, 2025 · Databases

How Oracle Executes a SQL Statement: From Parsing to Optimizer

This article explains Oracle's step‑by‑step processing of a SQL statement—including the client submission, parsing checks, optimizer decision‑making, row‑source generation, and final execution—while illustrating hard and soft parses, optimizer components, and practical query‑plan queries.

Oracledatabaseexecution plan
0 likes · 25 min read
How Oracle Executes a SQL Statement: From Parsing to Optimizer
Java Captain
Java Captain
Jun 28, 2025 · Backend Development

How to Add a Creator Province Filter to a To-Do Page and Fix Pagination Bugs

This article walks through adding a creator‑province dropdown filter to a to‑do list page, updating both front‑end components and back‑end APIs, handling status count changes, implementing reset logic, and debugging a pagination bug caused by incorrect start‑row calculations.

APIfrontendpagination
0 likes · 9 min read
How to Add a Creator Province Filter to a To-Do Page and Fix Pagination Bugs
IT Xianyu
IT Xianyu
Jun 26, 2025 · Databases

Master DataGrip: Connect MySQL & PostgreSQL Quickly with Step‑by‑Step Guide

This tutorial walks you through preparing your environment, configuring DataGrip, and executing SQL scripts to connect and manage both MySQL and PostgreSQL databases, complete with hardware requirements, connection parameters, sample code, troubleshooting tips, and performance optimization advice.

DataGripIDEdatabase
0 likes · 8 min read
Master DataGrip: Connect MySQL & PostgreSQL Quickly with Step‑by‑Step Guide
Java Architecture Diary
Java Architecture Diary
Jun 25, 2025 · Artificial Intelligence

Build a Text‑to‑SQL Chatbot with Spring AI and DeepSeek LLM

This tutorial walks through creating a natural‑language‑to‑SQL chatbot using Spring AI, configuring a MySQL school database with Flyway, defining system prompts for a DeepSeek LLM, implementing service beans and a REST API, and interacting with the bot via curl commands.

ChatbotDeepSeekLLM
0 likes · 15 min read
Build a Text‑to‑SQL Chatbot with Spring AI and DeepSeek LLM
dbaplus Community
dbaplus Community
Jun 22, 2025 · Backend Development

Why UUIDv7 Is the New Go-To Primary Key for Distributed Databases

The article explains the drawbacks of traditional random UUIDs as primary keys, introduces the time‑ordered design of UUIDv7, compares it with earlier versions, and provides practical Java code and SQL examples for generating and using UUIDv7 in databases.

Distributed SystemsUUIDv7primary key
0 likes · 8 min read
Why UUIDv7 Is the New Go-To Primary Key for Distributed Databases
IT Xianyu
IT Xianyu
Jun 22, 2025 · Databases

Master Looping and Variables in MySQL & PostgreSQL Stored Procedures

This tutorial demonstrates how to use variables and loop constructs in MySQL and PostgreSQL stored procedures to iterate over a users table, filter records by age, and simulate sending a system welcome message, while comparing syntax differences between the two databases.

/loopStored Proceduremysql
0 likes · 6 min read
Master Looping and Variables in MySQL & PostgreSQL Stored Procedures
IT Xianyu
IT Xianyu
Jun 19, 2025 · Databases

Master MySQL Stored Procedure Parameters: IN, OUT, INOUT Explained with Real Examples

This tutorial explains why stored procedure parameters are essential, details the differences between IN, OUT, and INOUT parameters, and provides step‑by‑step MySQL examples—including environment setup, code snippets, execution results, common FAQs, and an advanced age‑checking exercise—to help developers write flexible, reusable procedures.

IN OUT INOUTStored Proceduremysql
0 likes · 10 min read
Master MySQL Stored Procedure Parameters: IN, OUT, INOUT Explained with Real Examples
JD Tech
JD Tech
Jun 18, 2025 · Backend Development

How to Instantly Spot Problematic SQL with a MyBatis Coloring Interceptor

This article explains how to implement a lightweight MyBatis interceptor that annotates SQL statements with their mapper ID and execution stack, enabling developers to quickly locate performance bottlenecks during high‑traffic events, and also shows an AspectJ alternative for non‑MyBatis projects.

InterceptorMyBatisdebugging
0 likes · 30 min read
How to Instantly Spot Problematic SQL with a MyBatis Coloring Interceptor
Aikesheng Open Source Community
Aikesheng Open Source Community
Jun 17, 2025 · Artificial Intelligence

Introducing SCALE: An Open‑Source Benchmark Redefining LLM SQL Capabilities

This article presents SCALE, a community‑driven, open‑source benchmark that expands beyond simple Text‑to‑SQL accuracy to evaluate large language models on performance, dialect conversion, and deep SQL understanding, offering developers, researchers, and CTOs a realistic measure of AI‑assisted database tasks.

AILLMbenchmark
0 likes · 10 min read
Introducing SCALE: An Open‑Source Benchmark Redefining LLM SQL Capabilities
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Jun 11, 2025 · Databases

Understanding MySQL Transaction Isolation Levels with Real‑World Examples

This article explains MySQL's four transaction isolation levels—READ UNCOMMITTED, READ COMMITTED, REPEATABLE READ, and SERIALIZABLE—through step‑by‑step examples, demonstrating their effects on dirty reads, non‑repeatable reads, phantom reads, and performance considerations, helping developers choose the appropriate level.

Database ConcurrencyInnoDBmysql
0 likes · 10 min read
Understanding MySQL Transaction Isolation Levels with Real‑World Examples
JD Cloud Developers
JD Cloud Developers
Jun 10, 2025 · Backend Development

How to Instantly Spot Problematic SQL with MyBatis Interceptor Coloring

This article introduces a lightweight SQL‑coloring technique for MyBatis that annotates each executed query with its mapper ID and call‑stack, enabling developers to pinpoint performance bottlenecks instantly without hunting through multiple code paths, and provides both MyBatis interceptor and AspectJ weaving implementations.

InterceptorMyBatisaspectj
0 likes · 30 min read
How to Instantly Spot Problematic SQL with MyBatis Interceptor Coloring
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.

Multimodal AIPolardbdatabase integration
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.

databaseindexmysql
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 Administrationmysqlsql
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.

databaseindexoptimization
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.

LLMText2SQLVanna
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.

OLAPOLTPRow to Column
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