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

160
Articles
0
Likes
2
Views
0
Comments
Recent Articles

Latest from The Dominant Programmer

100 recent articles max
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.

Dockerbridgecontainer networking
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.

DatabaseMySQLSQL optimization
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.

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