Results for “Context & shared state”

SQL ServerReporting & grouped calculations

Calculate each group’s numeric spread ↗

SQL Server: Subtract MIN from MAX to report the difference between extremes.

SQL Server✓ Tested

PostgresReporting & grouped calculations

Calculate each group’s numeric spread ↗

Postgres: Subtract MIN from MAX to report the difference between extremes.

Postgres✓ Tested

SQLiteReporting & grouped calculations

Calculate each group’s numeric spread ↗

SQLite: Subtract MIN from MAX to report the difference between extremes.

SQLite✓ Tested

SQL ServerTransactions & tables

Catch a T-SQL error ↗

Handle an expected conversion error in TRY/CATCH.

TRY CATCH✓ Tested

Bash ScriptsDiagnostics & defensive scripting

Check a script’s syntax without executing its body ↗

Bash Scripts: bash -n parses commands but does not run ordinary script statements.

Bash Scripts✓ Tested

PythonFile operations & archives

Clean up a temporary directory automatically ↗

Python: Use TemporaryDirectory as a context manager so cleanup also happens after exceptions.

Python✓ Tested

SQLJoins & subqueries

Combine matching rows with INNER JOIN ↗

Read product names with their matching stock values.

INNER JOIN✓ Tested

SQLBulk changes & set operations

Combine results while retaining duplicates ↗

SQL: UNION ALL does not spend work removing equal rows.

SQL✓ Tested

SQL ServerBulk changes & set operations

Combine results while retaining duplicates ↗

SQL Server: UNION ALL does not spend work removing equal rows.

SQL Server✓ Tested

PostgresBulk changes & set operations

Combine results while retaining duplicates ↗

Postgres: UNION ALL does not spend work removing equal rows.

Postgres✓ Tested

SQLiteBulk changes & set operations

Combine results while retaining duplicates ↗

SQLite: UNION ALL does not spend work removing equal rows.

SQLite✓ Tested

SQLChange & combine data

Combine results without duplicates ↗

Merge compatible result sets with UNION.

UNION✓ Tested