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 a slow single-row cursor loop beside a wide parallel set pipeline processing many rows at once
SQL

SQL Cursors vs Set-Based Operations: Syntax, Memory, and Performance

Why a row-by-row cursor costs minutes where one UPDATE takes seconds, how server cursors spool to disk, and the set-based replacements for each loop.

SQLQuery OptimizationPerformance
3D illustration of a clock and calendar grid linked by interval arrows crossing time zone meridians with a DST marker
SQL

SQL Date and Time Functions: INTERVAL Arithmetic, Time Zones, and DST

timestamptz versus timestamp, half-open ranges that keep an index, and the daylight saving gaps that make local scheduling wrong once a year.

SQLDate and TimeBest Practices
3D illustration of database rows guarded by lock markers while worker queues skip locked rows and claim free ones
SQL

SQL Row Locking: SELECT FOR UPDATE, SKIP LOCKED, and NOWAIT

How FOR UPDATE locks rows until commit, why the plan decides the lock scope, and the SKIP LOCKED claim-queue pattern that scales to many workers.

SQLTransactionsConcurrency
3D illustration of text tokens passing through concatenation blocks, substring blades and pattern filters into an output row
SQL

SQL String Functions: CONCAT, SUBSTRING, REPLACE, and Pattern Matching

The concatenation and slice functions that differ between engines, why LIKE 'x%' uses an index and '%x%' cannot, plus escaping and NULL rules.

SQLString FunctionsSyntax
3D illustration of hierarchical JSON and JSONB data trees indexed by GIN path operators and query filters
SQL

SQL JSON and JSONB: Functions, Operators, and Indexing Strategies

Why jsonb is the default for queryable documents, when containment can use a GIN index, and the expression-index fixes for scalar lookups.

SQLJSONDatabase
3D illustration of a PID 1 init process reaping orphaned zombie children and forwarding SIGTERM down a process tree
Docker

Docker Init and Zombie Processes: Using --init and Tini for Signal Handling

PID 1 ignores SIGTERM without a handler, so docker stop waits ten seconds and kills with exit 137. --init, tini -g, and clearing defunct children.

DockerProcess ManagementReliability
3D illustration of a local Docker CLI switching between a unix socket and remote daemon endpoints over SSH tunnels
Docker

Docker Context: Managing Multiple Daemons, Remote SSH, and TLS Sockets

One CLI, many daemons: ssh:// and TLS contexts, the bind mounts that point at the remote host, and why port 2375 without TLS is root access.

DockerCLIRemote Management
3D illustration of a container sandbox reinforced by a non-root privilege wall, dropped capability chips and a seccomp syscall shield
Docker

Docker Security: Non-Root Users, Linux Capabilities, and Seccomp Profiles

Containers start as root with 14 capabilities. How to run non-root, drop ALL caps and add one, keep seccomp, and why port 80 stops working.

DockerSecurityContainers
3D illustration of structured container log streams flowing into size-capped rotating disk log files with driver filter funnels
Docker

Docker Logging: Drivers, Log Rotation, and json-file Configuration

json-file has no size limit by default, which fills disks. Rotation options, why remote drivers break docker logs, and non-blocking mode's dropped lines.

DockerLoggingDevOps
3D illustration of encrypted secret credentials mounted in-memory into isolated container vaults with no plaintext leaks
Docker

Docker Secrets and Configs: Secure Management in Compose and Production

Compose secrets are bind mounts, not encryption; Swarm secrets are tmpfs. How to keep credentials out of ENV, ARG and image layers, and rotate them.

DockerSecurityDevOps