BestHub
Sign in
Engineer Tang's Implementation Study Notes
Author

Engineer Tang's Implementation Study Notes

Old Tang | Pseudo-full-stack tech player: writes code without going bald, manages projects without going crazy, delivers without staying up late. No formal tutorials here, only a "slacking-off" practical manual that cures system pain points. Focuses on Shell, SQL, Java, and delivery, turning complexity into simplicity and making efficiency fun.

68
Articles
0
Likes
90
Views
0
Comments
Recent Articles

Latest from Engineer Tang's Implementation Study Notes

68 recent articles
Engineer Tang's Implementation Study Notes
Engineer Tang's Implementation Study Notes
Jan 12, 2026 · Databases

MySQL 8.0 Installation Masterclass: Windows & Mac Step-by-Step Guide for Beginners

This comprehensive tutorial walks beginners through installing MySQL 8.0 on Windows and Mac, covering version selection, download sources, step-by-step installation with screenshots, configuration choices, environment variable setup, verification, and troubleshooting common issues like port conflicts, missing Visual C++ libraries, and authentication errors.

Database SetupEnvironment VariablesMySQL
0 likes · 18 min read
MySQL 8.0 Installation Masterclass: Windows & Mac Step-by-Step Guide for Beginners
Engineer Tang's Implementation Study Notes
Engineer Tang's Implementation Study Notes
Jan 11, 2026 · Artificial Intelligence

Build Anime Waifu AI Chatbots with Python & iFlytek Spark API

This tutorial demonstrates building a cross-platform Python GUI chat application that uses iFlytek Spark's free API and prompt engineering to create interactive anime character chatbots like Tsunade and Boa Hancock, featuring streaming responses, conversation history management, and cross-platform tkinter compatibility.

AI chatbotPythonanime character
0 likes · 22 min read
Build Anime Waifu AI Chatbots with Python & iFlytek Spark API
Engineer Tang's Implementation Study Notes
Engineer Tang's Implementation Study Notes
Jan 6, 2026 · Databases

SQL Fundamentals: CRUD, Joins & Execution Order Explained for Beginners

This tutorial explains SQL fundamentals including CRUD operations, the difference between SELECT * and explicit columns, table and column aliases, INNER/LEFT/RIGHT JOIN types with practical examples, and the SQL execution order (FROM/JOIN → WHERE → GROUP BY → HAVING → SELECT → ORDER BY → LIMIT) using a cooking analogy, plus beginner tips.

AliasesBeginner TutorialCRUD
0 likes · 13 min read
SQL Fundamentals: CRUD, Joins & Execution Order Explained for Beginners
Engineer Tang's Implementation Study Notes
Engineer Tang's Implementation Study Notes
Dec 31, 2025 · Backend Development

Redis on Linux: From Basics to Production-Ready Scripts

This guide covers Redis core data types (String, List, Hash, Set, Sorted Set) with practical Linux command examples, demonstrates building a message queue with List and storing user profiles with Hash, and provides production-ready shell scripts for backup, monitoring, and automated cleanup of idle keys, plus common pitfalls to avoid.

BackupCachingMessage Queue
0 likes · 18 min read
Redis on Linux: From Basics to Production-Ready Scripts
Engineer Tang's Implementation Study Notes
Engineer Tang's Implementation Study Notes
Dec 26, 2025 · Databases

Import 50GB MySQL SQL Files in 2.5 Hours: Split, Tune, Parallelize & Resume

This guide details a four-step method to import massive MySQL .sql files efficiently: split large files, clean unnecessary statements, temporarily tune MySQL parameters for speed, and run parallel imports with automatic resume and retry, demonstrated by importing a 50GB file with 100M rows in 2.5 hours.

MySQLSQL importdatabase administration
0 likes · 12 min read
Import 50GB MySQL SQL Files in 2.5 Hours: Split, Tune, Parallelize & Resume
Engineer Tang's Implementation Study Notes
Engineer Tang's Implementation Study Notes
Dec 24, 2025 · Backend Development

Global API Encryption with @ControllerAdvice: 30-Min Spring Boot Implementation & Benchmarks

This tutorial demonstrates how to implement global API encryption in Spring Boot using @ControllerAdvice and ResponseBodyAdvice with AES, covering step-by-step code, three critical pitfalls to avoid, and performance benchmarks showing AES adds only ~6ms overhead per request.

@ControllerAdviceAES encryptionAPI Security
0 likes · 11 min read
Global API Encryption with @ControllerAdvice: 30-Min Spring Boot Implementation & Benchmarks
Engineer Tang's Implementation Study Notes
Engineer Tang's Implementation Study Notes
Dec 15, 2025 · Fundamentals

Python for Absolute Beginners: Write Your First Code in 5 Minutes (Tested Guide)

This hands-on tutorial walks absolute beginners through Python installation on Windows, essential tools (IDLE, PyCharm, Jupyter), core syntax including data types, conditionals, loops, and functions, plus three practical projects: data visualization with pandas and matplotlib, a tax calculator script, and batch Excel processing with openpyxl.

AutomationBeginner TutorialExcel processing
0 likes · 9 min read
Python for Absolute Beginners: Write Your First Code in 5 Minutes (Tested Guide)