Pages

Topics

Tools

↑↓navigate↵openescclose

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

Latest guides

3D illustration of tabular data rows rotating into columnar aggregates and back with a 3D coordinate matrix
SQL

SQL 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.

SQLData TransformationQueries
3D illustration of an analytical query cost tree with sequential and index scan nodes carrying execution time badges
SQL

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.

SQLQuery OptimizationPerformance
3D illustration of automated event tripwires firing BEFORE and AFTER insert and update into an audit logging pipeline
SQL

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.

SQLTriggersAutomation
3D illustration of a procedural batch execution workflow contrasted with deterministic scalar and table-valued function pipes
SQL

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.

SQLDatabase FunctionsStored Procedures
3D illustration of a virtual dynamic query view compared with disk-cached materialized view data blocks and a background refresh engine
SQL

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.

SQLViewsPerformance
3D illustration of vacuum cleaners clearing dangling stopped containers and orphaned cache layers into reclaimed disk space
Docker

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.

DockerMaintenanceStorage
3D illustration of build-time ARG values and runtime ENV injection pipelines resolving through hierarchical precedence gates
Docker

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.

DockerConfigurationDevOps
3D illustration of container heartbeat monitors emitting glowing green pulse waves with retry counter valves
Docker

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.

DockerHealth ChecksReliability
3D illustration of a single buildx builder compiling container manifests for both AMD64 and ARM64 silicon chips
Docker

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.

DockerBuildxArchitecture
3D illustration of interactive terminal windows connecting into live running container processes for debugging
Docker

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.

DockerCLIContainers