Database Administration
MySQL, SQL Server, Oracle, SQLite and recovery notes · 21 notes
Practical Tech & Game Server Notes for Real-World Projects
Hands-on notes for databases, web deployment, AI environments, Minecraft servers, game backend services, and developer workflows.
Explore by Topic
Web App Deployment
Flask, Java Web, Spring Boot, Vue and server setup · 2 notes
AI & Deep Learning
PyTorch, computer vision, LLMs and model environments · 7 notes
Developer Environment
Windows, Linux, macOS, Docker, VS Code and Java tooling · 5 notes
Game Server Development
Minecraft servers, plugins, mods, GTA V FiveM and game backend services · 2 notes
Latest Project Notes
Database Administration
SQL Server SUSPECT Database Recovery with DBCC CHECKDB
A practical SQL Server SUSPECT database recovery case involving error 926, EMERGENCY mode, DBCC CHECKDB repair, transaction log rebuild, and recovery to ONLINE MULTI_USER state.
Game Server Development
Private Minecraft Server Setup on Ubuntu with Docker
A practical private Minecraft server setup guide using Ubuntu, Docker Compose, itzg/minecraft-server, TCP port 25565, PC client connection, RCON, and server data management.
AI & Deep Learning
AI Portrait Photo Tool with Background Removal for ID and Resume Photos
A practical AI portrait photo tool workflow for ID photos, resume photos, background removal, alpha matting, face detection, Flask upload, preview, download, and report output.
AI & Deep Learning
Biomedical Image Segmentation with BiomedParse V2 on Windows
A practical biomedical image segmentation setup with BiomedParse V2 on Windows, including CUDA PyTorch, Detectron2, Hugging Face cache, local model weights, configuration fixes, and batch inference.
AI & Deep Learning
Strength Prediction Model with PyKAN Regression
A practical strength prediction model workflow using PyKAN regression, input variables such as a/R and Jingt, KAN training, R2 evaluation, feature influence analysis, and Jupyter prediction usage.
Game Server Development
2048 AI Assistant for Move Recommendations
A practical 2048 AI assistant workflow for move recommendations using a C++ decision engine, Python ctypes integration, Flask API endpoints, board evaluation, and browser-based testing.
Developer Environment
Setting Up a Python Development Environment on MacBook Air with Homebrew, VS Code, PyCharm, and venv
Overview This article documents a Python development environment setup on a MacBook Air using Homebrew, Python, VS Code, PyCharm, and venv. macOS -> Homebrew -> Python 3.14 ->…
Web App Deployment
Bioinformatics BLAST Web App Deployment with Flask and MySQL
A practical BLAST web app deployment workflow for bioinformatics sequence search using Flask, MySQL, uWSGI, Nginx, NCBI BLAST+, Linux paths, permissions, and runtime logs.
AI & Deep Learning
Underwater Object Detection with RF-DETR and Custom COCO Data
A practical underwater object detection training case using RF-DETR and a custom COCO dataset, covering marine organism classes, PyTorch CUDA setup, category_id fixes, CUDA errors, and metric analysis.
Developer Environment
Setting Up VS Code C/C++ Debugging with MinGW and GDB on Windows
Overview This article documents how to configure Visual Studio Code on Windows for C/C++ development using MinGW GCC and GDB. write C code -> build with gcc ->…