Blog (Recently Updated, Page 54) | pkglog

Blog

Recently Updated

2024년 2월 12일 18 min read Intermediate Guide

MongoDB Schema Design: Embedded vs Referenced Documents

Choose embedded vs referenced collections using document size, read/write patterns, 1:N growth, and consistency—plus buckets, partial updates.
2024년 9월 27일 18 min read Intermediate Tutorial

MySQL Slow Query Tuning with EXPLAIN

Read MySQL EXPLAIN output, tune with type, key, rows, and Extra; use EXPLAIN ANALYZE, composite indexes, ANALYZE TABLE, and covering.
2024년 7월 8일 22 min read Intermediate Guide

HTTP: Complete Guide | HTTP/1.1· HTTP/2

HTTP requests and responses, methods and status codes, HTTP/2 multiplexing and HTTP/3 over QUIC, HTTPS, caching, and REST API design—2026 practical guide.
2026년 3월 25일 20 min read Intermediate Guide

SSH: Secure Remote Access | Keys· ProxyJump

SSH key exchange and authentication, public key setup, ssh config, local and remote port forwarding, ProxyJump, SCP/SFTP, and hardening with OpenSSH.
2024년 3월 19일 20 min read Intermediate Guide

TCP: Complete Guide | Handshake· Flow & Congestion Control

TCP connections, sliding windows, Reno/CUBIC congestion control, Nagle, TCP_NODELAY, keepalive—reliable transport and production socket tuning.
2024년 8월 22일 17 min read Intermediate Guide

UDP in Practice | Low Latency, DNS, Games, Streaming & QUIC

Connectionless UDP: headers, checksums, ports, app-level reliability and ordering, and how HTTP/3 QUIC builds on UDP—realtime-focused guide.
2024년 6월 19일 22 min read Advanced Guide

WebRTC: Realtime Communication | Signaling· ICE

Browser P2P realtime: SDP signaling, ICE candidates, STUN and TURN, DTLS handshake, SRTP media—NAT traversal and security for production WebRTC.
2025년 2월 28일 22 min read Intermediate Guide

Next.js App Router: SSR, SSG, and ISR

Choose SSR, SSG, and ISR in the Next.js App Router: fetch cache, revalidate, Route Segment Config, and practical criteria for content and personalization.
2025년 6월 10일 18 min read Intermediate Tutorial

Nginx Reverse Proxy Configuration for Node.js | SSL

Nginx reverse proxy for Node.js: upstream blocks, proxy headers, TLS with Let’s Encrypt, WebSocket upgrades, rate limits, and trust proxy.
2025년 12월 11일 16 min read Beginner Tutorial

Python Environment Setup — Complete Guide

Set up Python on Windows/Mac/Linux: install Python 3, pip, venv, VS Code, PyCharm, requirements.txt, Poetry, and a clean project layout for beginners.