Database Administration
MySQL, SQL Server, Oracle, SQLite and recovery notes · 21 notes
GetModNest reference library
Technical Archive
Archived guides for databases, web deployment, AI environments, game servers and developer tooling. These notes are retained as reference material while the main site focuses on B2B export acquisition through SEO, GEO and paid ads.
Explore the Archive
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 Archived Articles
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 ->…
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.