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 containers communicating across isolated virtual bridge switches and host network port gateways
Docker

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

DockerNetworkingDevOps
3D illustration contrasting managed Docker volume storage vaults with host filesystem bind mount pipelines
Docker

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.

DockerStorageDevOps
3D illustration of heavy build-tool stages stripping down into a lightweight minimal production runtime container
Docker

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.

DockerBuild OptimizationPerformance
3D illustration of interconnected container cubes coordinated by a central YAML master blueprint node
Docker

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.

DockerDocker ComposeOrchestration
3D illustration of stacked Dockerfile instruction layers building an immutable container image with runtime command injectors
Docker

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.

DockerDevOpsContainers
3D illustration of missing NULL voids intercepted by COALESCE fallback bridges with a ternary truth table TRUE FALSE UNKNOWN
SQL

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.

SQLType SystemBest Practices
3D illustration of incoming data rows updating existing duplicate keys or inserting fresh records without collision errors
SQL

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.

SQLData ManipulationDML
3D illustration of branching conditional switches directing value transformations into custom calculated columns
SQL

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.

SQLControl FlowSyntax
3D illustration of atomic transaction capsules protected by escalating isolation level vault walls with deadlock detection monitors
SQL

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.

SQLTransactionsConcurrency
3D illustration of an inner nested query loop validating outer query rows with green boolean EXISTS beacon scanners
SQL

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.

SQLQuery OptimizationPerformance