BestHub
Sign in

Databases

Showing 100 articles max
Latest Popular
liandk
liandk
Aug 20, 2026 · Databases

Master MySQL Locks: Row, Table, and Gap Lock Basics, Pitfalls & Live Code

Understanding MySQL’s lock types—table, row, and gap locks—reveals how they act as resource tokens to ensure data consistency under concurrency, while the article details their characteristics, appropriate and prohibited use cases, common pitfalls like lock degradation and deadlocks, and provides hands‑on SQL examples to reproduce and avoid these issues.

DeadlockGap LockLocks
0 likes · 10 min read
Master MySQL Locks: Row, Table, and Gap Lock Basics, Pitfalls & Live Code
liandk
liandk
Aug 20, 2026 · Databases

Mastering SQL Subqueries: Core Nested Query Techniques for Beginners

This guide explains why subqueries are essential after learning JOINs, outlines their core characteristics, common use cases, two main types, step‑by‑step examples—including single‑row, multi‑row, aggregate, and derived‑table queries—and lists five key rules to avoid pitfalls while showing when to prefer subqueries over JOINs.

Database TutorialJOIN vs SubqueryNested Query
0 likes · 6 min read
Mastering SQL Subqueries: Core Nested Query Techniques for Beginners
YiSu Grain
YiSu Grain
Aug 19, 2026 · Databases

Optimizing Slow Queries, Sharding and Cache Consistency for Appointment System

This article walks through a comprehensive case study of a provincial medical appointment platform, diagnosing slow‑query bottlenecks, proposing patient‑id + create_time composite indexes, designing read‑write separation with replication, selecting patient_id for horizontal sharding, and implementing cache‑aside strategies to ensure consistency while handling cache avalanche, penetration and thundering‑herd scenarios.

Cache ConsistencyMySQLRedis
0 likes · 30 min read
Optimizing Slow Queries, Sharding and Cache Consistency for Appointment System
Open Source Tech Hub
Open Source Tech Hub
Aug 19, 2026 · Databases

A 20 MB Open‑Source DB Client That Handles 80+ Databases, Replacing DBeaver and Navicat

DBX is a Rust‑and‑Tauri based, 20 MB single‑file, free, open‑source database client that supports over 80 relational, NoSQL, OLAP and search databases, includes an AI‑powered SQL assistant and native MCP server, and offers lightweight installation across macOS, Windows, Linux and Docker, positioning it as a modern alternative to DBeaver and Navicat.

AI SQLDatabase clientMCP server
0 likes · 5 min read
A 20 MB Open‑Source DB Client That Handles 80+ Databases, Replacing DBeaver and Navicat
Code Farming
Code Farming
Aug 19, 2026 · Databases

Applying DDD to Database Design in 4 Practical Steps

The article explains how to translate domain‑driven design into concrete database schemas by first shifting focus from tables to domain models, then mapping the four relationship types, choosing an inheritance strategy, and finally adapting the approach for NoSQL databases.

DDDDomain ModelInheritance Strategies
0 likes · 7 min read
Applying DDD to Database Design in 4 Practical Steps
MaGe Linux Operations
MaGe Linux Operations
Aug 18, 2026 · Databases

Common Causes and Fix Steps for MySQL Master‑Slave Replication Lag

This guide walks through why MySQL master‑slave replication lag occurs, the key metrics to monitor, a step‑by‑step troubleshooting flow, ten typical root causes, concrete remediation actions, verification methods, rollback plans, and production‑grade best practices for keeping replication latency near zero.

DiskIOLagMySQL
0 likes · 29 min read
Common Causes and Fix Steps for MySQL Master‑Slave Replication Lag
samdeepthink
samdeepthink
Aug 18, 2026 · Databases

When a Single Database Hits Its Limits: Sharding Principles and Migration Path

The article explains why sharding should be a last‑resort scaling option, describes vertical and horizontal partitioning, compares hash, range and directory sharding schemes, discusses hotspots, routing, data colocation, migration steps and tool choices, and warns about the operational complexity involved.

Data ConsistencyDatabase ScalingHorizontal Partitioning
0 likes · 16 min read
When a Single Database Hits Its Limits: Sharding Principles and Migration Path
Raymond Ops
Raymond Ops
Aug 17, 2026 · Databases

How to Diagnose and Fix MySQL Deadlocks Without Just Restarting the Service

This article explains why MySQL deadlocks occur in production, distinguishes them from simple lock waits, and provides a step‑by‑step guide—including enabling deadlock logging, analyzing InnoDB lock types, and applying four practical solutions such as distributed locks, unique constraints, isolation‑level changes, and SQL reordering—to reliably troubleshoot and prevent deadlocks.

DeadlockInnoDBMySQL
0 likes · 31 min read
How to Diagnose and Fix MySQL Deadlocks Without Just Restarting the Service
ITPUB
ITPUB
Aug 17, 2026 · Databases

How a Veteran DBA Tackles Financial Multi‑Database and Big Data Architecture

In this interview, senior DBA Yao Wei shares over a decade of hands‑on experience designing, testing, and operating heterogeneous database ecosystems for retail, internet, and financial services, detailing pre‑emptive DBA involvement, compatibility pitfalls, high‑availability strategies, automated validation pipelines, and migration to domestic databases.

AutomationCDCData Migration
0 likes · 32 min read
How a Veteran DBA Tackles Financial Multi‑Database and Big Data Architecture
liandk
liandk
Aug 17, 2026 · Databases

MySQL Transaction Basics: ACID, Isolation Levels, and Practical Pitfall‑Avoiding Code

The article explains what a database transaction is, breaks down the ACID properties, details MySQL’s four isolation levels with their appropriate use‑cases and pitfalls, and provides step‑by‑step SQL and SpringBoot code to reproduce and resolve dirty reads, non‑repeatable reads, and phantom reads.

ACIDIsolation LevelMySQL
0 likes · 10 min read
MySQL Transaction Basics: ACID, Isolation Levels, and Practical Pitfall‑Avoiding Code
IoT Full-Stack Technology
IoT Full-Stack Technology
Aug 17, 2026 · Databases

Does Adding an Index Lock the Table? JD Interview Deep Dive (Full Score Edition)

The article explains that whether adding an index locks a MySQL table depends on the version and DDL algorithm—MySQL 5.5 and earlier lock the whole table, 5.6‑5.7 use Online DDL with brief metadata locks, and 8.0+ can create secondary indexes instantly without locking, while primary, unique, and full‑text indexes always require locking.

COPYINPLACEINSTANT
0 likes · 10 min read
Does Adding an Index Lock the Table? JD Interview Deep Dive (Full Score Edition)
Yumin Fish Harvest
Yumin Fish Harvest
Aug 16, 2026 · Databases

Implementing Continuous Invoice Numbers Using a Transactional Watermark Table

The article explains how to generate strictly sequential invoice numbers required by auditors by using a MySQL InnoDB watermark (water level) table combined with row locking and UPSERT within a single transaction, covering the workflow, concurrency handling, rollback versus void semantics, performance trade‑offs, and applicability limits.

AuditMySQLTransaction
0 likes · 16 min read
Implementing Continuous Invoice Numbers Using a Transactional Watermark Table
liandk
liandk
Aug 16, 2026 · Databases

Understanding DELETE vs DROP: How to Remove Data Without Dropping the Table

This article clarifies the difference between SQL DELETE and DROP TABLE, showing that DELETE removes rows while preserving table structure (and requires a WHERE clause), whereas DROP TABLE eliminates the entire table, and provides practical scenarios and code examples for each.

DELETEDROP TABLEData manipulation
0 likes · 2 min read
Understanding DELETE vs DROP: How to Remove Data Without Dropping the Table
Shuge Unlimited
Shuge Unlimited
Aug 16, 2026 · Databases

Milvus 3.0 External Tables: Patch‑Add Columns and Query Snapshots as Tables

This article dissects Milvus 3.0’s External Collection feature, explaining how function‑output fields extend source schemas, how additive‑only schema refresh patches manifests without moving source data, and how the milvus‑table format lets snapshots serve as zero‑copy external tables for both batch and serving workloads.

External CollectionMilvusSchema Refresh
0 likes · 19 min read
Milvus 3.0 External Tables: Patch‑Add Columns and Query Snapshots as Tables
ITPUB
ITPUB
Aug 16, 2026 · Databases

How Oracle’s Grip Is Killing MySQL and Why the ‘Toy’ SQLite Is Rising

Oracle’s 2026 layoffs hit the MySQL team, community contributions fell 44% since 2017, while PostgreSQL climbs, and SQLite—once dismissed as a toy—now powers billions of devices and edge‑computing platforms, boosted by projects like LibSQL, Turso, Cloudflare D1 and Litestream, offering latency advantages over traditional servers.

Database trendsMySQLOracle
0 likes · 8 min read
How Oracle’s Grip Is Killing MySQL and Why the ‘Toy’ SQLite Is Rising