All syntax guides
Short, practical guides on programming syntax, language fundamentals, and the tools developers reach for every day.
3,965 guides across 14 topics
Topics
Popular guides
Most readLatest guides
Page 29 of 397SQL PIVOT and UNPIVOT: Row-to-Column and Column-to-Row Data Transformation
The literal column list, the NULL rows that UNPIVOT drops, and the type coercion that turns dates into strings — plus the portable FILTER form.
SQL EXPLAIN and EXPLAIN ANALYZE: Reading Query Execution Plans for Optimization
Estimated rows versus actual rows is the whole game: reading plans, multiplying by loops, interpreting buffers, and fixing the statistics first.
SQL Triggers: BEFORE, AFTER, INSTEAD OF Syntax and Common Pitfalls
A BEFORE trigger that returns NULL deletes the row without an error, bulk updates fire it once per row, and TRUNCATE skips it entirely.
SQL Stored Procedures vs Functions: Syntax, Parameters, and Execution Differences
Procedures act, functions compute: transaction control, IN/OUT parameters, volatility that lies, and the plan caching that makes procedures slow.
SQL Views vs Materialized Views: Syntax, Refresh Strategies, and Performance
Why a view is inlined into your query while a materialized view is a cached table, how CONCURRENTLY refreshes work, and the RLS trap hidden in views.
Docker Cleanup: docker system prune, Dangling Images, and Reclaiming Disk Space
What each prune flag actually deletes, why -a removes your base images, and the log files that survive every prune.
Docker Environment Variables: ENV vs ARG, .env Files, and Order of Precedence
ARG exists only during the build, ENV ships with the image, and Compose's .env configures the YAML rather than the container. Plus secret handling.
Docker HEALTHCHECK: Syntax, Intervals, Retries, and Status Monitoring
The four timing flags, why start-period prevents deploy flapping, and the reason Docker reports unhealthy without ever restarting anything.
Docker Buildx: Building Multi-Architecture Images (AMD64 & ARM64) Explained
One tag, several architectures: the driver that supports it, QEMU versus cross-compilation, registry cache, and reading the manifest list.
Docker CLI: docker run vs exec vs attach, Interactive Shells, and Debugging
run creates, exec borrows, attach forwards your keystrokes to PID 1. Plus exit-code diagnosis and debugging an image with no shell.