Tagged articles

SQL

2879 articles · Page 2 of 29

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.

DatabaseIndexMySQL

0 likes · 14 min read

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

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.

Deep PaginationIndexingMySQL

0 likes · 18 min read

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

dbaplus Community

Mar 12, 2026 · Databases

How to Migrate 100 Billion ClickHouse Rows to Doris: Three Practical Approaches

This article walks through three concrete methods for moving massive ClickHouse datasets—up to 100 billion rows—to Doris, detailing catalog integration, file export with stream load, and Spark‑based pipelines, while sharing real‑world performance results and pitfalls.

Apache DorisClickHouseData Migration

0 likes · 8 min read

How to Migrate 100 Billion ClickHouse Rows to Doris: Three Practical Approaches

Aikesheng Open Source Community

Mar 12, 2026 · Artificial Intelligence

Which LLM Generates the Best SQL? A 19‑Model Benchmark on a 200M‑Row GitHub Dataset

This article presents a comprehensive benchmark of 19 large language models (plus a human baseline) on generating analytical SQL queries over a 200 million‑row GitHub events dataset, detailing the methodology, metrics, results, and practical guidance for using LLMs in data analysis.

AILLMSQL

0 likes · 18 min read

Which LLM Generates the Best SQL? A 19‑Model Benchmark on a 200M‑Row GitHub Dataset

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 ViewsReal-Time Analytics

0 likes · 20 min read

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

java1234

Mar 10, 2026 · Backend Development

What’s the Difference Between MyBatis First‑Level and Second‑Level Caches?

This article explains the concepts, characteristics, default states, and usage patterns of MyBatis first‑level (SqlSession) and second‑level (Mapper) caches, provides Java code demos for each, and compares their scope, lifecycle, consistency, and suitable scenarios.

CacheJavaMyBatis

0 likes · 7 min read

What’s the Difference Between MyBatis First‑Level and Second‑Level Caches?

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.

PaginationSQLsharding

0 likes · 6 min read

How to Paginate Efficiently Across Sharded Databases Without OOM

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.

DatabaseMySQLPerformance Tuning

0 likes · 14 min read

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

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

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.

InterceptorJavaMyBatis

0 likes · 6 min read

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

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

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.

DataWorksSQLdata engineering

0 likes · 12 min read

How DataWorks Turns Data Quality Rules into Code with Data Contracts

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

Full-Stack Internet Architecture

Mar 4, 2026 · Databases

Why MySQL Ignores Trailing Spaces and How to Enforce Exact Matching

MySQL silently trims trailing spaces in string comparisons, causing queries with extra spaces or stored values with spaces to match unexpectedly, but using the BINARY keyword forces a strict byte‑by‑byte comparison to handle such cases.

MySQLSQLTrailing Spaces

0 likes · 5 min read

Why MySQL Ignores Trailing Spaces and How to Enforce Exact Matching

IT Services Circle

Mar 3, 2026 · Databases

Why Adding LIMIT 1 Can Slow Down MySQL Queries 50× and How to Fix It

A MySQL query that should return a single row became 50 times slower after adding LIMIT 1 because the optimizer chose a suboptimal index, and the article explains the root cause and three practical ways to resolve the issue.

LIMITMySQLSQL

0 likes · 7 min read

Why Adding LIMIT 1 Can Slow Down MySQL Queries 50× and How to Fix It

Java Companion

Mar 3, 2026 · Backend Development

Simplify MyBatis IN Clauses: Custom Extension Replaces foreach Template and Doubles SQL Writing Efficiency

The article analyzes the cumbersome MyBatis IN‑statement foreach template, explores three implementation paths, and presents a custom LanguageDriver that lets developers write simple "in #{param}" syntax, cutting XML boilerplate in half while generating correct SQL at runtime.

Custom ExtensionIN ClauseJava

0 likes · 13 min read

Simplify MyBatis IN Clauses: Custom Extension Replaces foreach Template and Doubles SQL Writing Efficiency

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.

ElasticsearchPaginationSQL

0 likes · 14 min read

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

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.

JavaMyBatisSQL

0 likes · 9 min read

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

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 SELECTIndexMySQL

0 likes · 8 min read

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

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 ManagementInnoDBMySQL

0 likes · 9 min read

Boost MySQL Performance: Deep Parameter Tuning to Eliminate Slowness

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

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.

MySQLSQLlarge tables

0 likes · 12 min read

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

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.

IndexingMySQLOptimization

0 likes · 20 min read

10 Must‑Know MySQL Advanced Techniques to Supercharge Performance

Senior Xiao Ying

Feb 12, 2026 · Databases

Where Does GROUP BY Fall Short? Using Window Functions to Bridge Advanced Data Analysis Gaps

This article reviews MySQL's GROUP BY fundamentals, highlights its limitations and execution order, then demonstrates how window functions—including ROW_NUMBER, RANK, DENSE_RANK, cumulative totals, moving averages, and TOP N techniques—can overcome those gaps for richer analytical queries.

GROUP BYMySQLSQL

0 likes · 11 min read

Where Does GROUP BY Fall Short? Using Window Functions to Bridge Advanced Data Analysis Gaps

Senior Xiao Ying

Feb 11, 2026 · Databases

Mastering Multi-Table Queries in MySQL: Joins, Subqueries, and Set Operations

This article explains MySQL join types, demonstrates inner, left, right, and self joins with sample tables, shows how to write subqueries (correlated and non‑correlated) and UNION/UNION ALL, compares their performance, and provides practical indexing and query‑writing tips.

JOINMySQLSQL

0 likes · 11 min read

Mastering Multi-Table Queries in MySQL: Joins, Subqueries, and Set Operations

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.

ElasticsearchPaginationSQL

0 likes · 12 min read

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

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

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

Smart Sea Tide

Feb 9, 2026 · Big Data

Practical Taobao User‑Behavior Analysis with AARRR and RFM Models

This article walks through a complete data‑driven study of Taobao app user actions, using SQL and Python to ingest 2 million records, applying the AARRR funnel and RFM segmentation to quantify churn, retention, conversion rates, and to propose data‑backed marketing tactics.

AARRRPythonRFM

0 likes · 25 min read

Practical Taobao User‑Behavior Analysis with AARRR and RFM Models

Coder Trainee

Feb 8, 2026 · Databases

How to Reverse Engineer Existing Database Tables into a PDM File with PowerDesigner

This guide walks through two methods for using PowerDesigner to reverse‑engineer existing database tables into a PDM file, detailing the recommended step‑by‑step UI workflow and an alternative approach that may not work across all versions.

PDMPowerDesignerReverse Engineering

0 likes · 3 min read

How to Reverse Engineer Existing Database Tables into a PDM File with PowerDesigner

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

Senior Xiao Ying

Feb 7, 2026 · Databases

The Most Comprehensive MySQL Installation & Configuration Guide: Hands‑On First Steps

This guide walks through installing MySQL on Windows, Linux and macOS, configuring security settings, creating the first database and tables, and demonstrates basic queries, updates and deletions with concrete command‑line examples.

ConfigurationDatabaseInstallation

0 likes · 10 min read

The Most Comprehensive MySQL Installation & Configuration Guide: Hands‑On First Steps

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

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 ProgrammingPythonSQL

0 likes · 25 min read

9 Underrated Python Libraries That Can Boost Your Development Speed Tenfold

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

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.

PaginationSQLinterview

0 likes · 7 min read

How to Handle Pagination Across Sharded Databases Without Performance Pitfalls

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.

EXPLAINSQLdatabase optimization

0 likes · 7 min read

Master MySQL EXPLAIN: Decode Execution Plans with Real Examples

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.

InnoDB ReplicaSetSQLdatabase configuration

0 likes · 6 min read

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

FunTester

Jan 21, 2026 · Databases

Mastering MySQL Upserts: INSERT IGNORE, REPLACE INTO, and ON DUPLICATE KEY UPDATE Explained

This article explains three MySQL INSERT variants—INSERT IGNORE, REPLACE INTO, and INSERT ... ON DUPLICATE KEY UPDATE—detailing their syntax, execution behavior, advantages, drawbacks, typical use cases, and practical comparison to help developers choose the most suitable method for handling duplicate or bulk data operations.

Duplicate KeyINSERTMySQL

0 likes · 12 min read

Mastering MySQL Upserts: INSERT IGNORE, REPLACE INTO, and ON DUPLICATE KEY UPDATE Explained

Big Data Tech Team

Jan 20, 2026 · Interview Experience

What ByteDance Asks: 3 Rounds of Data Warehouse Engineer Interview Questions

This article compiles the full set of first, second, and third‑round interview questions used by ByteDance for a data warehouse engineer role, covering topics such as window functions, data skew, shuffle mechanisms, data modeling, data quality, governance, and system design, along with interview duration and interviewer details.

ByteDanceSQLdata warehouse

0 likes · 5 min read

What ByteDance Asks: 3 Rounds of Data Warehouse Engineer Interview Questions

ITPUB

Jan 19, 2026 · Databases

Why IN/NOT IN Slow Down Queries and How to Replace Them

The article explains how using IN and NOT IN in SQL can dramatically hurt performance and produce incorrect results, especially with large tables or NULL values, and demonstrates safer alternatives such as EXISTS, NOT EXISTS, and JOIN with concrete code examples.

JOINNULLSQL

0 likes · 6 min read

Why IN/NOT IN Slow Down Queries and How to Replace Them

dbaplus Community

Jan 18, 2026 · Databases

Avoid These Common SQL Performance Pitfalls for Faster Queries

This guide enumerates frequent misconceptions in SQL performance—from over‑indexing and SELECT * misuse to improper transaction handling and outdated monitoring practices—explains why they hurt efficiency, and provides concrete, version‑aware solutions to optimize queries, schema design, and database operations.

DatabaseMySQLOptimization

0 likes · 26 min read

Avoid These Common SQL Performance Pitfalls for Faster Queries

Top Architect

Jan 18, 2026 · Databases

Boost Your SQL Query Speed: Proven Optimization Techniques

This guide walks through the SQL query processing workflow, explains how parsing, optimization, and execution plans affect performance, and provides concrete techniques—such as selecting specific columns, avoiding DISTINCT, using proper indexes, preferring EXISTS over COUNT, limiting result sets, and replacing HAVING with WHERE—to dramatically speed up queries while keeping statements concise.

Database PerformanceQuery OptimizationSQL

0 likes · 8 min read

Boost Your SQL Query Speed: Proven Optimization Techniques

Ray's Galactic Tech

Jan 17, 2026 · Databases

Master MySQL Index Execution: From Index Key to Table Filter

This guide explains how MySQL processes queries in three index‑related stages—Index Key, Index Filter, and Table Filter—showing why keeping operations in the index layer dramatically improves performance and how to design and diagnose indexes effectively.

Covering IndexDatabase PerformanceMySQL

0 likes · 9 min read

Master MySQL Index Execution: From Index Key to Table Filter

IT Services Circle

Jan 17, 2026 · Backend Development

Kuaishou Campus Salary Insights & Java Backend Interview Guide

The article reveals that Kuaishou’s 2023 campus hires for backend and frontend roles typically earn 40‑50 wan yuan annually, discusses salary trends compared with previous years, and then provides a comprehensive Java backend interview guide covering JVM memory, garbage collectors, CMS GC process, concurrency primitives, and SQL join differences.

GCJVMJava

0 likes · 15 min read

Kuaishou Campus Salary Insights & Java Backend Interview Guide

Go Development Architecture Practice

Jan 17, 2026 · Databases

What New SQL Features Did SQLite Add in 2018?

This article reviews SQLite's 2018 enhancements, covering boolean literals, window functions, the FILTER clause, upsert syntax, column‑renaming support, and related API changes, while also noting the remaining limitations compared with other major database systems.

Boolean LiteralsDatabase FeaturesSQL

0 likes · 10 min read

What New SQL Features Did SQLite Add in 2018?

SpringMeng

Jan 16, 2026 · Backend Development

What Unexpected Pitfalls PageHelper Can Teach You After Years of Use

The article recounts a developer’s painful experience with PageHelper, detailing how duplicate registrations, truncated result sets, and password‑update errors stem from the plugin’s ThreadLocal pagination handling, and explains the underlying code paths and safe usage practices.

JavaMyBatisPagination

0 likes · 13 min read

What Unexpected Pitfalls PageHelper Can Teach You After Years of Use

Architect's Guide

Jan 16, 2026 · Databases

How to Safely Update Billions of MySQL Rows Without Overloading Binlog

This article explains why a naïve full‑table UPDATE on massive MySQL tables can cripple replication, explores deep‑pagination and IN‑clause inefficiencies, and presents a batch‑processing strategy using NO_CACHE, FORCE INDEX, and rate‑controlled scripts to perform safe, high‑performance updates.

Batch ProcessingFull Table UpdateMySQL

0 likes · 8 min read

How to Safely Update Billions of MySQL Rows Without Overloading Binlog

ITPUB

Jan 15, 2026 · Databases

How to Migrate ClickHouse Data to Doris: Three Practical Strategies Tested

Facing a ClickHouse cluster shutdown, the author explores three migration methods—using Doris’s ClickHouse catalog, exporting to files with Broker/Stream Load, and Spark—to transfer ~10 billion rows to Doris, evaluating each for simplicity, bugs, and performance, and sharing detailed steps, code snippets, and benchmark results.

ClickHouseData MigrationDoris

0 likes · 9 min read

How to Migrate ClickHouse Data to Doris: Three Practical Strategies Tested

macrozheng

Jan 15, 2026 · Databases

Master MySQL Full-Text Search: Inverted Index, Queries, and Best Practices

This guide explains why InnoDB fuzzy queries lose indexes, introduces MySQL full‑text search with inverted indexes, shows how to create and use full‑text indexes via CREATE TABLE and ALTER statements, and demonstrates natural language, boolean, and query‑expansion modes with practical SQL examples.

Boolean ModeDatabaseFull-text Search

0 likes · 12 min read

Master MySQL Full-Text Search: Inverted Index, Queries, and Best Practices

Full-Stack DevOps & Kubernetes

Jan 15, 2026 · Operations

How a GC, Thread Pool, and Slow SQL Combo Crippled a Java Service – Deep Postmortem & Fixes

A real‑world production incident where GC pauses, thread‑pool exhaustion, and slow SQL combined to drop QPS from 3000 to 1400 and inflate response times from 200 ms to over 2 s, with detailed analysis, diagnostic criteria, and step‑by‑step optimizations that restored performance.

GCJavaSQL

0 likes · 9 min read

How a GC, Thread Pool, and Slow SQL Combo Crippled a Java Service – Deep Postmortem & Fixes

Architecture Digest

Jan 14, 2026 · Backend Development

Why IntelliJ IDEA 2025.3.1’s ‘Rollback’ Fix Is a Game‑Changer for Java Developers

IntelliJ IDEA 2025.3.1 rolls back a controversial Query Console change, fixes over 200 bugs—including SQL workflow, WSL‑Gradle issues, Spring stack problems, and terminal glitches—making it a critical update for Java, Spring, and full‑stack developers seeking a more stable IDE experience.

IntelliJ IDEAJavaSQL

0 likes · 6 min read

Why IntelliJ IDEA 2025.3.1’s ‘Rollback’ Fix Is a Game‑Changer for Java Developers

Aikesheng Open Source Community

Jan 14, 2026 · Artificial Intelligence

NL2SQL Datasets REEF & text2SQL4PM: Causal Analysis Meets Process Mining

This article introduces two recent NL2SQL benchmark datasets—REEF, a synthetic e‑commerce database for end‑to‑end causal analysis, and text2SQL4PM, a bilingual process‑mining dataset—detailing their construction, evaluation results, and research implications for large language models.

Causal AnalysisLLMNL2SQL

0 likes · 8 min read

NL2SQL Datasets REEF & text2SQL4PM: Causal Analysis Meets Process Mining

Java Architect Handbook

Jan 13, 2026 · Databases

When to Normalize or Denormalize? A Deep Dive for Java Interview Prep

This article breaks down the interview expectations around database normalization, explains the theory and trade‑offs of normalization versus denormalization, provides SQL code examples, compares design impacts, offers best‑practice guidelines, and warns against common misconceptions.

DenormalizationSQLdatabase-design

0 likes · 11 min read

When to Normalize or Denormalize? A Deep Dive for Java Interview Prep

360 Zhihui Cloud Developer

Jan 13, 2026 · Databases

Turn PostgreSQL into a Graph Database with Apache AGE

This guide explains how Apache AGE extends PostgreSQL with OpenCypher‑compatible graph capabilities, covering architecture, installation, storage schema, Cypher‑SQL integration, common graph operations, and a LangChain example that turns natural‑language questions into executable graph queries.

Apache AGECypherGraph Database

0 likes · 11 min read

Turn PostgreSQL into a Graph Database with Apache AGE

Big Data Tech Team

Jan 12, 2026 · Fundamentals

Why Wide Tables Are Essential in DWS Layer: 10 Real-World Modeling Scenarios

This article explains the purpose of the DWS (Data Warehouse Service) layer, why wide‑table modeling is crucial for performance and service‑oriented interfaces, and provides ten practical wide‑table designs with core field definitions, CREATE TABLE statements, and sample INSERT queries for common business domains such as products, users, orders, regions, channels, suppliers, services, finance, logistics, and data quality monitoring.

AnalyticsETLSQL

0 likes · 34 min read

Why Wide Tables Are Essential in DWS Layer: 10 Real-World Modeling Scenarios

Architect's Tech Stack

Jan 12, 2026 · Databases

Why SELECT * Slows Down MySQL and How to Write Faster Queries

Using SELECT * in MySQL queries increases disk I/O, inflates network traffic, and prevents the optimizer from using covering indexes, leading to slower performance and unnecessary resource consumption.

IndexingMySQLSELECT

0 likes · 5 min read

Why SELECT * Slows Down MySQL and How to Write Faster Queries

Ray's Galactic Tech

Jan 8, 2026 · Databases

Boost SQL Performance Without Rewriting Queries: Indexes, Partitioning, Caching

This guide presents a comprehensive, step‑by‑step roadmap for accelerating slow SQL queries without altering the original statements, covering index creation, database parameter tuning, table partitioning, caching layers, read‑write splitting, sharding, statistics updates, hardware choices, and middleware routing.

SQLcachingdatabase tuning

0 likes · 8 min read

Boost SQL Performance Without Rewriting Queries: Indexes, Partitioning, Caching

Volcano Engine Developer Services

Jan 8, 2026 · Databases

How VeDB Accelerates Fault Diagnosis with AI‑Powered RCA and Full‑SQL Insight

VeDB, ByteDance's cloud‑native distributed database, combines a four‑layer monitoring architecture, AI‑driven root‑cause analysis, full‑SQL insight, and second‑level metric collection to dramatically shorten MTTR, improve reliability, and support massive, high‑concurrency workloads across diverse production scenarios.

AIRCASQL

0 likes · 18 min read

How VeDB Accelerates Fault Diagnosis with AI‑Powered RCA and Full‑SQL Insight

Smart Sea Tide

Jan 8, 2026 · Databases

How count(1), count(*) and count(column) Differ in Execution

The article explains that count(1) and count(*) produce identical results and similar execution plans, while count(column) skips NULL values; it also compares their performance under various table schemas and provides a MySQL example demonstrating these differences.

COUNTDatabaseMySQL

0 likes · 4 min read

How count(1), count(*) and count(column) Differ in Execution

Full-Stack Internet Architecture

Jan 8, 2026 · Databases

Understanding MySQL Transaction Isolation Levels with Practical Examples

This article explains MySQL's four transaction isolation levels—Read Uncommitted, Read Committed, Repeatable Read, and Serializable—by creating a simple table, running paired transactions, and showing how each level affects data visibility, concurrency, and potential anomalies such as dirty reads, non‑repeatable reads, and phantom reads.

Database ConcurrencyInnoDBMySQL

0 likes · 10 min read

Understanding MySQL Transaction Isolation Levels with Practical Examples

Java Architect Handbook

Jan 7, 2026 · Databases

When to Use DELETE, TRUNCATE, or DROP? A Deep Dive for Java Interviews

This article explains the fundamental differences between DELETE, TRUNCATE, and DROP, covering interview expectations, underlying mechanisms, performance impacts, transaction safety, best‑practice usage scenarios, and common pitfalls to help candidates choose the right command for any database task.

DELETEDROPDatabase

0 likes · 9 min read

When to Use DELETE, TRUNCATE, or DROP? A Deep Dive for Java Interviews

SpringMeng

Jan 7, 2026 · Interview Experience

Inside Xiao Meng’s Technical Interview: Real Questions and Insights

The article shares Xiao Meng’s full‑stack hiring process, listing practical first‑ and second‑round interview questions—from SQL pagination and SpringBoot CORS to RPC frameworks and AI‑assisted coding—while explaining the company’s focus on hands‑on ability and recent AI tool adoption.

AI coding toolsJavaSQL

0 likes · 6 min read

Inside Xiao Meng’s Technical Interview: Real Questions and Insights

Efficient Ops

Jan 6, 2026 · Databases

Why PostgreSQL Beats MySQL: 10 Technical Advantages Explained

This article compiles a detailed comparison of PostgreSQL and MySQL, highlighting PostgreSQL's lack of text‑size limits, better NULL handling, native array and JSON support, built‑in optimistic locking, superior GIS types, MVCC, flexible indexing, robust replication, and overall stability, while also noting the few areas where MySQL still holds an edge.

Database ComparisonGISJSONB

0 likes · 9 min read

Why PostgreSQL Beats MySQL: 10 Technical Advantages Explained

Woodpecker Software Testing

Jan 6, 2026 · Backend Development

How ChatGPT Analyzes and Optimizes Application Performance

The article shows how ChatGPT examines JMeter load‑test results, identifies CPU, database and I/O bottlenecks, and then proposes concrete optimizations such as adding indexes, tuning HikariCP pool settings, caching, code refactoring, and monitoring to improve login throughput and latency.

ChatGPTHikariCPJava

0 likes · 11 min read

How ChatGPT Analyzes and Optimizes Application Performance

Smart Sea Tide

Jan 6, 2026 · Databases

Practical Guide to Building the DWD Layer in a Data Warehouse

This article walks through the DWD (Data Warehouse Detail) layer design, explaining its purpose, the four-step modeling process, and detailed implementations of transactional, periodic snapshot, and cumulative snapshot fact tables with Hive SQL examples and schema definitions.

DWDFact TableHive

0 likes · 15 min read

Practical Guide to Building the DWD Layer in a Data Warehouse

Mike Chen's Internet Architecture

Jan 3, 2026 · Databases

Master MySQL: Essential Commands for Databases, Tables, and Operations

This guide presents a comprehensive collection of MySQL commands covering database management, table creation and alteration, CRUD operations, index handling, transaction control, and essential administration queries, providing clear examples for each task.

CRUDDatabase CommandsMySQL

0 likes · 4 min read

Master MySQL: Essential Commands for Databases, Tables, and Operations

Mike Chen's Internet Architecture

Jan 3, 2026 · Databases

Essential MySQL Commands Every DBA Should Know

This guide presents a comprehensive collection of essential MySQL commands, covering connection management, database creation and selection, table definition and alteration, CRUD operations, query optimization techniques, performance monitoring, and user permission handling, providing clear examples for each command.

AdministrationDatabaseMySQL

0 likes · 7 min read

Essential MySQL Commands Every DBA Should Know

Java Architect Handbook

Jan 3, 2026 · Databases

When Should You Avoid JOINs in High‑Concurrency Systems?

The article analyzes a common Java interview question about using JOINs, explaining performance bottlenecks, scalability issues in distributed and micro‑service architectures, and offers practical guidelines and best‑practice alternatives for handling data associations efficiently.

Database PerformanceJOINSQL

0 likes · 9 min read

When Should You Avoid JOINs in High‑Concurrency Systems?

Ray's Galactic Tech

Jan 2, 2026 · Databases

How to Choose the Right PostgreSQL Isolation Level and Avoid Concurrency Bugs

PostgreSQL offers four transaction isolation levels—READ UNCOMMITTED, READ COMMITTED, REPEATABLE READ, and SERIALIZABLE—each preventing specific concurrency anomalies like dirty reads, non‑repeatable reads, and phantom reads, and the article explains their behavior, configuration commands, practical usage, performance trade‑offs, and production best practices.

PostgreSQLSQLTransaction Isolation

0 likes · 9 min read

How to Choose the Right PostgreSQL Isolation Level and Avoid Concurrency Bugs

Java Architect Handbook

Jan 1, 2026 · Databases

COUNT(*), COUNT(1) or COUNT(column) in MySQL? Deep Interview Guide

This article explains the semantic differences, performance characteristics, and optimal usage scenarios of COUNT(*), COUNT(1), and COUNT(column) in MySQL 8.0+, covering engine behavior, indexing effects, common misconceptions, and practical best‑practice recommendations for interview preparation and real‑world development.

COUNTMySQLSQL

0 likes · 10 min read

COUNT(*), COUNT(1) or COUNT(column) in MySQL? Deep Interview Guide

Xiao Liu Lab

Dec 30, 2025 · Databases

How to Diagnose and Fix ClickHouse CPU Spikes in Minutes

This guide walks you through a step‑by‑step process for quickly identifying the cause of high CPU usage in ClickHouse, from emergency triage and precise diagnosis using system tables to practical optimization techniques and a ready‑to‑run monitoring script.

CPUClickHouseSQL

0 likes · 21 min read

How to Diagnose and Fix ClickHouse CPU Spikes in Minutes

Alibaba Cloud Native

Dec 30, 2025 · Cloud Native

How Materialized Views Cut Log Query Times from Seconds to Milliseconds

Backend developers often struggle with log queries that become unbearably slow at scale, causing timeouts and alerts; this article details how applying Alibaba Cloud Log Service materialized views transformed several real‑world cases—from high‑concurrency SDK calls to complex de‑duplication and latency‑comparison queries—cutting response times from seconds to milliseconds and delivering stable performance.

SQLcloud-nativelog query

0 likes · 7 min read

How Materialized Views Cut Log Query Times from Seconds to Milliseconds

Aikesheng Open Source Community

Dec 30, 2025 · Databases

Year-in-Review: Open-Source SQL LLM Benchmark, SQLE Updates, and Top DB Articles

This community roundup reviews the 2025 release of the SCALE open‑source LLM‑SQL benchmark, SQLE platform updates, curated video playlists, a curated list of the year's ten best database articles, and provides reference links for further exploration.

DatabaseLLMOpenSource

0 likes · 10 min read

Year-in-Review: Open-Source SQL LLM Benchmark, SQLE Updates, and Top DB Articles

Ops Community

Dec 29, 2025 · Databases

Recover Accidentally Deleted MySQL Data: Binlog, Backups, and Third‑Party Tools

This guide explains how to restore lost MySQL data after accidental DELETE operations by using binary log replay, logical and physical backups, third‑party recovery utilities, and preventive measures such as proper binlog configuration, backup strategies, and permission controls.

Data RecoveryMySQLPercona

0 likes · 21 min read

Recover Accidentally Deleted MySQL Data: Binlog, Backups, and Third‑Party Tools

Top Architect

Dec 29, 2025 · Databases

Why Top Companies Prefer PostgreSQL Over MySQL: A Deep Technical Comparison

The article examines why leading Chinese tech firms are increasingly adopting PostgreSQL instead of MySQL, detailing PostgreSQL‑based products, comparing data‑type support, sequence handling, extensions, monitoring tools, replication mechanisms, licensing, community openness, and MVCC implementation, while also outlining MySQL's limitations.

Database ComparisonMySQLPostgreSQL

0 likes · 11 min read

Why Top Companies Prefer PostgreSQL Over MySQL: A Deep Technical Comparison

dbaplus Community

Dec 28, 2025 · Databases

How Treating Your Database as a Compute Engine Boosted Dashboard Speed 166×

The article explains why teams mistakenly use databases merely as storage, shows a real‑world Node.js dashboard that suffered severe latency, demonstrates how moving aggregation and filtering into SQL queries eliminated N+1 and filtering issues, and presents dramatic performance gains and best‑practice guidelines.

Node.jsORMQuery Optimization

0 likes · 17 min read

How Treating Your Database as a Compute Engine Boosted Dashboard Speed 166×

Big Data Tech Team

Dec 28, 2025 · Big Data

When to Use Hive Partitioning vs Bucketing: A Practical Guide

This article explains Hive's partitioning and bucketing techniques, compares their purposes, advantages, and pitfalls, and shows how to combine them with concrete SQL examples to improve query performance, reduce I/O, and optimize joins and sampling in large data warehouses.

BucketingHiveSQL

0 likes · 7 min read

When to Use Hive Partitioning vs Bucketing: A Practical Guide

ITPUB

Dec 26, 2025 · Databases

How to Migrate 100 Billion ClickHouse Rows to Doris: Three Practical Strategies

When a ClickHouse cluster needed to be decommissioned, the author evaluated three migration approaches—using Doris' ClickHouse catalog, exporting to files with Broker/Stream Load, and leveraging Spark—to move roughly 100 billion rows to Doris, comparing their complexity, reliability, and performance.

CatalogClickHouseDoris

0 likes · 9 min read

How to Migrate 100 Billion ClickHouse Rows to Doris: Three Practical Strategies

Smart Sea Tide

Dec 25, 2025 · Databases

10 Classic SQL Interview Questions with Solutions

This article presents ten classic SQL interview questions ranging from simple GROUP BY and LIMIT usage to complex window functions and session generation, each accompanied by detailed problem statements, reasoning steps, and complete query solutions for data extraction and analysis.

DatabaseInterview QuestionsQuery Writing

0 likes · 14 min read

10 Classic SQL Interview Questions with Solutions

Linux Tech Enthusiast

Dec 25, 2025 · Databases

10 Advanced SQL Query Techniques Every Data Professional Should Master

This article presents ten advanced SQL concepts—including CTEs, recursive CTEs, temporary functions, CASE‑WHEN pivots, EXCEPT vs NOT IN, self‑joins, ranking window functions, delta calculations, cumulative sums, and date‑time manipulation—each explained with concrete examples and code snippets.

CTEData PivotRanking Functions

0 likes · 11 min read

10 Advanced SQL Query Techniques Every Data Professional Should Master

Advanced AI Application Practice

Dec 23, 2025 · Databases

Why Did This Single SQL Update the Entire Table Without Error in MySQL?

A developer wrote an UPDATE statement that unintentionally used AND inside the SET clause and omitted a WHERE clause, causing MySQL to silently update every row in the table without raising any syntax errors.

MySQLSET clauseSQL

0 likes · 3 min read

Why Did This Single SQL Update the Entire Table Without Error in MySQL?

Full-Stack Internet Architecture

Dec 23, 2025 · Databases

Master MySQL Joins: Visual Guide to INNER, LEFT, RIGHT, and FULL OUTER

This tutorial walks through MySQL table joins—INNER, LEFT, RIGHT, and FULL OUTER—using clear diagrams, step‑by‑step SQL examples, and sample data, helping readers understand each join type, its result set, and how to emulate full outer joins in MySQL 5.7.

DatabaseInner JoinJOIN

0 likes · 9 min read

Master MySQL Joins: Visual Guide to INNER, LEFT, RIGHT, and FULL OUTER

JD Tech

Dec 18, 2025 · Backend Development

Can AI Prompts Supercharge Your Backend, Frontend, and Big Data Projects?

This article showcases a series of real‑world development cases—from implementing a guided inventory task in a Java backend and generating Vue rule code, to writing unit tests, analyzing report data, converting SQL to Hive, debugging startup errors, publishing Maven APIs, optimizing slow SQL queries, and resolving MySQL deadlocks—demonstrating how AI‑driven prompts can accelerate coding, testing, and troubleshooting across multiple domains.

DebuggingMavenSQL

0 likes · 31 min read

Can AI Prompts Supercharge Your Backend, Frontend, and Big Data Projects?

Smart Sea Tide

Dec 18, 2025 · Databases

ClickHouse Performance Test on a 600‑Million‑Row Table

This article records a ClickHouse performance benchmark on a single‑node 20.8.11.17 deployment with a 600 million‑row star‑schema table, detailing server specs, data compression, and the execution time, rows processed, and result size of multiple analytical queries, highlighting first‑run latency of about 8 seconds and sub‑second speeds on repeated runs.

ClickHouseLarge DatasetSQL

0 likes · 10 min read

ClickHouse Performance Test on a 600‑Million‑Row Table

dbaplus Community

Dec 16, 2025 · Databases

83 Proven SQL Optimization Techniques to Supercharge Your Database

This comprehensive guide presents 83 practical SQL optimization scenarios—from avoiding SELECT * and replacing IN with EXISTS to leveraging materialized views, partitioning, and advanced indexing—each illustrated with real‑world use cases and exact code snippets to help developers dramatically improve query performance and reduce resource consumption.

Performance TuningQuery OptimizationSQL

0 likes · 55 min read

83 Proven SQL Optimization Techniques to Supercharge Your Database

Woodpecker Software Testing

Dec 16, 2025 · Backend Development

Generating Password Recovery Backend Code with ChatGPT

This article walks through building a complete password‑recovery feature for a Java web application, detailing the workflow, database schema, validation logic, JSP integration, controller design, and optional email/SMS notification code generated by ChatGPT.

JSPJavaPassword Recovery

0 likes · 37 min read

Generating Password Recovery Backend Code with ChatGPT

Ray's Galactic Tech

Dec 16, 2025 · Databases

PostgreSQL vs MySQL: The Ultimate Production-Ready Database Selection Guide

Choosing between PostgreSQL and MySQL isn’t just a feature checklist; it requires weighing business complexity, team expertise, and future uncertainty, with this guide offering core design philosophies, multi-dimensional capability comparisons, actionable decision paths, and real-world case studies to help you make a production-grade database choice.

GISMySQLPostgreSQL

0 likes · 12 min read

PostgreSQL vs MySQL: The Ultimate Production-Ready Database Selection Guide

Ray's Galactic Tech

Dec 15, 2025 · Databases

10 Advanced MySQL Techniques to Write Faster, Cleaner SQL

Discover ten powerful MySQL features—including CTEs, window functions, conditional aggregation, JSON handling, generated columns, and UPSERT tricks—illustrated with real‑world examples and performance tips, so you can write SQL that is more efficient, maintainable, and production‑ready.

CTEGenerated ColumnsMySQL

0 likes · 15 min read

10 Advanced MySQL Techniques to Write Faster, Cleaner SQL

Senior Tony

Dec 15, 2025 · Databases

Avoid the 5 Hidden MySQL Pitfalls That Can Kill Your Performance

This article reveals five common MySQL pitfalls—including uncontrolled InnoDB lock granularity, low default IOPS, misleading VARCHAR length handling, undersized InnoDB Buffer Pool, and a fragile Buffer Pool LRU algorithm—and offers practical configuration tips to prevent performance degradation.

InnoDBMySQLPerformance Tuning

0 likes · 6 min read

Avoid the 5 Hidden MySQL Pitfalls That Can Kill Your Performance

Lobster Programming

Dec 15, 2025 · Backend Development

5 Ways to Implement Pagination in MyBatis: From Manual SQL to PageHelper

This article compares five MyBatis pagination techniques—including raw LIMIT SQL, RowBounds, custom window‑function queries, interceptor‑based pagination, and the PageHelper plugin—explaining their principles, code examples, performance trade‑offs, and ideal usage scenarios.

JavaMyBatisRowBounds

0 likes · 6 min read

5 Ways to Implement Pagination in MyBatis: From Manual SQL to PageHelper

Spring Full-Stack Practical Cases

Dec 15, 2025 · Backend Development

5 Efficient Ways to Check Record Existence in Spring Boot 3

This article compares five practical techniques—custom findBy, Query‑by‑Example, existsBy, COUNT aggregation, and native CASE WHEN EXISTS SQL—to determine whether a database record exists in Spring Boot 3.5.0, providing code examples, generated SQL, performance notes, and recommendations for each approach.

JPAQuery by ExampleSQL

0 likes · 9 min read

5 Efficient Ways to Check Record Existence in Spring Boot 3

Aikesheng Open Source Community

Dec 10, 2025 · Databases

Why OceanBase DDL Expansion Can Crash Your Service and How to Fix It

A production migration from Oracle to OceanBase caused a column‑length change to trigger offline DDL, leading to connection errors, INSERT latency spikes, and complete table blockage; the article reproduces the fault, analyzes the OMS conversion and OceanBase DDL rules, and provides a two‑step remediation and a method to verify online DDL execution.

DDLDatabase MigrationOceanBase

0 likes · 11 min read

Why OceanBase DDL Expansion Can Crash Your Service and How to Fix It

Big Data Technology & Architecture

Dec 10, 2025 · Big Data

What’s New in Apache Spark 4.0? Deep Dive into 2025 Core Updates

The 2025 release of Apache Spark 4.0 brings a comprehensive overhaul—including default ANSI SQL mode, full SQL scripting support, a new Real‑Time streaming mode, adaptive query execution, dynamic memory management, and GPU‑accelerated MLlib—significantly boosting performance, reliability, and developer productivity across big‑data workloads.

Apache SparkBig DataGPU Acceleration

0 likes · 9 min read

What’s New in Apache Spark 4.0? Deep Dive into 2025 Core Updates

Raymond Ops

Dec 9, 2025 · Databases

Deep Dive into MySQL Architecture, SQL Syntax, and Performance Tuning

This comprehensive guide explores MySQL’s layered architecture, core components, storage engines, and detailed SQL language structures, while providing practical commands, optimization techniques, security best practices, and operational procedures for administrators to efficiently manage, tune, and secure MySQL databases.

DatabaseMySQLSQL

0 likes · 31 min read

Deep Dive into MySQL Architecture, SQL Syntax, and Performance Tuning

macrozheng

Dec 8, 2025 · Databases

Why LIMIT Pagination Slows Down on Large Tables and How to Optimize It

This tutorial demonstrates how MySQL LIMIT pagination performs on tables with millions of rows, measures query times for various offsets and batch sizes, and presents practical optimization techniques such as sub‑queries, ID‑range filtering, and column selection to improve speed.

LIMITMySQLOptimization

0 likes · 9 min read

Why LIMIT Pagination Slows Down on Large Tables and How to Optimize It

Aikesheng Open Source Community

Dec 4, 2025 · Artificial Intelligence

Gemini 3 Pro vs DeepSeek‑V3.2‑Exp: Which LLM Dominates SQL Understanding, Optimization, and Dialect Conversion?

This report evaluates the professional‑grade LLMs Gemini 3 Pro and DeepSeek‑V3.2‑Exp on three SQL‑related dimensions—understanding, optimization, and dialect conversion—using the SCALE benchmark, presenting detailed scores, strengths, weaknesses, and practical recommendations for database engineers and decision makers.

DatabaseDeepSeekGemini

0 likes · 16 min read

Gemini 3 Pro vs DeepSeek‑V3.2‑Exp: Which LLM Dominates SQL Understanding, Optimization, and Dialect Conversion?

Senior Brother's Insights

Dec 3, 2025 · Databases

Can MySQL Partition Tables Work When created_at Is NULL? Understanding Default Timestamp Partitioning

This article explains why MySQL partitions based on a timestamp column still function correctly even when the application does not explicitly set the column, by detailing the default CURRENT_TIMESTAMP behavior, partition key evaluation, and practical examples with table definitions and insert statements.

DEFAULT CURRENT_TIMESTAMPMySQLSQL

0 likes · 6 min read

Can MySQL Partition Tables Work When created_at Is NULL? Understanding Default Timestamp Partitioning

JD Tech Talk

Dec 3, 2025 · Databases

How DongSQL’s Syntax Extensions and Concurrency Controls Supercharge E‑commerce Performance

This article provides an in‑depth technical analysis of DongSQL’s kernel redesign—including RETURNING clause, Inventory Hint, CCL concurrency control, Statement Outline, and thread‑pool optimizations—showing how each feature dramatically improves throughput and latency for high‑traffic e‑commerce workloads.

Concurrency ControlSQLdatabases

0 likes · 12 min read

How DongSQL’s Syntax Extensions and Concurrency Controls Supercharge E‑commerce Performance

JD Cloud Developers

Dec 3, 2025 · Databases

How DongSQL’s Syntax Extensions and Concurrency Controls Supercharge E‑commerce Performance

The article details DongSQL’s kernel redesign—including RETURNING clause, Hint syntax, CCL concurrency control, statement outlines, and thread‑pool optimizations—showing concrete performance gains in high‑concurrency e‑commerce scenarios.

Concurrency ControlDatabase EngineDongSQL

0 likes · 11 min read