BestHub
Sign in
The Dominant Programmer
Author

The Dominant Programmer

Resources and tutorials for programmers' advanced learning journey. Advanced tracks in Java, Python, and C#. Blog: https://blog.csdn.net/badao_liumang_qizhi

192
Articles
0
Likes
529
Views
0
Comments
Recent Articles

Latest from The Dominant Programmer

100 recent articles max
The Dominant Programmer
The Dominant Programmer
Mar 22, 2025 · Databases

Master Redis Interview Questions: From Basics to Advanced, Ace Your Interview

This article compiles the most frequently asked Redis interview questions, covering fundamentals, data structures, persistence mechanisms, high‑availability features, clustering, performance tuning, and troubleshooting, providing clear explanations and practical guidance to help candidates confidently tackle any Redis interview.

Data StructuresHigh AvailabilityPerformance optimization
0 likes · 8 min read
Master Redis Interview Questions: From Basics to Advanced, Ace Your Interview
The Dominant Programmer
The Dominant Programmer
Oct 18, 2024 · Databases

Deploy PostgreSQL with PostGIS on CentOS using Docker Compose

This guide walks through deploying a PostgreSQL instance with the PostGIS extension on a CentOS server using Docker Compose, covering image retrieval, docker‑compose configuration, environment variables, logging settings, container startup, and verification of PostGIS integration.

CentOSDatabase deploymentDocker
0 likes · 5 min read
Deploy PostgreSQL with PostGIS on CentOS using Docker Compose
The Dominant Programmer
The Dominant Programmer
Oct 17, 2024 · Cloud Native

Understanding Docker0 and Custom Docker Networks: Practical Examples

This article walks through Docker's default docker0 bridge, explains how containers obtain IP addresses via veth‑pair interfaces, demonstrates inspecting container IPs, and shows how to create and use custom bridge networks so containers can communicate by name or IP, including adding existing containers to the new network.

Container NetworkingDockerbridge
0 likes · 6 min read
Understanding Docker0 and Custom Docker Networks: Practical Examples
The Dominant Programmer
The Dominant Programmer
Jul 19, 2024 · Databases

Writing High‑Quality SQL: Practical MySQL Optimization Tips

To avoid common MySQL pitfalls, the article compiles practical SQL writing guidelines—selecting specific columns instead of *, using LIMIT 1, avoiding OR in WHERE, optimizing pagination, handling LIKE patterns, minimizing redundant indexes, preferring INNER JOIN, and leveraging covering indexes and EXPLAIN for efficient query execution.

Best PracticesIndexingMySQL
0 likes · 18 min read
Writing High‑Quality SQL: Practical MySQL Optimization Tips
The Dominant Programmer
The Dominant Programmer
Jul 19, 2024 · Backend Development

Java Switch Performance: Should You Use String or int?

Using JMH, this article benchmarks Java switch statements, comparing the traditional int‑based switch (via String hashCode) against the newer String‑based switch, showing that the int version runs roughly twice as fast while warning about hashCode collisions.

PerformanceSwitchhashCode
0 likes · 6 min read
Java Switch Performance: Should You Use String or int?