BestHub
Sign in
Tagged articles

SQL

2820 articles · Page 1 of 29
Alibaba Cloud Big Data AI Platform
Alibaba Cloud Big Data AI Platform
Jul 1, 2026 · Artificial Intelligence

SQL‑Driven Text Classification with Hologres AI Function: Prompt Design to KV‑Cache Tuning

This article demonstrates how Hologres AI Function enables end‑to‑end text classification directly in the database using a single SQL call, covering data preparation, prompt engineering, batch inference, accuracy evaluation (up to 95%), and cost analysis with KV‑Cache optimization that reduces token charges to as low as 0.11 CNY for 200 reviews.

AI FunctionCost OptimizationHologres
0 likes · 12 min read
SQL‑Driven Text Classification with Hologres AI Function: Prompt Design to KV‑Cache Tuning
Linyb Geek Road
Linyb Geek Road
Jun 30, 2026 · Backend Development

How to Design Pagination for Billion‑Row Sharded Databases in an Interview

The article systematically breaks down pagination challenges in billion‑row sharded databases, compares common sharding strategies and middleware architectures, analyzes the performance drawbacks of a naïve global‑query approach, and presents several practical alternatives—including keyset pagination, two‑stage queries, index‑table tricks, and external search or NewSQL solutions—while highlighting their trade‑offs for interview discussions.

PerformanceSQLSharding
0 likes · 24 min read
How to Design Pagination for Billion‑Row Sharded Databases in an Interview
DataFunSummit
DataFunSummit
Jun 29, 2026 · Big Data

Generate Ad Creative with One SQL Using Hologres for Intelligent Creation and Closed‑Loop Analysis

The article explains how Hologres AI Function and Skills transform traditional, slow, and fragmented ad‑creative production into a fully automated, SQL‑driven workflow that handles multimodal data ingestion, AI‑based labeling, video generation, and real‑time performance analysis in a single closed‑loop system.

AI FunctionAd CreativeData Warehouse
0 likes · 12 min read
Generate Ad Creative with One SQL Using Hologres for Intelligent Creation and Closed‑Loop Analysis
IoT Full-Stack Technology
IoT Full-Stack Technology
Jun 26, 2026 · Databases

Are You Still Using These 8 Inefficient SQL Patterns?

This article examines eight common SQL pitfalls—including misuse of LIMIT offsets, implicit type conversion, sub‑query updates, mixed ordering, EXISTS clauses, condition push‑down, early limiting, and intermediate result set handling—showing how each can degrade performance and providing rewritten queries with execution‑plan evidence that dramatically improve speed.

Execution PlanMySQLPerformance
0 likes · 12 min read
Are You Still Using These 8 Inefficient SQL Patterns?
dbaplus Community
dbaplus Community
Jun 21, 2026 · Databases

Why the 20‑Year‑Old N+1 Query Problem Doesn’t Apply to SQLite

The article explains that the classic N+1 query anti‑pattern, harmful on client‑server databases like MySQL, is irrelevant for SQLite because its embedded architecture eliminates network round‑trips, turning hundreds of queries into cheap function calls, and examines the performance data and trade‑offs behind this claim.

Database PerformanceFossilN+1 query
0 likes · 29 min read
Why the 20‑Year‑Old N+1 Query Problem Doesn’t Apply to SQLite
DataFunSummit
DataFunSummit
Jun 19, 2026 · Big Data

Near‑Real‑Time Data Warehousing with Yunqi Lakehouse: Cases from Xiaohongshu, Kuaishou, Meituan

The article examines how Xiaohongshu, Kuaishou and Meituan adopted Yunqi Lakehouse’s General Incremental Computing and Single‑Engine architecture to achieve near‑real‑time data warehouses, cutting resource usage to as low as 1/20 of full‑batch jobs, reducing data latency from days to minutes, and improving query performance.

Big DataCase StudyGeneral Incremental Computing
0 likes · 12 min read
Near‑Real‑Time Data Warehousing with Yunqi Lakehouse: Cases from Xiaohongshu, Kuaishou, Meituan
Machine Heart
Machine Heart
Jun 18, 2026 · Artificial Intelligence

SAG: The New RAG SOTA That Delivers Sub‑Second Retrieval on 500 Million Records

SAG (SQL‑Retrieval Augmented Generation) introduces a hypergraph‑based event‑entity data model that combines SQL joins, vector similarity, and hyperedge reasoning to achieve 79%‑88% Recall@2‑5 with second‑level latency on a 500 M‑row corpus, outperforming GraphRAG and HippoRAG in multi‑hop tasks.

AIAgentBenchmark
0 likes · 14 min read
SAG: The New RAG SOTA That Delivers Sub‑Second Retrieval on 500 Million Records
Alibaba Cloud Observability
Alibaba Cloud Observability
Jun 15, 2026 · Cloud Native

Measuring AI Coding Impact from Individual to Organization with LoongSuite‑Pilot and SLS

This article details how LoongSuite‑Pilot captures heterogeneous AI coding agent events and leverages Alibaba Cloud Log Service (SLS) SQL dashboards to provide end‑to‑end, organization‑wide metrics—covering individual usage, team adoption, token consumption, skill and tool utilization—enabling R&D teams to quantify the real‑world effectiveness of AI coding assistants.

AI codingCloud LoggingLoongSuite
0 likes · 21 min read
Measuring AI Coding Impact from Individual to Organization with LoongSuite‑Pilot and SLS
Architect's Guide
Architect's Guide
Jun 15, 2026 · Databases

Chat2DB Review: Alibaba’s Open‑Source Multi‑Database Client with AI‑Driven SQL Features

Chat2DB is a free open‑source multi‑database client that adds AI capabilities such as natural‑language‑to‑SQL, SQL‑to‑natural‑language, and performance suggestions; this guide walks through downloading, installing, configuring OpenAI keys, using its four main menus, and evaluating its SQL generation, explanation, and optimization functions.

AIChat2DBMySQL
0 likes · 11 min read
Chat2DB Review: Alibaba’s Open‑Source Multi‑Database Client with AI‑Driven SQL Features
AI Architecture Path
AI Architecture Path
Jun 11, 2026 · Databases

Why Beekeeper Studio Is the Free, Open‑Source Alternative to Navicat with Built‑In AI SQL Assistant

The article compares paid database clients such as Navicat, DBeaver, TablePlus and DataGrip, highlights their cost and usability issues, and presents Beekeeper Studio—a cross‑platform, open‑source tool with a sleek UI, tab persistence, smart SQL completion, extensive database support, and an AI Shell for automatic query generation—while also outlining its strengths, limitations, and when to choose the free Community edition versus the paid Ultimate edition.

AIBeekeeper StudioComparison
0 likes · 11 min read
Why Beekeeper Studio Is the Free, Open‑Source Alternative to Navicat with Built‑In AI SQL Assistant
Architect Chen
Architect Chen
Jun 10, 2026 · Databases

12 Essential MySQL Online Commands Every DBA Should Know

This guide lists the most frequently used MySQL commands for checking version, connections, process lists, killing queries, global status, configuration variables, lock waits, slow‑query settings, table sizes, index information, execution plans, and replication status, each with practical usage scenarios.

DBADatabase AdministrationIndexes
0 likes · 5 min read
12 Essential MySQL Online Commands Every DBA Should Know
Alibaba Cloud Native
Alibaba Cloud Native
Jun 9, 2026 · Cloud Native

From Individual Productivity to Organizational Insight: Building AI Coding Metrics with LoongSuite‑Pilot and SLS

The article explains how to capture event‑level AI coding agent data using LoongSuite‑Pilot, align it with the LoongSuite GenAI semantic conventions, store it in Alibaba Cloud Log Service (SLS), and construct a multi‑layered SQL dashboard that turns personal usage signals into organization‑wide metrics for informed decision‑making.

AIObservabilitySQL
0 likes · 25 min read
From Individual Productivity to Organizational Insight: Building AI Coding Metrics with LoongSuite‑Pilot and SLS
Architect's Guide
Architect's Guide
Jun 8, 2026 · Backend Development

Three Practical Data Masking Solutions That Really Work

This article walks through three common data‑masking approaches—SQL queries using string functions, a Java‑based "sensitive‑plus" plugin, and the mybatis‑mate‑sensitive‑jackson extension—showing configuration, code examples, and how each method masks phone numbers, ID cards and other personal fields.

Data MaskingJavaMyBatis
0 likes · 10 min read
Three Practical Data Masking Solutions That Really Work
Top Architect
Top Architect
Jun 5, 2026 · Databases

Eliminate LIKE% in MySQL: Use Full‑Text Search for Efficient Fuzzy Queries

This article explains why using LIKE% for fuzzy searches in MySQL is inefficient, introduces InnoDB full‑text search (available since MySQL 5.6), describes inverted indexes, shows how to create and query full‑text indexes with natural language, boolean, and query‑expansion modes, discusses relevance calculation, stopwords, token‑size parameters, and provides the syntax for dropping full‑text indexes.

Boolean ModeFull-Text SearchInnoDB
0 likes · 12 min read
Eliminate LIKE% in MySQL: Use Full‑Text Search for Efficient Fuzzy Queries
Architect Chen
Architect Chen
Jun 5, 2026 · Databases

Complete 2026 Guide to MySQL Commands: Syntax, Usage, and Best Practices

This article provides a comprehensive, step‑by‑step reference of essential MySQL commands—including connection, database and table creation, data manipulation, schema alteration, and query optimization with EXPLAIN—complete with code examples, parameter explanations, and performance warnings for safe production use.

CRUDDDLDML
0 likes · 6 min read
Complete 2026 Guide to MySQL Commands: Syntax, Usage, and Best Practices
Alibaba Cloud Big Data AI Platform
Alibaba Cloud Big Data AI Platform
Jun 4, 2026 · Big Data

Scalar‑Vector Hybrid Search in a Data Lake with One SQL on EMR Serverless Spark

EMR Serverless Spark now supports scalar‑vector hybrid search via DLF Global Index, allowing a single Spark SQL statement to perform vector similarity and scalar filtering together, eliminating data movement, reducing latency, and boosting performance for scenarios such as autonomous driving, e‑commerce, and knowledge‑base retrieval.

Big DataDLF Global IndexEMR Serverless Spark
0 likes · 17 min read
Scalar‑Vector Hybrid Search in a Data Lake with One SQL on EMR Serverless Spark
StarRocks
StarRocks
Jun 4, 2026 · Databases

How StarRocks and Iceberg Enable Federated Queries: A Practical Walkthrough

This article details Fresha's real‑world integration of StarRocks with Apache Iceberg, covering metadata planning, distributed execution, adaptive metadata retrieval, hot‑cold data layering, missing statistics handling, catalog configuration, and performance optimizations that together demonstrate how federated queries can be efficiently executed over data‑lake tables.

Apache IcebergData LakeFederated Query
0 likes · 14 min read
How StarRocks and Iceberg Enable Federated Queries: A Practical Walkthrough
Java Tech Enthusiast
Java Tech Enthusiast
Jun 4, 2026 · Databases

Why PostgreSQL Beats MySQL in the AI Era

The article explains why developers should move beyond MySQL to PostgreSQL, illustrating the productivity gains of native window functions, MVCC concurrency, rich indexing, JSONB support, and extensive extensions through detailed examples, installation guides, performance comparisons, and real‑world use cases.

IndexingJSONBJava integration
0 likes · 24 min read
Why PostgreSQL Beats MySQL in the AI Era
dbaplus Community
dbaplus Community
Jun 3, 2026 · Big Data

Boosting SQL Compliance to 95%: Harness Solves AI’s “Memory Loss” in Data Warehouse

The article analyzes the challenges of AI‑generated SQL in a data‑warehouse environment—context loss, unstable rule enforcement, and token overflow—and presents a five‑layer Harness architecture that persists constraints, injects hooks, uses subagents, and refactors SKILL files, raising SQL compliance from 70‑80% to over 95% while reducing context compacting.

AIAutomationData Warehouse
0 likes · 26 min read
Boosting SQL Compliance to 95%: Harness Solves AI’s “Memory Loss” in Data Warehouse
Past Memory Big Data
Past Memory Big Data
Jun 2, 2026 · Artificial Intelligence

Beyond 100% Accuracy: Key Metrics to Evaluate in Text2SQL Systems

The article argues that a 100% accuracy claim for Text2SQL is misleading without considering stability, coverage, and pass‑rate metrics, and it details a deterministic NLQ pipeline that converts natural language to a verifiable intermediate format before rule‑based SQL compilation.

AIAccuracyBenchmark
0 likes · 16 min read
Beyond 100% Accuracy: Key Metrics to Evaluate in Text2SQL Systems
Programmer XiaoFu
Programmer XiaoFu
Jun 1, 2026 · Databases

Why Does an OR Between Two Indexed Columns Still Trigger a Full Table Scan?

Even though the phone and email columns each have a single‑column index, an OR condition forces MySQL's cost‑based optimizer to choose a full table scan because the estimated cost of index merge (random I/O and possible sort‑union) exceeds the cost of a sequential scan, and the article explains the underlying mechanics and practical workarounds.

MySQLOR queryQuery Optimization
0 likes · 10 min read
Why Does an OR Between Two Indexed Columns Still Trigger a Full Table Scan?
Spring Full-Stack Practical Cases
Spring Full-Stack Practical Cases
May 25, 2026 · Databases

11 Golden Rules for SQL Performance Optimization

This article explains why inefficient SQL queries cause most database bottlenecks and presents eleven concrete rules—covering indexes, SELECT *, LIMIT, WHERE clause tuning, join strategies, execution‑plan analysis, subqueries, DISTINCT, ORDER BY/GROUP BY, UNION vs UNION ALL, and query decomposition with materialized views—to help developers systematically improve SQL execution speed on MySQL and Oracle.

IndexesMySQLOptimization
0 likes · 16 min read
11 Golden Rules for SQL Performance Optimization
IT Services Circle
IT Services Circle
May 24, 2026 · Information Security

Fired, He Deleted 96 Government Databases in Minutes and Asked AI How to Clear Logs

Just five minutes after being terminated, twin brothers with prior fraud convictions used SQL commands to drop 96 U.S. government databases, queried AI on log‑clearing techniques, and exposed critical failures in the company's off‑boarding process, leading to a high‑profile federal investigation and legal fallout.

AIInformation SecuritySQL
0 likes · 9 min read
Fired, He Deleted 96 Government Databases in Minutes and Asked AI How to Clear Logs
Big Data Tech Team
Big Data Tech Team
May 24, 2026 · Big Data

Data Warehouse Interview Pitfall Guide 2.0: Avoid Common SQL, Modeling, and ETL Mistakes

This guide compiles the most frequent interview pitfalls for data warehouse roles, covering SQL join and aggregation errors, window function misuse, subquery versus CTE performance myths, dimensional modeling mistakes, SCD implementation traps, layered design issues, data quality handling, ETL traps, Hive and Spark performance questions, real‑time warehousing considerations, and effective interview strategies.

Big DataETLHive
0 likes · 3 min read
Data Warehouse Interview Pitfall Guide 2.0: Avoid Common SQL, Modeling, and ETL Mistakes
Alibaba Cloud Big Data AI Platform
Alibaba Cloud Big Data AI Platform
May 23, 2026 · Cloud Computing

Best Practice: Using EMR Serverless StarRocks AI Function for Financial Text Classification

This article demonstrates how to leverage StarRocks AI Function on EMR Serverless to perform sentiment analysis, intelligent classification, information extraction, and PII redaction on financial text entirely within SQL, eliminating data export, reducing latency, and ensuring compliance while providing concrete code examples, performance benchmarks, and best‑practice recommendations.

AI FunctionEMR ServerlessFinancial NLP
0 likes · 25 min read
Best Practice: Using EMR Serverless StarRocks AI Function for Financial Text Classification
dbaplus Community
dbaplus Community
May 20, 2026 · Databases

Stunning SQL Queries: From Tetris Game to Real‑Time Funnels

This article showcases a collection of impressive SQL queries—including a PostgreSQL Tetris implemented with a recursive CTE, window‑function session analysis, a ClickHouse real‑time funnel, dynamic WHERE clause generation, and a recursive employee hierarchy—while discussing performance tips and engine choices.

ClickHouseData WarehouseHive
0 likes · 25 min read
Stunning SQL Queries: From Tetris Game to Real‑Time Funnels
DataFunSummit
DataFunSummit
May 20, 2026 · Databases

Apache Doris 4.1: A Unified Data Store and Retrieval Engine for AI & Search

Apache Doris 4.1 introduces a systematic evolution for AI and search workloads, adding low‑cost massive vector storage, unified structured, full‑text and vector search, 100 MB JSON document support, Segment V3 metadata decoupling, sparse column optimizations, lakehouse lifecycle management, and a suite of performance‑boosting features such as aggregate push‑down, condition cache, and spill‑to‑disk, all backed by detailed benchmark results.

AIApache DorisLakehouse
0 likes · 30 min read
Apache Doris 4.1: A Unified Data Store and Retrieval Engine for AI & Search
Architect's Guide
Architect's Guide
May 20, 2026 · Databases

30 Essential SQL Query Optimization Techniques

This article presents thirty practical SQL optimization tips, covering index usage, avoiding full‑table scans caused by operators like !=, NULL checks, OR, LIKE, IN, functions, and expressions, as well as best practices for temporary tables, cursors, and transaction size to improve database performance.

IndexesPerformance TuningQuery Optimization
0 likes · 10 min read
30 Essential SQL Query Optimization Techniques
MaGe Linux Operations
MaGe Linux Operations
May 19, 2026 · Databases

How I Reduced a MySQL Slow Query from 3 seconds to 10 milliseconds

This article walks through a real‑world MySQL slow‑query case, showing how to identify the bottleneck with EXPLAIN, design covering and composite indexes, rewrite the SQL, tune InnoDB parameters, and safely deploy the changes, ultimately shrinking execution time from seconds to a few milliseconds.

EXPLAINIndexingMySQL
0 likes · 32 min read
How I Reduced a MySQL Slow Query from 3 seconds to 10 milliseconds
Big Data Technology & Architecture
Big Data Technology & Architecture
May 19, 2026 · Artificial Intelligence

Why Pure AI Black‑Box Text2SQL Fails in Enterprise Deployments

The article analyzes the inherent shortcomings of black‑box Text2SQL solutions—highlighting benchmark collapses, lack of auditability, and unacceptable error rates—and proposes a white‑box approach with a human‑readable intermediate language that enables deterministic, enterprise‑grade SQL generation.

BenchmarkEnterpriseNLQ
0 likes · 13 min read
Why Pure AI Black‑Box Text2SQL Fails in Enterprise Deployments
Su San Talks Tech
Su San Talks Tech
May 17, 2026 · Databases

Why Leading Companies Avoid NULL Values in MySQL

The article explains why major tech companies discourage using NULL in MySQL, covering its meaning as an unknown state, three-valued logic pitfalls such as NOT IN subqueries, index inefficiencies, aggregate function quirks, storage overhead, Java handling issues, and offers practical alternatives like NOT NULL constraints with sensible defaults.

Database DesignIndex OptimizationMySQL
0 likes · 11 min read
Why Leading Companies Avoid NULL Values in MySQL
Architecture Digest
Architecture Digest
May 15, 2026 · Databases

Why Alibaba Bans Joins Over Three Tables – A Must‑Know Rule for SQL Engineers

Alibaba’s Java Development Manual mandates that any SQL involving more than three tables must be avoided, a rule that stems from the exponential cost of multi‑table joins in a single‑instance database, prompting engineers to rethink data modeling, adopt denormalization, wide tables, materialized views, CQRS or application‑level assembly instead of relying on complex joins.

AlibabaCQRSDatabase Design
0 likes · 12 min read
Why Alibaba Bans Joins Over Three Tables – A Must‑Know Rule for SQL Engineers
Architect's Guide
Architect's Guide
May 14, 2026 · Databases

8 SQL Pitfalls That Can Slow Your Queries 100‑Fold – How to Avoid Them

The article enumerates eight common MySQL query patterns—such as large‑offset LIMIT, implicit type conversion, sub‑query updates, mixed ordering, unnecessary EXISTS, poor condition push‑down, early range reduction, and inefficient intermediate result handling—and shows rewritten SQL that reduces execution time from seconds to milliseconds.

IndexesJOINMySQL
0 likes · 15 min read
8 SQL Pitfalls That Can Slow Your Queries 100‑Fold – How to Avoid Them
JD Tech
JD Tech
May 13, 2026 · Databases

Deep Dive into Using JSON Fields in Databases: Practical Lessons and Pitfalls

This article walks through the rationale, common functions, and real‑world case studies of storing and querying JSON columns in a relational database, exposing issues with null handling, batch updates, and dynamic SQL generation, and presents step‑by‑step debugging and robust solutions.

Batch UpdateDynamic QueriesMySQL
0 likes · 11 min read
Deep Dive into Using JSON Fields in Databases: Practical Lessons and Pitfalls
Aikesheng Open Source Community
Aikesheng Open Source Community
May 11, 2026 · Artificial Intelligence

SCALE April 2026 Large‑Model SQL Capability Ranking Unveiled

The SCALE April 2026 report adds four new models—DeepSeek‑V4‑Pro, DeepSeek‑V4‑Flash, GPT‑5.5 and Claude Opus 4.7—to its SQL capability leaderboard, evaluates them across SQL understanding, optimization and dialect conversion, and highlights each model’s strengths, weaknesses, and recommended deployment scenarios.

AI benchmarkDialect ConversionLarge Language Models
0 likes · 17 min read
SCALE April 2026 Large‑Model SQL Capability Ranking Unveiled
Golang Shines
Golang Shines
May 7, 2026 · Databases

160 Must‑Know MySQL Interview Questions to Test Your Skills

This article presents 160 high‑frequency MySQL interview questions, covering fundamentals such as SQL basics, MySQL vs. Oracle vs. SQL Service, normalization rules, permission tables, and more, with a free PDF of the full list for interview preparation.

Database DesignInterview QuestionsMySQL
0 likes · 5 min read
160 Must‑Know MySQL Interview Questions to Test Your Skills
SpringMeng
SpringMeng
May 2, 2026 · Artificial Intelligence

10 Essential AI Prompt Templates Every Programmer Needs

This article presents ten practical AI prompt templates that help programmers efficiently handle requirement clarification, unit test generation, code explanation, refactoring, exception troubleshooting, performance tuning, SQL creation, knowledge documentation, design review, and cross‑language translation, each illustrated with concrete examples and usage tips.

AI promptingBackend DevelopmentPerformance Optimization
0 likes · 13 min read
10 Essential AI Prompt Templates Every Programmer Needs
Lin is Dream
Lin is Dream
Apr 29, 2026 · Artificial Intelligence

Where Do Agent Capabilities Come From? A High‑Frequency Skill Toolset for AI Agents

This article presents a practical collection of high‑frequency tools—including Python, Shell, SQL, Mermaid, Pandoc, curl, ImageMagick, and PlantUML—that can be wrapped as Agent Skills to give AI agents real execution power, illustrated with concrete prompts and scripts that cut manual work from hours to seconds.

Agent SkillAutomationImageMagick
0 likes · 13 min read
Where Do Agent Capabilities Come From? A High‑Frequency Skill Toolset for AI Agents
Java Baker
Java Baker
Apr 22, 2026 · Databases

A Step‑by‑Step SOP for Seamless Business Data Migration

This article outlines a comprehensive, risk‑controlled SOP for migrating business data—including model changes, storage shifts, incremental dual‑write, back‑filling, full and incremental consistency checks, read‑switching, and final decommissioning—backed by concrete SQL examples and visual diagrams.

Data ConsistencyData MigrationSQL
0 likes · 6 min read
A Step‑by‑Step SOP for Seamless Business Data Migration
AI Large-Model Wave and Transformation Guide
AI Large-Model Wave and Transformation Guide
Apr 20, 2026 · Artificial Intelligence

Build a No‑Code AI SQL Assistant with Dify in 12 Simple Steps

This step‑by‑step guide shows how to create a natural‑language database query assistant using Dify by preparing a test MySQL database, creating a read‑only user, installing the Dify database plugin, configuring the connection, building an Agent with a strong SQL‑capable LLM, setting prompts, adding Text‑to‑SQL and SQL‑Execute tools, testing simple, filtered and aggregate queries, and finally extending to multi‑table scenarios.

AIDifySQL
0 likes · 9 min read
Build a No‑Code AI SQL Assistant with Dify in 12 Simple Steps
dbaplus Community
dbaplus Community
Apr 19, 2026 · Databases

Why Vector Databases Exist: Overcoming SQL’s Blind Spot in AI Search

This guide explains how traditional relational databases and SQL struggle with semantic queries needed for AI applications, introduces vector databases and HNSW indexing for efficient similarity search, compares their architectures, and presents a real‑world fraud detection system that combines both technologies.

AIB+TreeHNSW
0 likes · 17 min read
Why Vector Databases Exist: Overcoming SQL’s Blind Spot in AI Search
Coder Trainee
Coder Trainee
Apr 7, 2026 · Backend Development

Setting Up Seata (pre‑1.0) for Distributed Transactions in Microservices

This guide explains what a distributed transaction is and walks through the complete setup of a Seata server (version 0.9.0), including downloading, configuring file.conf and registry.conf for Nacos, initializing the database, starting services, and creating the required undo_log table.

SQLSeataTransaction Management
0 likes · 4 min read
Setting Up Seata (pre‑1.0) for Distributed Transactions in Microservices
macrozheng
macrozheng
Apr 7, 2026 · Backend Development

Boost Your MyBatis Workflow in IDEA with MyBatisCodeHelper-Pro – A Complete Guide

This article introduces the MyBatisCodeHelper-Pro IntelliJ IDEA plugin, outlines its popular features such as mapper navigation, @Param generation, XML creation, pagination support, Spring integration, and SQL log conversion, and provides step‑by‑step installation and usage instructions with screenshots.

Backend DevelopmentIntelliJ IDEAMyBatis
0 likes · 5 min read
Boost Your MyBatis Workflow in IDEA with MyBatisCodeHelper-Pro – A Complete Guide
MaGe Linux Operations
MaGe Linux Operations
Apr 5, 2026 · Databases

Master MySQL Slow Query Optimization: From Logs to Indexes

This comprehensive guide explains how to detect, analyze, and optimize MySQL slow queries by configuring the slow‑query log, using pt‑query‑digest, interpreting EXPLAIN output, designing effective B+Tree indexes, avoiding common index pitfalls, optimizing count(*) operations, improving deep pagination, rewriting inefficient SQL patterns, and applying advanced table design techniques such as partitioning and sharding.

EXPLAINMySQLPerformance Tuning
0 likes · 40 min read
Master MySQL Slow Query Optimization: From Logs to Indexes
Alibaba Cloud Developer
Alibaba Cloud Developer
Apr 2, 2026 · Artificial Intelligence

How ADB MySQL Turns Agent Logs into Actionable Insights – A Step‑by‑Step Guide

This article analyzes why over 40% of Agentic AI projects fail due to inadequate observability, outlines three common pain points—trace blindness, uncontrolled token costs, and untraceable failures—and demonstrates a practical ADB MySQL solution that reconstructs logs, classifies failures with AI functions, quantifies token waste, and generates prompt‑optimization suggestions, all with a few SQL statements.

ADB MySQLAI agentsAgent observability
0 likes · 10 min read
How ADB MySQL Turns Agent Logs into Actionable Insights – A Step‑by‑Step Guide
Java Tech Workshop
Java Tech Workshop
Apr 1, 2026 · Backend Development

Rapid Data Access with SpringBoot and JdbcTemplate

This article explains how to integrate SpringBoot with JdbcTemplate to quickly build a lightweight data access layer, covering suitable scenarios, Maven dependencies, configuration, entity definition, CRUD operations, batch processing, service encapsulation, controller endpoints, transaction handling, and guidance on when to choose JdbcTemplate over MyBatis.

SQLSpring BootTransaction
0 likes · 10 min read
Rapid Data Access with SpringBoot and JdbcTemplate
dbaplus Community
dbaplus Community
Mar 31, 2026 · Industry Insights

Why Most Data Governance Projects Fail and How to Build a Practical, Engineer‑Friendly Solution

Most companies see data governance fail not because of technology but because they start with the wrong direction, focusing on rules, platforms, and processes that add friction instead of improving data usability, and the article provides a step‑by‑step, low‑overhead approach with concrete SQL and Python templates to fix it.

Data GovernanceEngineering ProductivityPython
0 likes · 25 min read
Why Most Data Governance Projects Fail and How to Build a Practical, Engineer‑Friendly Solution
Big Data Tech Team
Big Data Tech Team
Mar 30, 2026 · Big Data

2026 Data Warehouse Interview Guide: Essential Questions for All Three Rounds

This article compiles a comprehensive set of data‑warehouse interview questions—including self‑introduction prompts, SQL and window‑function challenges, data‑skew solutions, architecture design, file‑format trade‑offs, governance, and team‑leadership topics—to help candidates prepare for first, second, and third‑round interviews at leading tech firms.

Big DataData GovernanceSQL
0 likes · 7 min read
2026 Data Warehouse Interview Guide: Essential Questions for All Three Rounds
java1234
java1234
Mar 29, 2026 · Backend Development

Why MyBatis Is Called a Semi‑ORM Mapping Tool

MyBatis, a widely used Java persistence framework, blends SQL mapping with traditional JDBC, requiring developers to write SQL manually, offering greater flexibility and performance than full ORM solutions like Hibernate, while providing only persistence operations without encapsulating complex business logic.

HibernateJavaMyBatis
0 likes · 6 min read
Why MyBatis Is Called a Semi‑ORM Mapping Tool
dbaplus Community
dbaplus Community
Mar 26, 2026 · Databases

Six Fatal MySQL Index Traps and How to Avoid Them

A real‑world incident of soaring QPS reveals six common MySQL indexing pitfalls—type mismatches, function usage, left‑most prefix violations, implicit charset conversion, range query side effects, and optimizer mis‑selection—and provides concrete SQL fixes and verification tools to keep queries fast and reliable.

Database TuningIndex OptimizationMySQL
0 likes · 6 min read
Six Fatal MySQL Index Traps and How to Avoid Them
Java Architect Essentials
Java Architect Essentials
Mar 23, 2026 · Databases

When MySQL Auto‑Increment Hits Its Limit: Diagnosis and Fixes

A backend engineer discovers that a massive MySQL table’s auto‑increment INT primary key reached its maximum value, causing insert failures, and walks through detailed analysis, three remediation options—including switching to BIGINT, redesigning IDs, and sharding—plus practical scripts, performance measurements, and lessons learned about concurrency and schema design.

BIGINTMySQLPerformance
0 likes · 10 min read
When MySQL Auto‑Increment Hits Its Limit: Diagnosis and Fixes
Architect's Guide
Architect's Guide
Mar 20, 2026 · Backend Development

How We Cut 1‑Second Query Times in a Legacy WAF Dashboard Using Redis Caching

Facing slow page loads in a legacy WAF reporting system, we dissected a 1000‑line Java method, introduced hourly aggregation, Redis auto‑increment counters, and scheduled synchronization, eliminating costly SQL scans and achieving sub‑second queries on 1.5 million logs, while outlining remaining optimization opportunities.

Data ArchivingJavaPerformance Optimization
0 likes · 12 min read
How We Cut 1‑Second Query Times in a Legacy WAF Dashboard Using Redis Caching
JD Tech Talk
JD Tech Talk
Mar 18, 2026 · Databases

Mastering Dynamic JSON Fields in MySQL: Real‑World Cases and Pitfalls

This article explains how to store and query extensible JSON columns in a MySQL‑based system, lists the most useful JSON functions, walks through several real‑world scenarios—including dynamic extension queries and weight‑management cases—identifies subtle bugs caused by null values, and presents step‑by‑step SQL and MyBatis fixes to ensure reliable batch updates.

DynamicFieldsMySQLSQL
0 likes · 15 min read
Mastering Dynamic JSON Fields in MySQL: Real‑World Cases and Pitfalls
Architecture & Thinking
Architecture & Thinking
Mar 18, 2026 · Databases

10 Common MySQL Index Failure Scenarios and How to Fix Them

Even well‑designed indexes can become ineffective in production, leading to full‑table scans; this article systematically examines ten typical MySQL index‑failure cases—ranging from functions on indexed columns to low selectivity—and provides concrete SQL rewrites, performance comparisons, and diagnostic tools to help developers avoid and resolve these issues.

MySQLOptimizationPerformance
0 likes · 17 min read
10 Common MySQL Index Failure Scenarios and How to Fix Them
21CTO
21CTO
Mar 14, 2026 · Databases

Why SQL Is Making a Comeback: From Browsers to Backend

The article explores how three emerging trends—lightweight client‑side databases, schema‑less JSONB support, and modern synchronization engines—are reviving SQL, making it a first‑class data language for browsers, edge computing, and traditional back‑ends while preserving strong consistency and developer productivity.

DatabasesJSONBSQL
0 likes · 10 min read
Why SQL Is Making a Comeback: From Browsers to Backend
Java Tech Enthusiast
Java Tech Enthusiast
Mar 13, 2026 · Databases

When Does SELECT * Break Your MySQL Index? A Deep Dive into Index Invalidation

This article explains why using SELECT * does not automatically invalidate MySQL indexes, explores common scenarios that cause index loss such as left‑most prefix violations, function calls, implicit type conversions, wildcard LIKE patterns, OR/IN/NOT IN misuse, and ORDER BY pitfalls, and provides practical optimization recommendations with concrete SQL examples and verification methods.

MySQLOptimizationQuery Tuning
0 likes · 14 min read
When Does SELECT * Break Your MySQL Index? A Deep Dive into Index Invalidation
Architecture & Thinking
Architecture & Thinking
Mar 13, 2026 · Databases

Why MySQL Deep Pagination Slows Down Your E‑commerce Site and How to Fix It

The article explains how deep pagination on massive MySQL tables causes full‑table scans, massive I/O, and memory pressure, then presents six concrete optimization techniques—including delayed join, cursor pagination, covering indexes, ID‑range pagination, caching, and partitioning—backed by a real‑world e‑commerce case study and detailed execution‑plan analysis.

IndexingMySQLPerformance Optimization
0 likes · 18 min read
Why MySQL Deep Pagination Slows Down Your E‑commerce Site and How to Fix It
StarRocks
StarRocks
Mar 11, 2026 · Databases

How StarRocks Supercharges Real‑Time Ad Funnel Monitoring and Creative Optimization

This article dissects the full advertising funnel, explains why CTR and eCPM are critical, and demonstrates how StarRocks combined with Flink can deliver minute‑level real‑time monitoring, material selection, anomaly alerts, A/B testing, and a successful migration from Druid for massive ad‑tech workloads.

AdvertisingMaterialized ViewsSQL
0 likes · 20 min read
How StarRocks Supercharges Real‑Time Ad Funnel Monitoring and Creative Optimization
Selected Java Interview Questions
Selected Java Interview Questions
Mar 9, 2026 · Databases

How to Paginate Efficiently Across Sharded Databases Without OOM

This article explains why pagination only becomes complex when querying across sharded databases, compares three common solutions—including global search, sequential ID‑based paging, and the discouraged secondary query method—provides practical SQL examples, outlines pros and cons, and offers a STAR‑style interview answer.

SQLShardingpagination
0 likes · 6 min read
How to Paginate Efficiently Across Sharded Databases Without OOM
JavaGuide
JavaGuide
Mar 9, 2026 · Databases

Does SELECT * Always Invalidate Indexes? Why Some Teams Ban It

While many believe that using SELECT * inevitably disables indexes, MySQL’s optimizer only skips indexes when a full table scan is cheaper, and patterns such as violating the left‑most prefix, applying functions or implicit casts, leading‑wildcard LIKE, OR/IN misuse, and mismatched ORDER BY can cause index invalidation, prompting some companies to forbid SELECT * in production.

Index OptimizationMySQLPerformance Tuning
0 likes · 14 min read
Does SELECT * Always Invalidate Indexes? Why Some Teams Ban It
SpringMeng
SpringMeng
Mar 9, 2026 · Databases

10 Advanced MySQL Techniques to Supercharge Query Performance

This article walks through ten high‑level MySQL tricks—including EXPLAIN analysis, advanced indexing, window functions, CTEs, JSON handling, partitioning, join optimizations, user‑defined variables, online DDL, and generated columns—showing concrete examples, performance trade‑offs, and step‑by‑step guidance for turning slow queries into lightning‑fast operations.

CTEIndexingMySQL
0 likes · 15 min read
10 Advanced MySQL Techniques to Supercharge Query Performance
java1234
java1234
Mar 8, 2026 · Backend Development

How to Build a Custom MyBatis Plugin: Step-by-Step Guide

This article explains the MyBatis plugin mechanism, walks through implementing the Interceptor interface, configuring the plugin in mybatis-config.xml, provides a complete code example, and outlines common use cases such as SQL logging, performance monitoring, permission control, and automatic field filling.

JavaMyBatisPlugin
0 likes · 6 min read
How to Build a Custom MyBatis Plugin: Step-by-Step Guide
Golang Shines
Golang Shines
Mar 7, 2026 · Databases

160 Must‑Know MySQL Interview Questions to Test Your Skills

This article compiles 160 high‑frequency MySQL interview questions, covering fundamentals such as SQL basics, MySQL vs. Oracle vs. Sql Service, the three normal forms, and MySQL permission tables, helping readers prepare thoroughly for database interview challenges.

Database ComparisonDatabase InterviewMySQL
0 likes · 4 min read
160 Must‑Know MySQL Interview Questions to Test Your Skills
Alibaba Cloud Developer
Alibaba Cloud Developer
Mar 6, 2026 · Big Data

How DataWorks Turns Data Quality Rules into Code with Data Contracts

This article explains how DataWorks integrates data quality specifications directly into the SQL development workflow using Data Contracts, addressing governance lag, versioning gaps, and trust issues while providing a unified, version‑controlled, and automated quality assurance process for offline data pipelines.

Data EngineeringData QualityDataWorks
0 likes · 12 min read
How DataWorks Turns Data Quality Rules into Code with Data Contracts
ITPUB
ITPUB
Mar 5, 2026 · Databases

How to Recover a Truncated Oracle Table: Tools and Step‑by‑Step Guide

This article explains what the Oracle TRUNCATE command does, why recovery is challenging, and provides detailed step‑by‑step instructions for four practical tools—FY_Recover_Data, ODU, BBED, and GDUL—to restore data from a mistakenly truncated table.

Data RecoveryDatabase AdministrationOracle
0 likes · 5 min read
How to Recover a Truncated Oracle Table: Tools and Step‑by‑Step Guide
ITPUB
ITPUB
Mar 2, 2026 · Backend Development

Eliminate Unstable Pagination Anchors: Reliable Cursor and Timestamp Strategies for Backend Systems

This article explains why traditional offset‑based pagination can cause duplicate or missing records when data changes, compares three practical solutions—including cursor pagination with timestamp + unique key, fixed‑window timestamp filtering, and Elasticsearch’s search_after/scroll methods—detailing their implementation, pros, cons, and suitable scenarios.

CursorElasticsearchPerformance
0 likes · 14 min read
Eliminate Unstable Pagination Anchors: Reliable Cursor and Timestamp Strategies for Backend Systems
Java Architect Handbook
Java Architect Handbook
Mar 1, 2026 · Backend Development

When to Use #{} vs ${} in MyBatis? A Deep Dive for Java Interviews

This article explains the interview focus on MyBatis placeholders, detailing the syntax, security implications, performance differences, appropriate scenarios, best‑practice guidelines, common pitfalls, and provides concrete code examples to help candidates master #{} and ${} usage.

JavaMyBatisPerformance
0 likes · 9 min read
When to Use #{} vs ${} in MyBatis? A Deep Dive for Java Interviews
ITPUB
ITPUB
Feb 24, 2026 · Databases

Why INSERT … SELECT Can Lock Your Table and How an Index Saves the Day

A real‑world MySQL incident shows that using INSERT … SELECT without proper indexing can cause full‑table scans and progressive row locks, leading to massive payment failures, but adding an index on the filter column prevents the lock and restores safe batch migration.

INSERT SELECTMySQLSQL
0 likes · 8 min read
Why INSERT … SELECT Can Lock Your Table and How an Index Saves the Day
Senior Xiao Ying
Senior Xiao Ying
Feb 21, 2026 · Databases

Boost MySQL Performance: Deep Parameter Tuning to Eliminate Slowness

This guide walks through MySQL’s core memory, I/O, connection, and system variable settings—explaining each parameter’s role, recommended values, and example commands—so you can systematically adjust the configuration, monitor key metrics, and achieve up to three‑fold performance gains.

Connection ManagementDatabase ConfigurationInnoDB
0 likes · 9 min read
Boost MySQL Performance: Deep Parameter Tuning to Eliminate Slowness
ITPUB
ITPUB
Feb 20, 2026 · Databases

Master PostgreSQL Health Checks with Open‑Source SKILL Scripts

This guide introduces a collection of PostgreSQL SKILL scripts for automated health checks and operational analysis, explains the repository layout, shows how to run individual or full daily checks, lists all available skills, and provides a sample report with actionable recommendations.

Database MonitoringPostgreSQLSQL
0 likes · 11 min read
Master PostgreSQL Health Checks with Open‑Source SKILL Scripts
Senior Xiao Ying
Senior Xiao Ying
Feb 19, 2026 · Databases

Designing MySQL Partition Strategies for Billion‑Row Tables: A Complete Guide

This article explains MySQL partition types (RANGE, LIST, HASH, KEY), demonstrates partition pruning, details maintenance commands, presents real‑world use cases such as time‑series and massive tables, and offers best‑practice recommendations for key selection, partition count, automation, and query optimization.

Large TablesMySQLPartitioning
0 likes · 12 min read
Designing MySQL Partition Strategies for Billion‑Row Tables: A Complete Guide
Java Tech Enthusiast
Java Tech Enthusiast
Feb 16, 2026 · Databases

10 Must‑Know MySQL Advanced Techniques to Supercharge Performance

This article presents eleven practical MySQL advanced techniques—including execution‑plan analysis, sophisticated indexing, window functions, CTEs, JSON handling, partitioning, join optimizations, user variables, online DDL, and generated columns—each explained with real‑world examples, code snippets, and performance caveats to help developers move from basic usage to mastery.

AdvancedIndexingMySQL
0 likes · 20 min read
10 Must‑Know MySQL Advanced Techniques to Supercharge Performance
dbaplus Community
dbaplus Community
Feb 10, 2026 · Backend Development

How to Eliminate Unstable Pagination Anchors and Data Duplication in Backend Systems

This article explains why offset‑based pagination can cause duplicate or missing records in backend list queries, illustrates real‑world cases, analyzes the root causes, and presents three practical solutions—including cursor pagination, timestamp windows, and Elasticsearch search_after—along with their trade‑offs and implementation details.

CursorElasticsearchPerformance
0 likes · 12 min read
How to Eliminate Unstable Pagination Anchors and Data Duplication in Backend Systems
Java Architecture Diary
Java Architecture Diary
Feb 10, 2026 · Artificial Intelligence

Boost RAG Accuracy with LangChain4j 1.11.0 Hybrid Search on PgVector

This guide explains why pure vector retrieval often fails for version‑specific queries, introduces hybrid search that combines semantic and keyword matching, and provides step‑by‑step code and SQL examples for enabling PgVector hybrid search in LangChain4j 1.11.0.

Full-Text SearchHybrid SearchLangChain4j
0 likes · 11 min read
Boost RAG Accuracy with LangChain4j 1.11.0 Hybrid Search on PgVector
Aikesheng Open Source Community
Aikesheng Open Source Community
Feb 9, 2026 · Databases

What the Latest SCALE Benchmark Shows About SQL Optimization in GLM‑4.7 and Seed‑OSS‑36B

The January 2026 SCALE benchmark adds an index‑suggestion metric and evaluates two new LLMs—智谱 GLM‑4.7 and 字节跳动 Seed‑OSS‑36B—revealing strengths in dialect conversion, moderate SQL understanding, and notable gaps in complex execution‑plan analysis and practical index recommendations.

AI benchmarkingDialect ConversionLLM evaluation
0 likes · 15 min read
What the Latest SCALE Benchmark Shows About SQL Optimization in GLM‑4.7 and Seed‑OSS‑36B
21CTO
21CTO
Feb 7, 2026 · Databases

Why Google Renamed ZetaSQL to GoogleSQL and What It Means for Developers

Google announced on February 6, 2026 that its open‑source SQL analysis framework ZetaSQL will be renamed GoogleSQL to unify the project name with the official language spec, eliminate community confusion, and clarify its role in the Google data ecosystem without changing any code or functionality.

BigQueryGoogleSQLOpenSource
0 likes · 4 min read
Why Google Renamed ZetaSQL to GoogleSQL and What It Means for Developers
ITPUB
ITPUB
Feb 5, 2026 · Databases

Master Oracle 19c RAC Architecture in 41 Diagrams – Quick Technical Guide

This article translates and consolidates Oracle Real Application Clusters 19c Technical Architecture, using 41 detailed diagrams to explain RAC concepts, configurations, cluster components, storage options, tools, and management commands for building and operating high‑availability Oracle databases.

ASMEnterprise ManagerGrid Infrastructure
0 likes · 52 min read
Master Oracle 19c RAC Architecture in 41 Diagrams – Quick Technical Guide
Data STUDIO
Data STUDIO
Feb 5, 2026 · Fundamentals

9 Underrated Python Libraries That Can Boost Your Development Speed Tenfold

The article introduces nine lesser‑known Python packages—msgspec, glom, watchfiles, beartype, pyinstrument, duckdb, fakeredis, boltons, and returns—explaining how each tackles common prototyping pain points such as data serialization, file watching, runtime type safety, performance profiling, SQL querying without a server, mock Redis, utility functions, and explicit error handling, ultimately accelerating development by up to ten times.

Functional ProgrammingProfilingPython
0 likes · 25 min read
9 Underrated Python Libraries That Can Boost Your Development Speed Tenfold
IT Services Circle
IT Services Circle
Feb 4, 2026 · Databases

How to Optimize Multi‑Table Joins in MySQL: Practical Strategies

This article explains why excessive MySQL joins—often inherited from legacy or Oracle‑migration code—cause performance and maintenance problems, and presents nine concrete optimization techniques including SQL splitting, temporary tables, redundant fields, index tuning, query rewriting, result‑set reduction, configuration tweaks, big‑data tools, and materialized summary tables.

Database PerformanceMySQLSQL
0 likes · 11 min read
How to Optimize Multi‑Table Joins in MySQL: Practical Strategies
Selected Java Interview Questions
Selected Java Interview Questions
Feb 4, 2026 · Databases

How to Handle Pagination Across Sharded Databases Without Performance Pitfalls

This article explains why pagination only becomes complex when queries span multiple database shards, compares three mainstream solutions—including middleware, open‑source frameworks, and business compromises—highlights the pitfalls of global search for deep pages, and recommends sequential paging based on the previous page’s max ID, with interview‑ready STAR guidance.

PerformanceSQLSharding
0 likes · 7 min read
How to Handle Pagination Across Sharded Databases Without Performance Pitfalls
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Jan 28, 2026 · Databases

Master MySQL EXPLAIN: Decode Execution Plans with Real Examples

This guide introduces MySQL's EXPLAIN command, demonstrates how to create sample order and customer tables, runs various queries, and provides a detailed walkthrough of each column in the execution plan—including id, select_type, table, type, possible_keys, key, key_len, ref, rows, filtered, and extra—plus indexing tips and visual examples.

EXPLAINExecution PlanSQL
0 likes · 7 min read
Master MySQL EXPLAIN: Decode Execution Plans with Real Examples
Top Architect
Top Architect
Jan 27, 2026 · Databases

How MySQL Router 8.2 Enables Seamless Read/Write Splitting with InnoDB ReplicaSet

This article demonstrates how MySQL Router 8.2 can automatically route read traffic to replica instances and write traffic to the primary instance in an InnoDB ReplicaSet, providing configuration steps, command examples, and observed behavior without requiring any changes to the application.

Database ConfigurationInnoDB ReplicaSetRead‑Write Splitting
0 likes · 6 min read
How MySQL Router 8.2 Enables Seamless Read/Write Splitting with InnoDB ReplicaSet