BestHub
Sign in
IT Xianyu
Author

IT Xianyu

We share common IT technologies (Java, Web, SQL, etc.) and practical applications of emerging software development techniques. New articles are posted daily. Follow IT Xianyu to stay ahead in tech. The IT Xianyu series is being regularly updated.

143
Articles
0
Likes
439
Views
0
Comments
Recent Articles

Latest from IT Xianyu

100 recent articles max
IT Xianyu
IT Xianyu
Jun 16, 2021 · Databases

Understanding Database Connection Pools vs. ThreadLocal in Java

This article explains the fundamental differences between database connection pools and ThreadLocal‑cached connections in Java, illustrating how connection pools improve performance while ThreadLocal enables sharing a single connection across methods within the same thread for consistent transaction control, and discusses practical usage patterns.

Backend DevelopmentConnection PoolDatabase
0 likes · 7 min read
Understanding Database Connection Pools vs. ThreadLocal in Java
IT Xianyu
IT Xianyu
Jun 15, 2021 · Databases

How to Size Database Connection Pools: Insights from HikariCP Performance Tests

The article explains how to determine the optimal size of a database connection pool by analyzing performance tests, presenting a simple formula based on CPU cores and disk count, and demonstrating that a much smaller pool can dramatically improve response times for high‑concurrency workloads.

HikariCPOptimizationPerformance
0 likes · 11 min read
How to Size Database Connection Pools: Insights from HikariCP Performance Tests
IT Xianyu
IT Xianyu
Jun 11, 2021 · Databases

10 Common Mistakes Java Developers Make When Writing SQL

The article outlines ten frequent errors that Java programmers encounter when writing SQL—ranging from misunderstanding NULL handling to misusing UNION, pagination, and batch inserts—and provides practical solutions to improve correctness, performance, and maintainability of database interactions.

Best PracticesDatabaseJDBC
0 likes · 9 min read
10 Common Mistakes Java Developers Make When Writing SQL
IT Xianyu
IT Xianyu
Jun 10, 2021 · Backend Development

Comprehensive Guide to MyBatis-Plus: CRUD, Annotations, Condition Builders, Pagination, and Advanced Features

This article provides a detailed tutorial on using MyBatis-Plus in Java, covering setup, entity and mapper definitions, CRUD operations, annotations, condition builders, pagination, AR mode, logical deletion, automatic field filling, optimistic locking, performance analysis, multi‑tenant support, dynamic table names, configuration options, and code generation.

CRUDJavaMybatis-Plus
0 likes · 45 min read
Comprehensive Guide to MyBatis-Plus: CRUD, Annotations, Condition Builders, Pagination, and Advanced Features
IT Xianyu
IT Xianyu
Jun 1, 2021 · Databases

Improving MySQL Insert Performance with Multithreading, Prepared Statements, and Batch Transactions

The article explains why multithreaded inserts can be faster than single‑threaded ones in MySQL, breaks down the time spent on each step of an insert operation, and presents practical techniques such as using PreparedStatement, multi‑value INSERT statements, and transaction batching to dramatically reduce insertion time.

Batch TransactionDatabase OptimizationInsert Performance
0 likes · 6 min read
Improving MySQL Insert Performance with Multithreading, Prepared Statements, and Batch Transactions
IT Xianyu
IT Xianyu
May 28, 2021 · Backend Development

Spring Boot Packaging with Maven Profiles and a Shell Deployment Tool

This article explains how to use Maven profiles to manage multiple Spring Boot environments, configure the maven‑assembly‑plugin to create a zip release containing the jar, configuration files and a custom shell script, and then deploy and control the application on Linux using the provided shenniu_publish.sh tool.

Assembly pluginDeploymentLinux
0 likes · 15 min read
Spring Boot Packaging with Maven Profiles and a Shell Deployment Tool
IT Xianyu
IT Xianyu
May 11, 2021 · Backend Development

Integrating Dataway with Spring Boot for API Configuration

This article provides a step‑by‑step guide on integrating the open‑source Dataway tool with a Spring Boot application, covering dependency inclusion, configuration of Dataway and data sources, module setup, enabling Hasor, and creating and testing API endpoints without writing custom code.

API ConfigurationDataQLDataway
0 likes · 14 min read
Integrating Dataway with Spring Boot for API Configuration
IT Xianyu
IT Xianyu
May 10, 2021 · Frontend Development

Electron Cross‑Platform Development Guide: Environment Setup, Project Structure, and Sample Applications

This article provides a comprehensive tutorial on building cross‑platform desktop applications with Electron, covering environment preparation, installation of Node, Vue‑CLI and Electron, project creation, directory layout, main and renderer processes, and detailed examples such as a NetEase Cloud Music client and a QQ Music player.

Desktop AppElectronNode.js
0 likes · 12 min read
Electron Cross‑Platform Development Guide: Environment Setup, Project Structure, and Sample Applications