BestHub
Sign in
Tagged articles

SQL

2820 articles · Page 2 of 29
FunTester
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
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.

ByteDanceData WarehouseSQL
0 likes · 5 min read
What ByteDance Asks: 3 Rounds of Data Warehouse Engineer Interview Questions
ITPUB
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.

EXISTSINJOIN
0 likes · 6 min read
Why IN/NOT IN Slow Down Queries and How to Replace Them
dbaplus Community
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.

MySQLOptimizationPerformance
0 likes · 26 min read
Avoid These Common SQL Performance Pitfalls for Faster Queries
Top Architect
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 PerformanceIndexesQuery Optimization
0 likes · 8 min read
Boost Your SQL Query Speed: Proven Optimization Techniques
Ray's Galactic Tech
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 PerformanceIndex Optimization
0 likes · 9 min read
Master MySQL Index Execution: From Index Key to Table Filter
IT Services Circle
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
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
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.

JavaMyBatisSQL
0 likes · 13 min read
What Unexpected Pitfalls PageHelper Can Teach You After Years of Use
Architect's Guide
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.

BinlogFull Table UpdateMySQL
0 likes · 8 min read
How to Safely Update Billions of MySQL Rows Without Overloading Binlog
ITPUB
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
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 ModeFull-Text SearchMySQL
0 likes · 12 min read
Master MySQL Full-Text Search: Inverted Index, Queries, and Best Practices
Java Architect Handbook
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.

Database DesignDenormalizationSQL
0 likes · 11 min read
When to Normalize or Denormalize? A Deep Dive for Java Interview Prep
360 Zhihui Cloud Developer
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 AGECypherLangChain
0 likes · 11 min read
Turn PostgreSQL into a Graph Database with Apache AGE
Big Data Tech Team
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
Ray's Galactic Tech
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.

CachingDatabase TuningIndexes
0 likes · 8 min read
Boost SQL Performance Without Rewriting Queries: Indexes, Partitioning, Caching
Volcano Engine Developer Services
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
Full-Stack Internet Architecture
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
SpringMeng
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
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
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.

ChatGPTHikariCPJMeter
0 likes · 11 min read
How ChatGPT Analyzes and Optimizes Application Performance
Mike Chen's Internet Architecture
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.

AdministrationCommandsMySQL
0 likes · 7 min read
Essential MySQL Commands Every DBA Should Know
Java Architect Handbook
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
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
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.

COUNTMySQLPerformance
0 likes · 10 min read
COUNT(*), COUNT(1) or COUNT(column) in MySQL? Deep Interview Guide
Xiao Liu Lab
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.

CPUClickHousePerformance
0 likes · 21 min read
How to Diagnose and Fix ClickHouse CPU Spikes in Minutes
Alibaba Cloud Native
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
Top Architect
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
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.

DatabasesNode.jsORM
0 likes · 17 min read
How Treating Your Database as a Compute Engine Boosted Dashboard Speed 166×
Big Data Tech Team
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.

BucketingData WarehouseHive
0 likes · 7 min read
When to Use Hive Partitioning vs Bucketing: A Practical Guide
ITPUB
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
Linux Tech Enthusiast
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
JD Tech
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.

FrontendSQLbackend
0 likes · 31 min read
Can AI Prompts Supercharge Your Backend, Frontend, and Big Data Projects?
dbaplus Community
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.

IndexesPerformance TuningQuery Optimization
0 likes · 55 min read
83 Proven SQL Optimization Techniques to Supercharge Your Database
Woodpecker Software Testing
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.

EmailJSPJava
0 likes · 37 min read
Generating Password Recovery Backend Code with ChatGPT
Ray's Galactic Tech
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.

GISMySQLPerformance
0 likes · 12 min read
PostgreSQL vs MySQL: The Ultimate Production-Ready Database Selection Guide
Ray's Galactic Tech
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
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
Spring Full-Stack Practical Cases
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.

Query by ExampleSQLSpring Boot
0 likes · 9 min read
5 Efficient Ways to Check Record Existence in Spring Boot 3
Aikesheng Open Source Community
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.

DDLOceanBaseOffline DDL
0 likes · 11 min read
Why OceanBase DDL Expansion Can Crash Your Service and How to Fix It
Big Data Technology & Architecture
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
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.

MySQLOperationsPerformance
0 likes · 31 min read
Deep Dive into MySQL Architecture, SQL Syntax, and Performance Tuning
macrozheng
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
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.

DeepSeekGeminiLLM
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
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_TIMESTAMPMySQLPartitioning
0 likes · 6 min read
Can MySQL Partition Tables Work When created_at Is NULL? Understanding Default Timestamp Partitioning
JD Tech Talk
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 ControlDatabasesSQL
0 likes · 12 min read
How DongSQL’s Syntax Extensions and Concurrency Controls Supercharge E‑commerce Performance
Top Architect
Top Architect
Dec 2, 2025 · Databases

30 Essential SQL Query Optimization Tips from a Senior Architect

This article compiles thirty practical SQL performance tips, covering index usage, avoiding full table scans, proper handling of NULLs, OR/IN clauses, functions, temporary tables, cursors, and transaction size, each illustrated with clear example queries and recommended rewrites.

IndexesQuery OptimizationSQL
0 likes · 12 min read
30 Essential SQL Query Optimization Tips from a Senior Architect
Java Tech Enthusiast
Java Tech Enthusiast
Dec 1, 2025 · Databases

Master MySQL Full‑Text Search: Inverted Index, Query Modes, and Practical Examples

This guide explains how InnoDB implements full‑text search with inverted indexes, shows how to create and drop full‑text indexes, demonstrates MATCH() AGAINST() syntax across natural language, boolean, and query‑expansion modes, and covers relevance scoring, stopwords, token size limits, and real‑world query examples.

Full-Text SearchInnoDBMySQL
0 likes · 14 min read
Master MySQL Full‑Text Search: Inverted Index, Query Modes, and Practical Examples
Ray's Galactic Tech
Ray's Galactic Tech
Nov 27, 2025 · Databases

Why Implicit Type Conversion Breaks Indexes and How to Fix It

This article explains how implicit type conversion can silently invalidate database indexes, outlines the underlying rules and type‑precedence logic, provides real‑world MySQL examples, shows how to detect the issue with EXPLAIN, and offers concrete best‑practice solutions.

Index OptimizationMySQLPerformance
0 likes · 10 min read
Why Implicit Type Conversion Breaks Indexes and How to Fix It
Su San Talks Tech
Su San Talks Tech
Nov 26, 2025 · Databases

Master Database Indexes: 10 Essential Questions and Best Practices

This guide explores the fundamentals of database indexing, answering ten common questions about index design, performance pitfalls, composite indexes, covering indexes, NULL handling, and maintenance, while providing practical SQL examples, B+‑tree concepts, and best‑practice recommendations for MySQL and PostgreSQL.

B+TreeIndexingMySQL
0 likes · 13 min read
Master Database Indexes: 10 Essential Questions and Best Practices
Old Meng AI Explorer
Old Meng AI Explorer
Nov 24, 2025 · Databases

Why DBeaver Is the Ultimate All‑In‑One Database Management Tool

Developers, data analysts, and ops engineers can eliminate the hassle of juggling multiple database clients by adopting DBeaver, an open‑source, cross‑platform tool that supports over 100 databases, offers powerful SQL editing, visual design, data migration, and backup features—all for free.

Cross‑PlatformDBeaverData Migration
0 likes · 11 min read
Why DBeaver Is the Ultimate All‑In‑One Database Management Tool
Big Data Tech Team
Big Data Tech Team
Nov 24, 2025 · Big Data

Avoid the 5 Common DWS Design Traps and Build Scalable Data Warehouses

This article analyzes the five typical pitfalls when designing DWS aggregation tables—from chimney‑style schemas to performance blind spots—explains their consequences, and provides concrete, production‑ready recommendations, code examples, and design principles to create reusable, efficient data‑warehouse layers.

AggregationDWS DesignData Warehouse
0 likes · 10 min read
Avoid the 5 Common DWS Design Traps and Build Scalable Data Warehouses
Ops Community
Ops Community
Nov 22, 2025 · Databases

Why Is Your SQL Slow? 7 Common MySQL Index Failure Scenarios Explained

This article examines why MySQL queries can become sluggish by analyzing seven typical situations where indexes become ineffective, provides step‑by‑step testing procedures, performance comparisons, troubleshooting tips, and best‑practice recommendations to restore optimal query performance.

Index OptimizationMySQLPerformance Tuning
0 likes · 37 min read
Why Is Your SQL Slow? 7 Common MySQL Index Failure Scenarios Explained
dbaplus Community
dbaplus Community
Nov 22, 2025 · Databases

MySQL 8.4 Upgrade: Removed & Deprecated Features You Must Know

With MySQL 8.0 reaching end‑of‑life in April 2026, DBAs must migrate to the LTS 8.4 release, updating tools and replacing removed system variables, deprecated options, and old commands to avoid breakage in applications, monitoring, and replication setups.

8.4Deprecated featuresMySQL
0 likes · 7 min read
MySQL 8.4 Upgrade: Removed & Deprecated Features You Must Know
Architect-Kip
Architect-Kip
Nov 21, 2025 · Backend Development

Mastering Pagination Performance: Single‑DB and Cross‑DB Strategies

This guide explores common pagination bottlenecks and presents practical solutions for single‑database and sharded environments, covering keyset pagination, bidirectional paging, join‑based paging, index design, middleware rewriting, approximate paging, and two‑phase query techniques.

Keyset PaginationMiddlewareSQL
0 likes · 14 min read
Mastering Pagination Performance: Single‑DB and Cross‑DB Strategies
Zhuanzhuan Tech
Zhuanzhuan Tech
Nov 17, 2025 · Backend Development

How to Eliminate Duplicate and Missing Data in Backend Pagination

This article explains why offset‑based pagination can cause duplicate or missing records when data changes, compares three practical solutions—including cursor pagination with timestamps and IDs, fixed‑window timestamp filtering, and Elasticsearch search_after—and provides concrete SQL and code examples along with their trade‑offs and suitable scenarios.

CursorElasticsearchSQL
0 likes · 12 min read
How to Eliminate Duplicate and Missing Data in Backend Pagination
Advanced AI Application Practice
Advanced AI Application Practice
Nov 14, 2025 · Fundamentals

How to Verify Data Correctness Without Knowing SQL

When UI checks can be misleading, this guide shows testers three practical ways—getting ready‑made queries from developers, using friendly graphical database clients, and mentally mapping UI actions to DB changes—to directly validate data in the database without deep SQL expertise.

Data verificationGUI database clientQA
0 likes · 7 min read
How to Verify Data Correctness Without Knowing SQL
Architect-Kip
Architect-Kip
Nov 13, 2025 · Databases

Mastering Database Table Design: 12 Essential Table Types and Best Practices

Effective data modeling is crucial for system stability, and this guide walks you through core principles, twelve common table patterns—from batch and log tables to hierarchical and bitmap structures—detailing design rules, trade‑offs, usage scenarios, and practical examples to help you avoid costly redesigns.

SQLdata modelingnormalization
0 likes · 24 min read
Mastering Database Table Design: 12 Essential Table Types and Best Practices
Data STUDIO
Data STUDIO
Nov 12, 2025 · Databases

7 Reusable DuckDB SQL Patterns for Fast Local Data Analysis

This article presents seven practical DuckDB SQL patterns—querying files directly, treating partition folders as tables, deduplicating with QUALIFY, computing rolling metrics with window functions, pivot/unpivot, handling JSON arrays, and exporting results to Parquet—plus tips and a mini case study that show how to turn a notebook into a lightweight OLAP engine without leaving the Python environment.

DuckDBParquetPivot
0 likes · 12 min read
7 Reusable DuckDB SQL Patterns for Fast Local Data Analysis
Aikesheng Open Source Community
Aikesheng Open Source Community
Nov 10, 2025 · Artificial Intelligence

Ling‑1T vs Ring‑1T: SQL Optimization, Dialect Conversion & Understanding

October 2025’s SCALE report introduces Ant Bailing’s trillion‑parameter models Ling‑1T and Ring‑1T, evaluates them across three dimensions—SQL optimization, dialect conversion, and SQL understanding—reveals Ling‑1T’s strength in domestic database conversion and Ring‑1T’s balanced performance, and provides expert commentary on their implications for AI‑driven database solutions.

AI modelsBenchmarkLing-1T
0 likes · 13 min read
Ling‑1T vs Ring‑1T: SQL Optimization, Dialect Conversion & Understanding
Architect
Architect
Nov 8, 2025 · Databases

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

This article explains why using IN and NOT IN in SQL queries often leads to poor performance and subtle bugs, especially with large tables and NULL values, and demonstrates safer alternatives such as EXISTS, NOT EXISTS, and JOIN with clear code examples.

EXISTSINJOIN
0 likes · 6 min read
Why IN/NOT IN Can Kill Your Query Performance and How to Fix It
Architect's Guide
Architect's Guide
Nov 8, 2025 · Databases

Mastering MySQL Indexes: From Hash Tables to B+ Trees Explained

This article explains the fundamentals of database indexing, covering what indexes are, their advantages and drawbacks, underlying structures such as hash tables, B‑tree and B+‑tree, different index types (clustered, non‑clustered, primary, secondary) in MySQL, and practical examples with code snippets.

B+TreeClustered IndexDatabase Indexes
0 likes · 9 min read
Mastering MySQL Indexes: From Hash Tables to B+ Trees Explained
MaGe Linux Operations
MaGe Linux Operations
Nov 6, 2025 · Databases

Boost MySQL InnoDB Performance 300%: Complete Buffer Pool Tuning Guide for 32GB‑256GB

This comprehensive guide walks you through MySQL InnoDB buffer pool optimization—from assessing current settings and calculating optimal sizes for 32 GB to 256 GB servers, to configuring instances, enabling pre‑warming, tuning dirty‑page flushing, monitoring key metrics, and troubleshooting common issues—to achieve up to a 300 % throughput increase in production environments.

Buffer PoolInnoDBMySQL
0 likes · 33 min read
Boost MySQL InnoDB Performance 300%: Complete Buffer Pool Tuning Guide for 32GB‑256GB
Huolala Tech
Huolala Tech
Nov 5, 2025 · Backend Development

How SQL‑Based Rule Configuration Cuts Release Cycles from Days to Minutes

This article explains how transforming data‑validation rules into configurable SQL statements eliminates lengthy development‑test‑release cycles, improves cost efficiency, and boosts performance through architecture features such as plug‑in event triggers, memory‑snapshot isolation, data‑fingerprint grouping, and an online SQL debugger.

Backend DevelopmentData ValidationSQL
0 likes · 13 min read
How SQL‑Based Rule Configuration Cuts Release Cycles from Days to Minutes
Architect's Guide
Architect's Guide
Nov 5, 2025 · Databases

25 Essential SQL Query Optimization Tips to Avoid Full Table Scans

This article presents a comprehensive set of SQL performance guidelines, covering index creation, avoiding costly operators, rewriting predicates, using proper joins, limiting temporary objects, and best practices for query design to prevent full table scans and improve overall database efficiency.

IndexesPerformanceQuery Optimization
0 likes · 9 min read
25 Essential SQL Query Optimization Tips to Avoid Full Table Scans
Code Ape Tech Column
Code Ape Tech Column
Nov 4, 2025 · Backend Development

Master MyBatis Dynamic SQL: 9 Essential Tags and Best Practices

This article walks through nine powerful MyBatis dynamic SQL tags—including foreach, if, choose, selectKey, trim, and sql fragments—explaining their attributes, common pitfalls, and providing complete XML and Java examples to help developers write cleaner, error‑free queries and updates.

Dynamic SQLJavaMyBatis
0 likes · 17 min read
Master MyBatis Dynamic SQL: 9 Essential Tags and Best Practices
21CTO
21CTO
Nov 2, 2025 · Databases

How to Slash Database Costs by 60% Without Sacrificing Performance

This article explains why database expenses balloon, then walks through ten practical techniques—including smart indexing, selective column queries, caching, partitioning, archiving, data‑type tuning, simplifying joins, regular maintenance, query monitoring, and right‑sized hardware—to cut costs up to 60% while preserving or even boosting query speed.

MySQLPerformance TuningPostgreSQL
0 likes · 10 min read
How to Slash Database Costs by 60% Without Sacrificing Performance
Java Captain
Java Captain
Nov 1, 2025 · Databases

Why IN/NOT IN Slows Queries and How to Use EXISTS or JOIN Instead

The article explains why the SQL IN and NOT IN operators often cause poor performance and incorrect results—especially with large tables or NULL values—and demonstrates safer alternatives such as EXISTS, NOT EXISTS, and JOIN with clear code examples.

EXISTSINJOIN
0 likes · 5 min read
Why IN/NOT IN Slows Queries and How to Use EXISTS or JOIN Instead
Big Data Tech Team
Big Data Tech Team
Oct 30, 2025 · Big Data

Mastering the ADS Layer: Design Principles, Modeling, and Real‑Time Data Services

This article provides a comprehensive analysis of the ADS (Application Data Service) layer in a data‑warehouse architecture, covering its core positioning, design goals, modeling strategies, dimension‑optimization techniques, API services, typical challenges, and practical best‑practice recommendations for high‑performance, flexible, and secure data delivery.

ADS layerETLSQL
0 likes · 8 min read
Mastering the ADS Layer: Design Principles, Modeling, and Real‑Time Data Services
BirdNest Tech Talk
BirdNest Tech Talk
Oct 30, 2025 · Artificial Intelligence

Master LangChain Toolkits to Build Powerful AI Agents Quickly

This guide explains what LangChain toolkits are, why they simplify building domain‑specific AI agents, lists common built‑in toolkits, and walks through the step‑by‑step process of instantiating a toolkit, retrieving its tools, and creating an OpenAI‑powered agent, illustrated with a SQL database example.

AI agentsAutomationLangChain
0 likes · 5 min read
Master LangChain Toolkits to Build Powerful AI Agents Quickly
Data STUDIO
Data STUDIO
Oct 30, 2025 · Databases

From Table‑Centric to Object‑Centric: How DQL Redefines Join Queries

The article explains how Dimensional Query Language (DQL) replaces traditional multi‑table JOIN syntax with object‑dot notation and dimension‑alignment concepts, offering simpler, more business‑focused queries for BI scenarios, and demonstrates its implementation through concrete SQL examples and a real‑world engine integration.

BIDQLDimensional Query
0 likes · 10 min read
From Table‑Centric to Object‑Centric: How DQL Redefines Join Queries
Code Mala Tang
Code Mala Tang
Oct 26, 2025 · Databases

Why Parameterized Queries Supercharge SQL Performance (And Prevent Injection)

This article explains how using bound (parameterized) queries in SQL Server improves performance by enabling execution plan reuse, reducing compilation overhead and memory usage, while also preventing SQL injection, and discusses potential pitfalls like parameter sniffing and how to mitigate them with OPTION (RECOMPILE).

Execution PlanParameterized QueriesPerformance Optimization
0 likes · 6 min read
Why Parameterized Queries Supercharge SQL Performance (And Prevent Injection)
Ray's Galactic Tech
Ray's Galactic Tech
Oct 24, 2025 · Databases

How to Choose Between MySQL, PostgreSQL, and MongoDB: The Ultimate Guide

This comprehensive guide compares MySQL, PostgreSQL, and MongoDB across core features, transaction models, indexing, scalability, and real‑world use cases, offering a step‑by‑step selection method, detailed pros and cons, and a practical decision flowchart to help engineers pick the right database for their projects.

Database ComparisonMongoDBMySQL
0 likes · 9 min read
How to Choose Between MySQL, PostgreSQL, and MongoDB: The Ultimate Guide
php Courses
php Courses
Oct 23, 2025 · Databases

How Ecotone Simplifies PHP Database Mapping, Queries, and Conversions

This article explains how the Ecotone framework lets PHP developers map classes to database tables, hide low‑level SQL behind repository interfaces, customize parameter conversion with converters and expression language, and efficiently query, update, and stream large result sets while keeping business logic clean.

Database MappingEcotonePHP
0 likes · 20 min read
How Ecotone Simplifies PHP Database Mapping, Queries, and Conversions