BestHub
Sign in
Tagged articles
2769 articles
Page 10 of 28
dbaplus Community
dbaplus Community
Aug 13, 2023 · Databases

Why Does This PostgreSQL Self‑Join Behave Unexpectedly? InitPlan & One‑Time Filter

The article examines a puzzling PostgreSQL self‑join query that yields surprising true/false results, walks through step‑by‑step rewrites, analyzes the resulting execution plans—including the appearance of InitPlan and One‑Time Filter nodes—and explains how correlated versus uncorrelated subqueries affect query evaluation.

InitPlanSelf Joinpostgresql
0 likes · 11 min read
Why Does This PostgreSQL Self‑Join Behave Unexpectedly? InitPlan & One‑Time Filter
Senior Tony
Senior Tony
Aug 12, 2023 · Databases

Mastering SQL Optimization: 15 Practical Tips to Supercharge Your Queries

This article presents a comprehensive guide to SQL performance tuning, covering real‑world interview scenarios, deep‑pagination pitfalls, and fifteen concrete optimization techniques—including index usage, limit tricks, proper joins, batch operations, and data‑type choices—to help developers write faster, more efficient MySQL queries.

Database Optimizationindexingmysql
0 likes · 12 min read
Mastering SQL Optimization: 15 Practical Tips to Supercharge Your Queries
dbaplus Community
dbaplus Community
Aug 10, 2023 · Databases

How sql_helper Automates Index Recommendations for MySQL & MariaDB

The article introduces sql_helper, an open-source command-line and web tool for MySQL 5.7/8.0 and MariaDB that automatically analyzes SQL statements to suggest index creation, explains its six-step workflow, provides usage examples, command-line parameters, and notes its assumptions and limitations.

Index OptimizationMariaDBmysql
0 likes · 5 min read
How sql_helper Automates Index Recommendations for MySQL & MariaDB
StarRocks
StarRocks
Aug 9, 2023 · Databases

StarRocks 3.1 Highlights: Faster Lakehouse Analytics and Advanced Materialized Views

StarRocks 3.1 introduces a cloud‑native, lakehouse‑oriented architecture with enhanced storage‑compute separation, up to 3‑6× faster data‑lake queries than Trino/Presto, expanded Iceberg and Paimon support, richer materialized view capabilities, new random bucketing, expression partitioning, generated columns, and spill‑to‑disk stability, all backed by extensive performance optimizations and open‑source contributions.

Data LakeLakehouseMaterialized Views
0 likes · 17 min read
StarRocks 3.1 Highlights: Faster Lakehouse Analytics and Advanced Materialized Views
ITPUB
ITPUB
Aug 8, 2023 · Databases

Why MySQL 8.0’s Document Store Makes NoSQL Powerful: Top 10 Benefits

MySQL 8.0 introduces a native document store that brings full ACID‑compliant NoSQL capabilities, schema‑less JSON handling, simple CRUD APIs, seamless SQL integration, large‑document support, built‑in security and infrastructure simplification, enabling developers and DBAs to leverage existing MySQL expertise for modern applications.

ACIDCRUDDocument Store
0 likes · 18 min read
Why MySQL 8.0’s Document Store Makes NoSQL Powerful: Top 10 Benefits
Programmer DD
Programmer DD
Aug 8, 2023 · Databases

Why Mastering MySQL Is Essential for Every Tech Professional

This article explains why MySQL, the world’s most popular open‑source relational database, is a fundamental skill for developers, operators and testers, and outlines a two‑book learning path covering installation, SQL mastery, InnoDB internals, indexing and performance optimization.

InnoDBdatabasemysql
0 likes · 7 min read
Why Mastering MySQL Is Essential for Every Tech Professional
Aikesheng Open Source Community
Aikesheng Open Source Community
Aug 4, 2023 · Databases

SQLE 2.2308.0-pre1 Release Notes and Feature Overview

The SQLE 2.2308.0-pre1 release introduces community and enterprise enhancements such as intelligent SQL file scanning, per‑instance workflow approver matching, and the ability to abort deployments on OceanBase and TDSQL data sources, accompanied by usage examples, command‑line instructions, and full release information.

Database AuditingOceanBaseRelease Notes
0 likes · 7 min read
SQLE 2.2308.0-pre1 Release Notes and Feature Overview
360 Quality & Efficiency
360 Quality & Efficiency
Aug 4, 2023 · Databases

Understanding MySQL Query Execution, Indexes, Slow Queries and Optimization Practices

This article explains MySQL’s server and storage‑engine architecture, walks through the step‑by‑step execution of a SELECT statement, describes how indexes are organized, defines slow queries, shows how to detect and analyze them, and provides practical optimization examples and additional MySQL pitfalls.

Database Optimizationdatabasesindexes
0 likes · 13 min read
Understanding MySQL Query Execution, Indexes, Slow Queries and Optimization Practices
Efficient Ops
Efficient Ops
Aug 2, 2023 · Databases

Why ClickHouse Outperforms Elasticsearch in Real‑World Queries

This article compares Elasticsearch and ClickHouse across architecture, query capabilities, and performance using Docker‑compose stacks and Python SDK tests, demonstrating that ClickHouse often delivers superior speed, especially in aggregation and regex queries, while highlighting each system’s design trade‑offs.

Docker ComposeElasticsearchclickhouse
0 likes · 13 min read
Why ClickHouse Outperforms Elasticsearch in Real‑World Queries
Top Architect
Top Architect
Aug 2, 2023 · Databases

Implementing Multi‑Business Product Sales Statistics Queries Using Row‑Comparison in MySQL

This article explains how to query sales statistics for multiple business units and their associated products in MySQL by preparing the environment, presenting several candidate solutions—including loop queries, OR concatenation, mixed filtering, and finally row‑comparison—and selecting the row‑comparison approach as the optimal implementation.

Database OptimizationDynamic SQLRow Comparison
0 likes · 8 min read
Implementing Multi‑Business Product Sales Statistics Queries Using Row‑Comparison in MySQL
ITPUB
ITPUB
Jul 31, 2023 · Databases

How to Choose the Right Database: Key Steps for Successful Selection

This guide walks you through the essential stages of database selection—from assessing project requirements and comparing candidate systems to performance testing, long‑term impact analysis, and making the final decision—ensuring you pick a solution that fits both current and future needs.

BenchmarkingNoSQLdatabase selection
0 likes · 10 min read
How to Choose the Right Database: Key Steps for Successful Selection
ITPUB
ITPUB
Jul 28, 2023 · Databases

Master InnoDB Row Locking: Rules, Examples, and How Locks Are Applied

This article explains InnoDB's three row‑lock types, when MySQL statements acquire implicit or explicit locks, and walks through concrete examples for unique and non‑unique index queries, showing how Next‑key, Record and Gap locks are determined.

Database ConcurrencyInnoDBNext-key Lock
0 likes · 10 min read
Master InnoDB Row Locking: Rules, Examples, and How Locks Are Applied
Java Interview Crash Guide
Java Interview Crash Guide
Jul 28, 2023 · Backend Development

When to Use MyBatis-Plus: Pros, Cons, and Best Practices

This article examines MyBatis-Plus, highlighting its convenient CRUD shortcuts and pagination features while warning about maintenance challenges, magic strings, and limited support for complex SQL, and offers practical recommendations for using LambdaQueryWrapper and organizing queries in backend Java projects.

MyBatis-PlusORMbackend-development
0 likes · 6 min read
When to Use MyBatis-Plus: Pros, Cons, and Best Practices
Java High-Performance Architecture
Java High-Performance Architecture
Jul 28, 2023 · Backend Development

Master Fluent Mybatis: A Deep Dive into Java ORM Framework

This article introduces Fluent Mybatis, a Java ORM framework that enhances Mybatis with features from Mybatis Plus and JPA, demonstrates its core concepts, compares it with native Mybatis and Mybatis Plus through a student score query example, and provides step‑by‑step setup, code generation, and CRUD usage.

Fluent MyBatisJava ORMbackend-development
0 likes · 17 min read
Master Fluent Mybatis: A Deep Dive into Java ORM Framework
Python Programming Learning Circle
Python Programming Learning Circle
Jul 27, 2023 · Databases

Automating SQL Database Backups with Python

This article explains how to use Python to automatically back up SQL databases by installing required packages, establishing a connection with pyodbc, executing backup commands, recording backup details with pandas, and scheduling the script for regular execution, providing code examples for each step.

Database Backuppandaspyodbc
0 likes · 7 min read
Automating SQL Database Backups with Python
Java High-Performance Architecture
Java High-Performance Architecture
Jul 25, 2023 · Backend Development

When to Use MyBatis‑Plus: Benefits, Drawbacks, and Best Practices

This article examines the ongoing debate around MyBatis‑Plus, highlighting its convenience for simple CRUD operations, the maintenance challenges it introduces, and practical guidelines—such as using LambdaQueryWrapper and pagination plugins—to decide when the framework is appropriate for Java backend projects.

LambdaQueryWrapperORMbackend-development
0 likes · 7 min read
When to Use MyBatis‑Plus: Benefits, Drawbacks, and Best Practices
Java Interview Crash Guide
Java Interview Crash Guide
Jul 25, 2023 · Databases

Why MySQL Indexes Fail and How to Make Them Work

This article explains common MySQL index‑inefficiency scenarios—including left‑most prefix violations, range queries, functions, LIKE patterns, OR/IN misuse, and ORDER BY—provides concrete SQL examples, visual illustrations of B+‑tree indexing, and practical tips such as index jump scans, ICP, and query rewriting to ensure optimal index usage.

indexmysqloptimization
0 likes · 20 min read
Why MySQL Indexes Fail and How to Make Them Work
ITPUB
ITPUB
Jul 22, 2023 · Databases

What’s New in MySQL 8.1 and 8.0.34? Key Features, Changes, and Deprecations

MySQL 8.1 and 8.0.34, released on July 18, 2023, introduce a mix of innovative features—such as JSON EXPLAIN INTO, enhanced replication controls, TLS certificate enforcement, and new SHOW PARSE_TREE—while also aligning many adjustments with 8.0.34, adding user‑management options, audit enhancements, binary‑log APIs, and a series of deprecations for future versions.

Database FeaturesRelease NotesReplication
0 likes · 8 min read
What’s New in MySQL 8.1 and 8.0.34? Key Features, Changes, and Deprecations
dbaplus Community
dbaplus Community
Jul 19, 2023 · Databases

What’s New in MySQL 8.1 & 8.0.34? Key Features and Changes Explained

MySQL 8.1, the first innovation release, and the stable 8.0.34 bring a host of new capabilities—including JSON‑based EXPLAIN INTO, enhanced replication controls, expanded security variables, audit improvements, binary‑log functions, and several deprecations—while also fixing numerous bugs to solidify MySQL’s stability.

NewFeaturesReplicationaudit
0 likes · 9 min read
What’s New in MySQL 8.1 & 8.0.34? Key Features and Changes Explained
dbaplus Community
dbaplus Community
Jul 18, 2023 · Databases

Recover MySQL Data by Parsing Binlogs with reverse_sql

reverse_sql is an open‑source utility that parses MySQL binary logs in ROW format, generates both original and reverse SQL statements, and helps recover data from accidental DML operations using multithreaded processing and flexible filtering options.

BinlogData Recoverymysql
0 likes · 9 min read
Recover MySQL Data by Parsing Binlogs with reverse_sql
Architect
Architect
Jul 17, 2023 · Databases

Performance Comparison of Elasticsearch and ClickHouse for Log Search and Analytics

This article compares Elasticsearch and ClickHouse by describing their architectures, presenting Docker‑based test stacks, showing code snippets for deployment, data ingestion, and queries, and reporting performance results that demonstrate ClickHouse generally outperforms Elasticsearch in log‑analytics scenarios.

DockerElasticsearchLog Analytics
0 likes · 12 min read
Performance Comparison of Elasticsearch and ClickHouse for Log Search and Analytics
dbaplus Community
dbaplus Community
Jul 16, 2023 · Databases

Why MySQL DELETE Fails Without a Primary Key and How ESCAPE Fixes It

The article explains a puzzling MySQL DELETE failure caused by a missing primary key, shows how Navicat adds an ESCAPE clause to the generated SQL, clarifies the purpose of ESCAPE in LIKE patterns, and reveals that the real issue was a mistaken condition order in the query.

DELETEdebuggingescape
0 likes · 4 min read
Why MySQL DELETE Fails Without a Primary Key and How ESCAPE Fixes It
IT Services Circle
IT Services Circle
Jul 16, 2023 · Databases

Using MySQL Window Functions for Ranking, Aggregation, and Data Analysis

This article explains how MySQL 8.x window functions such as OVER, PARTITION BY, and ORDER BY can simplify complex ranking and aggregation queries, demonstrates creating a sample scores table, and provides practical examples of functions like ROW_NUMBER, RANK, DENSE_RANK, NTILE, LAG, and LEAD with their results.

OVERPartitionaggregation
0 likes · 18 min read
Using MySQL Window Functions for Ranking, Aggregation, and Data Analysis
dbaplus Community
dbaplus Community
Jul 13, 2023 · Databases

Understanding InnoDB Row Locks: Rules, Types, and Real-World Examples

This article explains InnoDB's three row‑lock types, when they are applied implicitly or explicitly, the two core locking principles, and walks through concrete examples for unique and non‑unique index equality and range queries, showing exact lock ranges and lock‑type degradations.

InnoDBlockingmysql
0 likes · 10 min read
Understanding InnoDB Row Locks: Rules, Types, and Real-World Examples
Code Ape Tech Column
Code Ape Tech Column
Jul 13, 2023 · Databases

Using Row‑Row Comparison to Query Sales Statistics for Multiple Business Units and Products in MySQL

This article explains how to design a MySQL table for product sales statistics, prepares sample data, describes the business requirement of querying sales for multiple business units and their associated products, and evaluates several query strategies—looping, OR concatenation, mixed filtering, and finally row‑row comparison—highlighting why the latter is chosen as the optimal solution.

Database OptimizationDynamic SQLQuery Design
0 likes · 9 min read
Using Row‑Row Comparison to Query Sales Statistics for Multiple Business Units and Products in MySQL
Senior Tony
Senior Tony
Jul 12, 2023 · Databases

Master MySQL Step‑by‑Step: From Beginner to Expert

This guide outlines a five‑level learning path for MySQL, starting with installation and basic queries, progressing through proficient use, deep understanding of locks, indexes and transactions, advanced performance tuning, and finally product‑level redesign, while recommending essential books and resources.

Database Learning PathDatabase designmysql
0 likes · 9 min read
Master MySQL Step‑by‑Step: From Beginner to Expert
Aikesheng Open Source Community
Aikesheng Open Source Community
Jul 11, 2023 · Databases

Investigation of Implicit Type Conversion Issues in OceanBase Update and Select Statements

This article analyzes a puzzling OceanBase data‑type implicit conversion problem where UPDATE statements intermittently fail with SQL syntax errors while SELECT statements return unexpected results, explains the underlying conversion mechanisms, shows diagnostic queries and log excerpts, and provides practical recommendations to avoid such errors.

DatabaseDebuggingImplicitConversionOceanBase
0 likes · 17 min read
Investigation of Implicit Type Conversion Issues in OceanBase Update and Select Statements
IT Services Circle
IT Services Circle
Jul 9, 2023 · Databases

20 Practical Rules for MySQL Index Optimization

This article presents twenty essential principles for optimizing MySQL indexes, covering topics such as the limitations of leading wildcard LIKE queries, the advantages of IN over UNION, handling negative conditions, composite index ordering, range queries, covering indexes, prefix indexes, and common pitfalls to avoid for better query performance.

Database PerformanceIndex OptimizationQuery Tuning
0 likes · 15 min read
20 Practical Rules for MySQL Index Optimization
Top Architect
Top Architect
Jul 6, 2023 · Databases

Understanding HikariCP Connection Pool Sizing: Principles, Experiments, and Practical Guidelines

This article translates and expands on HikariCP's pool‑sizing guidance, explaining why smaller database connection pools often yield better performance, presenting real‑world benchmark data for various pool sizes, and offering a simple formula to calculate an optimal pool size based on CPU cores and effective disks.

Connection PoolHikariCPpostgresql
0 likes · 10 min read
Understanding HikariCP Connection Pool Sizing: Principles, Experiments, and Practical Guidelines
政采云技术
政采云技术
Jul 6, 2023 · Big Data

Optimizing Large‑Scale Table Joins in Spark Using Bloom Filters

To address the resource‑intensive challenges of joining billion‑row tables in data warehouses, this article examines common optimization approaches, analyzes Spark’s SortMergeJoin algorithm, and proposes a Bloom‑filter‑based solution that filters unchanged data early, dramatically improving performance and reducing cluster resource consumption.

JOIN optimizationSparkbloom-filter
0 likes · 17 min read
Optimizing Large‑Scale Table Joins in Spark Using Bloom Filters
AI Cyberspace
AI Cyberspace
Jul 4, 2023 · Databases

Benchmarking Cloud‑Native Data Warehouses: Cloudwave vs StarRocks Performance Test

This article compares traditional databases with modern cloud‑native data warehouses, outlines a detailed performance testing methodology using the SSB1000 benchmark, presents test scripts and environment setup for Cloudwave and StarRocks, and analyzes the results to highlight strengths and optimization opportunities.

Performance Testingcloud-nativedata-warehouse
0 likes · 21 min read
Benchmarking Cloud‑Native Data Warehouses: Cloudwave vs StarRocks Performance Test
php Courses
php Courses
Jul 3, 2023 · Databases

MySQL Queries That Cannot Use Indexes

Certain MySQL queries, such as those using functions, leading wildcards in LIKE, OR operators, inequality comparisons, or NULL checks, prevent the database engine from utilizing indexes, leading to slower performance, and should be rewritten for optimal query efficiency.

databaseindexesmysql
0 likes · 3 min read
MySQL Queries That Cannot Use Indexes
php Courses
php Courses
Jul 1, 2023 · Databases

MySQL Queries That Cannot Use Indexes

This article explains five common MySQL query patterns—using functions, leading wildcards with LIKE, OR operators, inequality comparisons, and NULL checks—that prevent the database engine from utilizing indexes, and provides example SQL statements illustrating each case.

Database Optimizationindexesmysql
0 likes · 3 min read
MySQL Queries That Cannot Use Indexes
Top Architect
Top Architect
Jun 30, 2023 · Databases

Optimizing MySQL LIMIT Pagination: Analysis and Solutions

This article examines why MySQL LIMIT pagination becomes slower with deeper offsets on a 500,000‑row table, demonstrates the performance impact with concrete queries, and presents three optimization strategies—including using ordered primary keys, subqueries, and join‑based approaches—to reduce scan range and improve query speed.

Database Optimizationindexingmysql
0 likes · 8 min read
Optimizing MySQL LIMIT Pagination: Analysis and Solutions
Architecture Digest
Architecture Digest
Jun 29, 2023 · Databases

Chat2DB: Open‑Source AI‑Powered Multi‑Database Client – Installation, Configuration, and Feature Demonstration

This article introduces Chat2DB, an open‑source AI‑enhanced multi‑database client, walks through its download, installation, configuration, demonstrates natural‑language‑to‑SQL, SQL explanation and optimization features using sample MySQL tables, and outlines future roadmap for developers.

AIChat2DBDatabase client
0 likes · 13 min read
Chat2DB: Open‑Source AI‑Powered Multi‑Database Client – Installation, Configuration, and Feature Demonstration
Huolala Tech
Huolala Tech
Jun 29, 2023 · Databases

How to Build a Proactive SQL Defense System: From Early Detection to Capacity Forecasting

This article outlines a comprehensive SQL governance framework that moves defense to the testing stage, introduces SQLReview and new‑SQL detection with fingerprinting, details full‑SQL analysis for deep insight, and explains capacity prediction through simulated traffic load testing in a hybrid‑cloud environment.

Database GovernancePerformance Monitoringhybrid cloud
0 likes · 13 min read
How to Build a Proactive SQL Defense System: From Early Detection to Capacity Forecasting
Architect's Guide
Architect's Guide
Jun 28, 2023 · Databases

Testing MySQL Pagination Performance on Large Datasets

This article demonstrates how to create a 10‑million‑row MySQL table, batch‑insert data via a stored procedure, measure ordinary LIMIT pagination versus offset‑optimized queries, and provides practical tips for improving query speed on massive tables.

Large DataPerformance Testingmysql
0 likes · 9 min read
Testing MySQL Pagination Performance on Large Datasets
Aikesheng Open Source Community
Aikesheng Open Source Community
Jun 25, 2023 · Databases

SQLE 2.2306.0‑pre3 Release Notes: New Features, Enhancements, and Bug Fixes

The SQLE 2.2306.0‑pre3 release introduces Baidu Cloud RDS MySQL slow‑log scanning, SQL formatting, DB2 rollback generation and context‑aware auditing, along with numerous optimizations and bug fixes, and provides updated links to repositories, documentation, and demo environments for both community and enterprise editions.

DB2Database AuditingRelease Notes
0 likes · 7 min read
SQLE 2.2306.0‑pre3 Release Notes: New Features, Enhancements, and Bug Fixes
DataFunTalk
DataFunTalk
Jun 24, 2023 · Big Data

Design and Architecture of MaxCompute Lakehouse Near‑Real‑Time Incremental Processing

This article explains the evolution of Alibaba Cloud's MaxCompute platform into a lakehouse architecture that supports near‑real‑time incremental processing, detailing its development history, core design of transactional tables, five‑module technical stack, data ingestion methods, optimization services, transaction management, query capabilities, ecosystem integration, practical applications, future roadmap, and common user questions.

Big DataData LakeIncremental Processing
0 likes · 24 min read
Design and Architecture of MaxCompute Lakehouse Near‑Real‑Time Incremental Processing
Code Ape Tech Column
Code Ape Tech Column
Jun 23, 2023 · Databases

Chat2DB: An Open-Source AI-Powered Multi-Database Client – Installation, Configuration, and Usage Guide

This article introduces Chat2DB, an open‑source AI‑enhanced multi‑database client, explains how to download, install and configure it with OpenAI keys, demonstrates creating data sources and sample tables, and showcases natural‑language‑to‑SQL, SQL explanation, and optimization features with practical examples.

AIChat2DBTutorial
0 likes · 11 min read
Chat2DB: An Open-Source AI-Powered Multi-Database Client – Installation, Configuration, and Usage Guide
macrozheng
macrozheng
Jun 17, 2023 · Databases

Why DBeaver Is the Free, Open-Source Database Tool Every Backend Developer Needs

This article introduces DBeaver, an open‑source, cross‑platform database management tool, outlines its key features, provides step‑by‑step usage instructions, and shares the project’s GitHub link, helping developers efficiently handle MySQL, PostgreSQL, Oracle and many other databases.

DBeaverDatabase Managementopen-source
0 likes · 5 min read
Why DBeaver Is the Free, Open-Source Database Tool Every Backend Developer Needs
php Courses
php Courses
Jun 15, 2023 · Databases

20 Common MySQL Functions and Their Usage

This article introduces twenty commonly used MySQL functions, explains their purposes, and provides clear SQL examples with expected results to help developers efficiently manipulate and process data, including string, numeric, date, and aggregate functions, each illustrated with sample queries and output.

databasefunctionsmysql
0 likes · 5 min read
20 Common MySQL Functions and Their Usage
Ctrip Technology
Ctrip Technology
Jun 15, 2023 · Databases

Rebuilding Ctrip Train Ticket Metrics Platform with StarRocks: Architecture, Data Synchronization, and Performance Gains

The article details how Ctrip's train ticket business revamped its multi‑engine OLAP metrics platform by consolidating to the StarRocks MPP database, describing the new architecture, query workflow, data synchronization strategies, practical lessons, and the resulting dramatic improvement in query latency and reliability.

ETLMetrics PlatformStarRocks
0 likes · 15 min read
Rebuilding Ctrip Train Ticket Metrics Platform with StarRocks: Architecture, Data Synchronization, and Performance Gains
JD Tech
JD Tech
Jun 14, 2023 · Big Data

Understanding and Solving Data Skew in Offline Big Data Development (Hive & Spark)

This article explains the concept of data skew in offline big‑data jobs, describes its symptoms and root causes, and provides practical optimization techniques for Hive and Spark—including partitioning strategies, map‑join usage, adaptive query settings, and monitoring approaches—to prevent performance degradation and runtime failures.

Data SkewShuffleSpark
0 likes · 17 min read
Understanding and Solving Data Skew in Offline Big Data Development (Hive & Spark)
Java Architect Essentials
Java Architect Essentials
Jun 11, 2023 · Backend Development

Using MyBatis Dynamic SQL: if, choose, trim, foreach, and bind Tags

This article provides a comprehensive guide to MyBatis dynamic SQL, demonstrating how to use if, choose, trim, foreach, and bind tags for conditional queries, updates, inserts, batch operations, and database‑agnostic expressions, complete with Maven project setup, SQL scripts, and test cases.

BackendDynamic SQLMyBatis
0 likes · 15 min read
Using MyBatis Dynamic SQL: if, choose, trim, foreach, and bind Tags
ITPUB
ITPUB
Jun 10, 2023 · Databases

How Apache Doris 2.0 Cuts Storage Costs with Hot‑Cold Data Tiering

The article explains how Apache Doris 2.0 introduces hot‑cold data tiering to move infrequently accessed data from expensive SSDs to cheaper object storage, dramatically reducing storage costs while maintaining query performance through automatic lifecycle management, storage policies, and cache mechanisms.

Apache DorisCost reductionhot‑cold tiering
0 likes · 19 min read
How Apache Doris 2.0 Cuts Storage Costs with Hot‑Cold Data Tiering
IT Services Circle
IT Services Circle
Jun 10, 2023 · Databases

Comprehensive MySQL Interview Guide: Key Concepts and Practices

This article provides a systematic, interview‑focused overview of MySQL fundamentals—including normal forms, DML vs DDL, primary and foreign keys, storage engines, redo and binlog mechanisms, indexing strategies, transaction properties, MVCC, lock types, replication, and common performance pitfalls—helping candidates quickly master essential database knowledge for interview success.

Transactionsdatabaseindexing
0 likes · 32 min read
Comprehensive MySQL Interview Guide: Key Concepts and Practices
Aikesheng Open Source Community
Aikesheng Open Source Community
Jun 10, 2023 · Databases

Weekly Tech Share Summary – SQL and Database Highlights

This weekly newsletter curates top industry tech articles covering SQL deployment capabilities, MySQL replication issues, LLM‑to‑SQL benchmarks, connection limit errors, OceanBase tracing, and provides an open‑source SQL quality management platform update with development progress and upcoming plans.

OceanBaseWeekly Summaryaudit
0 likes · 4 min read
Weekly Tech Share Summary – SQL and Database Highlights
Aikesheng Open Source Community
Aikesheng Open Source Community
Jun 9, 2023 · Databases

SQLE 2.2306.0-pre1 Release Notes

The SQLE 2.2306.0-pre1 release introduces support for TDSQL InnoDB and Mycat data sources in enterprise edition, adds new features, UI optimizations, bug fixes, and provides detailed usage instructions and links to documentation, source code, and demo environments.

Database AuditingMycatRelease Notes
0 likes · 8 min read
SQLE 2.2306.0-pre1 Release Notes
Aikesheng Open Source Community
Aikesheng Open Source Community
Jun 7, 2023 · Databases

OceanBase vs MySQL/TiDB: Performance Evaluation, Deployment Guide, and Migration Practices

This article presents a comprehensive performance comparison of OceanBase with MySQL and TiDB, details step‑by‑step deployment of OceanBase (both single‑node and cluster), explains configuration and resource‑pool management, and shares practical migration techniques and troubleshooting tips for production workloads.

OceanBaseTiDBdatabase migration
0 likes · 23 min read
OceanBase vs MySQL/TiDB: Performance Evaluation, Deployment Guide, and Migration Practices
dbaplus Community
dbaplus Community
Jun 4, 2023 · Databases

How to Build an End‑to‑End SQL Defense and Capacity Forecast System

This article summarizes a technical presentation on innovative database practices, covering a preventive SQL defense framework, full‑SQL analysis for deep observation, and capacity prediction through simulated traffic testing, with detailed methods, challenges, and future plans for multi‑cloud environments.

Database GovernanceIndex Recommendationperformance optimization
0 likes · 16 min read
How to Build an End‑to‑End SQL Defense and Capacity Forecast System
Top Architect
Top Architect
Jun 1, 2023 · Databases

Comprehensive Guide to MySQL Indexes, Types, and Query Optimization

This article explains the definition, data structures, advantages, disadvantages, and appropriate usage scenarios of MySQL indexes, details primary, unique, single‑column and composite index types, analyzes common performance bottlenecks with EXPLAIN, demonstrates index creation, invalidation cases, query and join optimizations, and shows how to configure and use the slow‑query log.

Database Performanceexplainindexes
0 likes · 19 min read
Comprehensive Guide to MySQL Indexes, Types, and Query Optimization
Laravel Tech Community
Laravel Tech Community
May 31, 2023 · Databases

CrateDB 5.3.2 Release Notes: Bug Fixes and Improvements

CrateDB 5.3.2 introduces numerous fixes and enhancements, including corrected handling of empty partition tables, improved default clause errors for OBJECT columns, resolved ON CONFLICT insert issues, fixed LIKE/ILIKE pattern bugs, snapshot restoration problems, Azure repository errors, and various optimizer and interval function improvements.

BugFixesCrateDBDistributedSQL
0 likes · 6 min read
CrateDB 5.3.2 Release Notes: Bug Fixes and Improvements
DeWu Technology
DeWu Technology
May 31, 2023 · Databases

Designing a Time Axis for HR Systems: Interval vs Effective‑Date Models

Designing a time axis for HR systems involves choosing between an interval model that stores start and end timestamps and an effective‑date model that uses effective dates and sequences, each affecting query simplicity, maintenance effort, common pitfalls, and ultimately enabling accurate historical and future employee data analysis.

Design PatternsHR systemdata modeling
0 likes · 17 min read
Designing a Time Axis for HR Systems: Interval vs Effective‑Date Models
DataFunTalk
DataFunTalk
May 30, 2023 · Big Data

Optimizing Chart Query Performance in YouShu BI: Data Query Principles, Intelligent Caching, Query Merging, and Diagnostics

This article explains the data query fundamentals of YouShu BI charts, introduces intelligent caching design, describes query merging and various optimization techniques—including partition filters, value acceleration, and SQL generation—and outlines performance diagnosis methods to improve BI chart responsiveness.

BIBig DataChart Performance
0 likes · 16 min read
Optimizing Chart Query Performance in YouShu BI: Data Query Principles, Intelligent Caching, Query Merging, and Diagnostics
php Courses
php Courses
May 26, 2023 · Databases

Using Indexes to Optimize MySQL Queries

This article explains what indexes are, when they should be applied, and provides step‑by‑step MySQL commands—including single‑column, composite, and index‑hint examples—to improve query performance on large datasets.

Database Performanceindexingmysql
0 likes · 6 min read
Using Indexes to Optimize MySQL Queries
Programmer DD
Programmer DD
May 24, 2023 · Databases

Why SQL Struggles with Complex Queries and How SPL Offers a Solution

This article examines the inherent difficulties of SQL when handling multi‑step, ordered, and object‑referencing queries, illustrates them with practical examples, and introduces the Structured Process Language (SPL) as a more expressive alternative for data processing tasks.

CTESPLquery optimization
0 likes · 16 min read
Why SQL Struggles with Complex Queries and How SPL Offers a Solution
Top Architect
Top Architect
May 22, 2023 · Backend Development

Using MyBatis‑Plus‑Join Plugin for Multi‑Table Joins in Java

This article introduces the MyBatis‑Plus‑Join library that adds join capabilities to MyBatis‑Plus, explains how to install it via Maven or Gradle, shows how to extend mapper and service interfaces, and provides detailed code examples for simple three‑table queries, pagination, and advanced custom SQL usage.

BackendJOINORM
0 likes · 10 min read
Using MyBatis‑Plus‑Join Plugin for Multi‑Table Joins in Java
Laravel Tech Community
Laravel Tech Community
May 18, 2023 · Databases

SQLite 3.42.0 Release Highlights and New Features

SQLite 3.42.0, the widely used public-domain SQL database engine, introduces features such as FTS5 secure-delete, JSON5 support, new sqlite3_config options, enhanced query planner optimizations, CLI improvements, additional SQL functions, extended PRAGMA integrity_check, subsecond time modifiers, and various bug fixes and performance enhancements.

CLIDatabase EngineFTS5
0 likes · 5 min read
SQLite 3.42.0 Release Highlights and New Features
Tongcheng Travel Technology Center
Tongcheng Travel Technology Center
May 17, 2023 · Databases

StarRocks Production Practice at Tongcheng Travel: Architecture, Use Cases, and Technical Evaluation

This article details Tongcheng Travel’s production deployment of the StarRocks OLAP database, covering background, business scenarios, technical evaluation against ClickHouse and Greenplum, implementation with Flink SQL, real‑time analytics, offline reporting, CDP use cases, performance optimizations, and future cloud‑native plans.

Big DataFlinkOLAP
0 likes · 12 min read
StarRocks Production Practice at Tongcheng Travel: Architecture, Use Cases, and Technical Evaluation
Alibaba Cloud Developer
Alibaba Cloud Developer
May 16, 2023 · Artificial Intelligence

How to Build a Company‑Specific Chatbot with LLMs and Vector Databases

This article explains why combining large language models with vector databases enables enterprises to create specialized, up‑to‑date chatbots, outlines the underlying principles, describes the ADB‑PG vector‑search capabilities, and provides step‑by‑step implementation details including data processing, indexing, and query examples.

AnalyticDBChatbotLLM
0 likes · 17 min read
How to Build a Company‑Specific Chatbot with LLMs and Vector Databases
Top Architect
Top Architect
May 9, 2023 · Databases

Performance Testing and Optimization of MySQL Pagination for Large Datasets

This article demonstrates how to generate, insert, and query ten‑million‑row MySQL tables, measures the latency of ordinary LIMIT pagination, analyzes the impact of offset size and result set size, and presents practical optimization techniques such as sub‑query pagination and ID‑range filtering to dramatically improve query speed.

Large Datamysqloptimization
0 likes · 12 min read
Performance Testing and Optimization of MySQL Pagination for Large Datasets
DataFunTalk
DataFunTalk
May 9, 2023 · Databases

High‑Performance Inverted Index in Apache Doris for Log Data Storage and Analysis

This article explains how Apache Doris implements a high‑performance, column‑oriented inverted index to address the challenges of massive, real‑time log data storage and analysis, delivering dramatically higher write throughput, lower storage costs, and faster query performance than traditional Elasticsearch and Loki solutions.

Apache DorisBig DataLog Analytics
0 likes · 19 min read
High‑Performance Inverted Index in Apache Doris for Log Data Storage and Analysis
Java High-Performance Architecture
Java High-Performance Architecture
May 9, 2023 · Databases

How to Efficiently Paginate 10 Million MySQL Records: Real‑World Tests & Optimizations

This article walks through creating a 10‑million‑row MySQL table, measuring pagination query times under different offsets and result sizes, and presents practical optimizations such as sub‑queries, ID‑range filtering, and column selection to dramatically improve performance while explaining why using SELECT * is discouraged.

Large Datamysqloptimization
0 likes · 11 min read
How to Efficiently Paginate 10 Million MySQL Records: Real‑World Tests & Optimizations
Aikesheng Open Source Community
Aikesheng Open Source Community
May 6, 2023 · Databases

SQLE 2.2305.0‑pre1 Release Notes: Project Overview, New Features, and Full Release Details

The SQLE 2.2305.0‑pre1 release introduces a MySQL‑instance‑based smart scan for slow queries, adds configurable data source defaults, fixes several MySQL rule and workflow bugs, and provides comprehensive documentation, download links, and usage examples for both community and enterprise editions.

Database AuditingRelease NotesSQLE
0 likes · 7 min read
SQLE 2.2305.0‑pre1 Release Notes: Project Overview, New Features, and Full Release Details
DataFunTalk
DataFunTalk
May 6, 2023 · Databases

Apache Doris: Overview, Data Lake Analysis Architecture, Community Development and Future Roadmap

This article provides a comprehensive overview of Apache Doris, detailing its origins, MPP‑based analytical capabilities, data‑lake integration techniques, recent architectural enhancements, performance optimizations, community growth, and upcoming development plans, while also addressing common user questions.

Analytical DatabaseApache DorisBig Data
0 likes · 20 min read
Apache Doris: Overview, Data Lake Analysis Architecture, Community Development and Future Roadmap