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
Designing a Microsoft Access Academic Management Database
Overview This article documents a Microsoft Access database design for a small academic management system. The goal is to manage departments, majors, classes, students, teachers, courses, course selections,…
Web App Deployment
Email Telegram Bot for Two-Way Mail Reply Automation
A practical Email Telegram Bot workflow for forwarding incoming emails to Telegram, mapping replies to original senders, and sending email responses through IMAP, SMTP, fetchmail, msmtp, Python, and Linux.
Database Administration
Migrate MySQL Database from CentOS to Ubuntu
A practical MySQL 8.0 database migration case from CentOS Docker to Ubuntu, covering mysqldump export, scp transfer, character set validation, and import verification.
Database Administration
MySQL Production Deployment with Replication and VIP Failover on Linux
A practical MySQL 8.0 production deployment case on Linux, covering binary installation, my.cnf configuration, primary-replica replication, Keepalived VIP failover, and mysqldump backup restore.
Database Administration
SQL Server Database Synchronization with Transactional Replication
A practical SQL Server 2022 cross-network database synchronization case using transactional replication and push subscription, covering Publisher, Distributor, Subscriber setup, agent configuration, and validation.
AI & Deep Learning
Build an Enterprise WeChat AI Bot with Dify and Docker
A practical Enterprise WeChat AI Bot deployment workflow using Dify, Docker Compose, Flask callback service, Nginx reverse proxy, Dify API integration, and knowledge base answers on Linux.
AI & Deep Learning
Deploying DeerFlow 2.0 Enhanced Locally on Windows with DeepSeek, Tavily, Docker, RAG, Tools, and Sandbox
Overview This article documents a Windows local deployment process for DeerFlow 2.0 Enhanced. The goal was to run DeerFlow locally with Docker, configure an LLM provider, enable web…
AI & Deep Learning
Installing and Configuring OpenClaw on Windows with Kimi API and Feishu Bot Integration
Overview This article documents a practical setup process for installing OpenClaw on Windows and integrating it with Kimi / Moonshot AI and a Feishu bot. The setup involved…
Developer Environment
Building a Java JDBC MySQL Study Plan Manager with Maven and DAO-Based CRUD
Overview This article documents a small Java project that connects to a MySQL database through JDBC and implements basic CRUD operations for a study plan manager. The goal…
Developer Environment
Setting Up a Windows 11 Local Development Database Environment with MySQL, MongoDB, and Redis
Overview This article documents a Windows 11 local development database setup involving MySQL, MongoDB, and Redis. The goal was to prepare the database environment required by a development…