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 raw row cubes funneled into aggregated category bins with a selective HAVING sieve barrier
SQL

SQL GROUP BY and HAVING: Aggregation Functions, Filters, and Common Pitfalls

The evaluation order that decides WHERE versus HAVING, why COUNT(*) and COUNT(col) disagree on left joins, and how ROLLUP subtotals hide in NULL.

SQLAggregationQueries
3D illustration of recursive CTE pipelines chaining modular temporary query blocks into an organizational hierarchy
SQL

SQL CTEs: Common Table Expressions and Recursive WITH Queries Explained

When a CTE is inlined and when it becomes an optimisation fence, plus recursive hierarchies with depth and cycle guards and data-modifying CTEs.

SQLQueriesData Structures
3D illustration of a balanced hierarchical B-tree index node tree directing lookup pointers to table disk blocks
SQL

SQL Indexes: B-Tree, Composite Indexes, and Covering Indexes for Query Performance

Why composite column order decides whether an index is used, how a covering index removes the heap fetch, and which indexes to drop because nothing reads them.

SQLPerformanceIndexing
3D illustration of intersecting relational data tables with glowing overlapping intersection zones showing join match conditions
SQL

SQL Joins: INNER, LEFT, RIGHT, FULL OUTER, and CROSS JOIN with Visual Diagrams

Every join type as a match policy, why a WHERE clause on the right table turns LEFT into INNER, and how row multiplication inflates every aggregate.

SQLRelational DatabaseQueries
3D illustration of partitioned data rows evaluated across sliding window frames with glowing rank badge tags
SQL

SQL Window Functions: ROW_NUMBER, RANK, DENSE_RANK, and LEAD/LAG Explained

How the four ranking and offset functions differ on ties, why the default RANGE frame makes running totals repeat, and how LAG builds gap-and-island detection.

SQLDatabaseAnalytics
3D illustration of an immutable string byte slice decomposing into variable-width UTF-8 rune characters
Go

Go Strings, Runes, and Bytes: UTF-8 Encoding, Conversion, and Memory

Bytes versus runes, len that counts bytes, slicing that splits characters, Builder for linear concatenation, and normalization the standard library omits.

GoStringsUTF-8
3D illustration of channel ports polled by a central multiplexer with a default bypass and timeout timer
Go

Go select Statement: Non-Blocking Operations, Timeouts, and Nil Channels

Random choice among ready cases, non-blocking polls with default, nil channels that disable a case, timer reuse, and labeled breaks out of a loop.

GoConcurrencyControl Flow
3D illustration of a dependency tree running package init functions in topological order before main
Go

Go init Function: Package Initialization Order, Imports, and Side Effects

What runs before main, the order across imports and files, why init cannot return an error, and the sync.Once replacement that can be tested.

GoArchitectureRuntime
3D illustration of a Go struct converting bidirectionally into JSON streams through tagged field conduits
Go

Go JSON: Marshaling, Unmarshaling, Struct Tags, and Custom Parsers

Struct tags, omitempty that skips false and zero, custom marshalers without recursion, RawMessage for tagged unions, and float64 precision loss.

GoJSONSerialization
3D illustration of binary bit flags 1, 2, 4, 8 shifting upward with glowing iota counter increments
Go

Go iota: Enumerations, Bitmask Flags, and Constant Expressions

How iota advances per const line, typed enums with gaps, bit flags with 1 << iota, and the unit scale pattern that shifts with one blank line.

GoConstantsBitmask