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 30 of 397Docker Networking: Bridge, Host, Overlay Networks, and Port Mapping
Why localhost inside a container is the container, why the default bridge has no DNS, and what -p on 0.0.0.0 exposes to the network.
Docker Volumes vs Bind Mounts: Data Persistence, tmpfs, and Permissions
Which storage survives what, why bind-mount permissions fail with the wrong uid, and the helper-container pattern for backing up a volume.
Docker Multi-Stage Builds: Image Size Optimization and Production Security
Separating build tools from runtime artefacts, what scratch images forget to copy, cache mounts, and multiple targets from one Dockerfile.
Docker Compose: docker-compose.yml Syntax, Services, Networks, and Volumes
depends_on starts containers but does not wait for readiness, .env configures the YAML rather than the container, and down -v deletes your data.
Dockerfile Syntax: FROM, RUN, CMD vs ENTRYPOINT, and Best Practices
What each instruction creates, why shell-form CMD costs you ten seconds on every stop, and how layer caching and COPY ordering decide build time.
SQL NULL Handling: COALESCE, NULLIF, IS NULL, and Three-Valued Logic
Why every comparison with NULL is UNKNOWN, why NOT IN can return nothing, and how unique indexes, sorting and NOT NULL migrations behave with NULL.
SQL UPSERT: INSERT ON CONFLICT, MERGE Statements, and Duplication Handling
The dialect split between ON CONFLICT, ON DUPLICATE KEY UPDATE and MERGE, why DO NOTHING breaks RETURNING, and the deadlocks bulk upserts cause.
SQL CASE WHEN: Conditional Logic in SELECT, WHERE, and UPDATE Statements
Searched versus simple CASE, the omitted ELSE that writes NULL in an UPDATE, branch type unification, and pivoting rows into columns.
SQL Transactions: ACID Properties, Isolation Levels, and Deadlock Prevention
Which anomaly each isolation level still allows, why READ COMMITTED permits lost updates, and the lock ordering plus retry loop every deadlock needs.
SQL Subqueries: Correlated vs Uncorrelated, EXISTS, IN, and Performance
What makes a subquery run once versus once per row, why NOT IN returns nothing when the inner column has a NULL, and when IN beats a join.