BestHub
Sign in
Showing 100 articles max
Latest Popular
IoT Full-Stack Technology
IoT Full-Stack Technology
Apr 29, 2026 · Databases

10+ Practical Redis Use Cases You Can Implement Today

This article walks through more than ten common Redis scenarios—including caching, distributed sessions, locks, global IDs, counters, rate limiting, bitmap statistics, shopping carts, timelines, message queues, lotteries, likes, product tagging, filtering, follow/fan relationships, and ranking—showing concrete command examples and code snippets for each.

CachingFollow SystemMessage Queue
0 likes · 9 min read
10+ Practical Redis Use Cases You Can Implement Today
Shuge Unlimited
Shuge Unlimited
Apr 29, 2026 · Databases

Milvus Storage Tuning in Practice: 25× Query Speedup and Three Tricks to Cut Memory Usage by Half

This article walks through Milvus 2.3‑2.6.x storage optimizations—Mmap, tiered storage, and clustering compaction—explaining their principles, configuration hierarchy, benchmark results, and concrete deployment templates that together can boost query performance up to 25‑fold while halving memory consumption.

MilvusPerformance tuningStorage Optimization
0 likes · 24 min read
Milvus Storage Tuning in Practice: 25× Query Speedup and Three Tricks to Cut Memory Usage by Half
The Dominant Programmer
The Dominant Programmer
Apr 29, 2026 · Databases

Getting Started with Spring Boot and Neo4j: Step‑by‑Step Guide and Sample Code

This article introduces Neo4j as a graph database, walks through its Windows installation, and provides a complete Spring Boot integration tutorial—including Maven dependencies, YAML configuration, entity and repository definitions, REST controller implementation, and end‑to‑end testing of user and follow‑relationship APIs.

Graph DatabaseNeo4jREST API
0 likes · 8 min read
Getting Started with Spring Boot and Neo4j: Step‑by‑Step Guide and Sample Code
MaGe Linux Operations
MaGe Linux Operations
Apr 27, 2026 · Databases

Production MySQL Deadlocks: Diagnosis Strategies and Permanent Fixes

The article explains how MySQL InnoDB deadlocks occur, details the four necessary conditions, shows how to enable full deadlock logging, demonstrates queries against information_schema and performance_schema, and provides concrete scenarios with code‑level solutions to prevent and resolve deadlocks in production environments.

InnoDBPerformance SchemaTroubleshooting
0 likes · 22 min read
Production MySQL Deadlocks: Diagnosis Strategies and Permanent Fixes
Java Backend Full-Stack
Java Backend Full-Stack
Apr 27, 2026 · Databases

Proven Redis Tuning Techniques for Production Environments

This article compiles practical, interview‑ready Redis tuning tips—from strict memory limits and eviction policies to avoiding big keys, hot keys, slow commands, and optimizing persistence, networking, and high‑availability settings—so you can confidently handle Redis performance questions in real‑world deployments.

Performance tuningRedisconfiguration
0 likes · 9 min read
Proven Redis Tuning Techniques for Production Environments
dbaplus Community
dbaplus Community
Apr 26, 2026 · Databases

Why PostgreSQL Is the Better Choice in 99% of Scenarios

The article argues that relying on many specialized databases creates operational complexity, higher costs, and maintenance overhead, while PostgreSQL’s extensible ecosystem—offering full‑text search, vector, time‑series, JSONB, and more—delivers comparable or superior algorithms, proven performance, and a simpler, more reliable stack for the vast majority of use cases, especially in AI applications.

AIDatabaseFull-Text Search
0 likes · 19 min read
Why PostgreSQL Is the Better Choice in 99% of Scenarios
James' Growth Diary
James' Growth Diary
Apr 26, 2026 · Databases

Vector Database Fundamentals: Embedding, Similarity Search, and Index Structures Explained in One Go

This article walks through the complete workflow of turning split text into high‑dimensional vectors, choosing the right embedding model, selecting an appropriate similarity metric, comparing index structures such as Flat, IVF, HNSW and PQ, and finally picking a vector database and integrating it with LangChain.js for production‑grade RAG pipelines.

EmbeddingsLangChainRAG
0 likes · 25 min read
Vector Database Fundamentals: Embedding, Similarity Search, and Index Structures Explained in One Go
Java Backend Full-Stack
Java Backend Full-Stack
Apr 26, 2026 · Databases

Mastering Redis: Core Concepts, Practical Roadmap, and Advanced Techniques

This comprehensive guide outlines a step‑by‑step learning path for Redis, covering foundational commands, core data structures, high‑performance internals, persistence options, clustering, common caching pitfalls, performance tuning, monitoring, source‑code exploration, and recommended resources for becoming a Redis expert.

CachingClusterData Structures
0 likes · 9 min read
Mastering Redis: Core Concepts, Practical Roadmap, and Advanced Techniques
Java Companion
Java Companion
Apr 26, 2026 · Databases

Is Sharding Ready to Retire? Why the Classic Split‑Database Approach Is Becoming Legacy

The article reviews the rise and decline of traditional database sharding, explains its technical pitfalls such as wrong shard keys, cross‑database joins, and distributed transactions, compares it with emerging NewSQL solutions like TiDB, OceanBase and PolarDB‑X, and offers practical criteria for choosing the right architecture.

NewSQLOceanBasePolarDB-X
0 likes · 14 min read
Is Sharding Ready to Retire? Why the Classic Split‑Database Approach Is Becoming Legacy
Raymond Ops
Raymond Ops
Apr 25, 2026 · Databases

How to Reduce MySQL Master‑Slave Replication Lag from 30 seconds to Milliseconds

This article walks through the root causes of MySQL master‑slave replication delay, demonstrates step‑by‑step diagnostics using SHOW SLAVE STATUS, pt‑heartbeat, and binlog comparisons, and provides concrete configuration changes, query rewrites, hardware upgrades, and monitoring scripts that can shrink lag from dozens of seconds to sub‑millisecond levels.

LatencyMonitoringmysql
0 likes · 23 min read
How to Reduce MySQL Master‑Slave Replication Lag from 30 seconds to Milliseconds
Architect's Guide
Architect's Guide
Apr 25, 2026 · Databases

Three Free Tools That Can Replace Navicat for MySQL

The article reviews three free MySQL client alternatives—DBeaver, MySQL Workbench, and HeidiSQL—detailing their installation steps, supported databases, key features such as monitoring and ER diagrams, and why they can serve as practical replacements for the paid Navicat tool.

DBeaverDatabase clientHeidiSQL
0 likes · 5 min read
Three Free Tools That Can Replace Navicat for MySQL
DataFunTalk
DataFunTalk
Apr 24, 2026 · Databases

DM GDMBASE V4.0: HyperRAG, Long‑Term Memory & NL Agents for Graph‑Vector AI

At the 2026 China Database Technology & Industry Conference, DM unveiled GDMBASE V4.0, a graph database that natively fuses vectors and graphs, introduces HyperRAG, long‑term memory, and a natural‑language agent, and delivers sub‑500 ms retrieval, 30% higher recall and 60% lower hallucination rates for AI workloads.

AI integrationGraph DatabaseHybrid Retrieval
0 likes · 12 min read
DM GDMBASE V4.0: HyperRAG, Long‑Term Memory & NL Agents for Graph‑Vector AI
IoT Full-Stack Technology
IoT Full-Stack Technology
Apr 24, 2026 · Databases

Why Choose PostgreSQL Over MySQL Despite MySQL’s Popularity?

The article compares PostgreSQL and MySQL across data types, native sequences, extensions, monitoring tools, replication mechanisms, licensing, community governance, and MVCC implementation, showing why many Chinese tech giants favor PostgreSQL for complex, high‑consistency workloads while acknowledging MySQL’s strengths in simple web scenarios.

MVCCPostgreSQLdatabase comparison
0 likes · 9 min read
Why Choose PostgreSQL Over MySQL Despite MySQL’s Popularity?
Architecture & Thinking
Architecture & Thinking
Apr 24, 2026 · Databases

SQL Index Failure Scenarios: Essential Pitfalls and Fixes Every Developer Must Know

This article systematically examines why MySQL indexes can become ineffective—covering function calls, implicit casts, LIKE patterns, OR conditions, composite‑index left‑most rules, data distribution, and ORDER/GROUP mismatches—while providing concrete code examples, production case studies, and actionable optimization techniques.

B+TreeDatabase TuningIndex Optimization
0 likes · 26 min read
SQL Index Failure Scenarios: Essential Pitfalls and Fixes Every Developer Must Know
MaGe Linux Operations
MaGe Linux Operations
Apr 23, 2026 · Databases

How to Diagnose and Optimize MySQL Slow Queries Beyond Adding Indexes

This guide walks through a systematic approach to identify, analyze, and fix MySQL slow queries by enabling the slow‑query log, interpreting its format, using tools like mysqldumpslow and pt‑query‑digest, examining execution plans with EXPLAIN, designing proper indexes, rewriting SQL, tuning server parameters, and establishing continuous monitoring to prevent regressions.

EXPLAINIndex OptimizationPerformance tuning
0 likes · 34 min read
How to Diagnose and Optimize MySQL Slow Queries Beyond Adding Indexes
DataFunSummit
DataFunSummit
Apr 23, 2026 · Databases

How Hologres Dynamic Table Redefines Data Processing with Incremental Computing

The article analyzes the limitations of traditional batch and stream processing, introduces Hologres Dynamic Table as a declarative, incremental‑compute framework that bridges the gap between low‑cost batch jobs and low‑latency streaming, and validates its performance with benchmarks and real‑world case studies.

Dynamic TableHologresPerformance Benchmark
0 likes · 13 min read
How Hologres Dynamic Table Redefines Data Processing with Incremental Computing