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 28 of 397SQL 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.
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.
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.
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.
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.
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.
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.
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.
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.
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.