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
May 18, 2026 · Industry Insights

From Chatbot to Work Assistant: Six Months of AI Advances, Gaps, and Real User Experiences

Over the past six months, AI models have raced through twelve major version updates, narrowing the US‑China performance gap to just 2.7%, while delivering impressive coding and reasoning abilities but still suffering from hallucinations, outdated knowledge, and uneven real‑world usefulness that ordinary workers feel daily.

AI HallucinationAI Market CompetitionAI productivity
0 likes · 9 min read
From Chatbot to Work Assistant: Six Months of AI Advances, Gaps, and Real User Experiences
IT Xianyu
IT Xianyu
Jan 17, 2026 · Databases

Master Oracle OCP Exam: Tablespaces, Privileges, and RMAN Backup Explained

This article walks through three common Oracle OCP exam questions—distinguishing permanent, temporary, and UNDO tablespaces, choosing the correct object versus system privilege syntax, and selecting the safest RMAN command for a hot backup—providing detailed explanations and the correct answers.

Database AdministrationOCPOracle
0 likes · 6 min read
Master Oracle OCP Exam: Tablespaces, Privileges, and RMAN Backup Explained
IT Xianyu
IT Xianyu
Jul 29, 2025 · Databases

Master PostgreSQL Transactions in DataGrip: BEGIN, COMMIT, ROLLBACK Explained

Learn how to safely manage PostgreSQL transactions using DataGrip by understanding ACID principles, executing BEGIN, COMMIT, and ROLLBACK commands, handling errors, and applying practical tips for visibility, connection loss, and Docker deployments, all illustrated with step‑by‑step screenshots.

ACIDBEGINDataGrip
0 likes · 9 min read
Master PostgreSQL Transactions in DataGrip: BEGIN, COMMIT, ROLLBACK Explained
IT Xianyu
IT Xianyu
Jul 22, 2025 · Databases

Master DataGrip: Connect, Insert, Update, and Delete PostgreSQL in Minutes

This guide walks you through using JetBrains DataGrip on AlmaLinux to connect to a PostgreSQL server, then demonstrates step‑by‑step how to insert, modify, and delete records via the graphical interface and optional SQL console, highlighting key settings and safety tips.

AlmaLinuxCRUDDataGrip
0 likes · 10 min read
Master DataGrip: Connect, Insert, Update, and Delete PostgreSQL in Minutes
IT Xianyu
IT Xianyu
Jul 21, 2025 · Databases

Deploy PostgreSQL on AlmaLinux with Docker Compose in One Click

This guide walks you through installing Docker and Docker Compose on AlmaLinux, creating a concise docker‑compose.yml to run PostgreSQL in an isolated container, connecting with DataGrip, and managing the lifecycle of the database service with simple commands.

AlmaLinuxContainerizationDataGrip
0 likes · 11 min read
Deploy PostgreSQL on AlmaLinux with Docker Compose in One Click
IT Xianyu
IT Xianyu
Jul 14, 2025 · Databases

Master MySQL Performance: Essential my.cnf Tweaks with Docker Compose

This guide walks you through setting up a MySQL instance on AlmaLinux using Docker Compose and explains the most impactful my.cnf parameters—innodb_buffer_pool_size, max_connections, innodb_flush_log_at_trx_commit, and sync_binlog—so you can safely boost database performance.

AlmaLinuxDatabase OptimizationDocker-Compose
0 likes · 12 min read
Master MySQL Performance: Essential my.cnf Tweaks with Docker Compose
IT Xianyu
IT Xianyu
Jul 2, 2025 · Operations

Master Linux Resource Limits: ulimit, cgroups, and Docker Compose Guide

Learn how to prevent production outages by configuring Linux user-level ulimit limits, system-level cgroups, and Docker Compose resource constraints, with step-by-step commands, configuration examples, and best practices for monitoring and persistent settings across sessions.

Docker-Composecgroupsulimit
0 likes · 6 min read
Master Linux Resource Limits: ulimit, cgroups, and Docker Compose Guide