Results for “Collections & data structures”

JavaCollections

Read a map with a default ↗

Return a fallback when a Java map does not contain a key.

Java✓ Tested

TypeScriptSafe data handling

Read a nested optional value ↗

Avoid dereferencing a missing nested object.

optional chaining✓ Tested

SQLSubqueries & ranked selection

Read a page after a known unique key ↗

SQL: A keyset predicate avoids scanning and discarding an increasing offset on a suitable index.

SQL✓ Tested

SQL ServerSubqueries & ranked selection

Read a page after a known unique key ↗

SQL Server: A keyset predicate avoids scanning and discarding an increasing offset on a suitable index.

SQL Server✓ Tested

PostgresSubqueries & ranked selection

Read a page after a known unique key ↗

Postgres: A keyset predicate avoids scanning and discarding an increasing offset on a suitable index.

Postgres✓ Tested

SQLiteSubqueries & ranked selection

Read a page after a known unique key ↗

SQLite: A keyset predicate avoids scanning and discarding an increasing offset on a suitable index.

SQLite✓ Tested

SQL ServerJSON & results

Read a scalar JSON property ↗

Extract a named value using a JSON path.

JSON_VALUE✓ Tested

PythonFile operations & archives

Read compressed text directly ↗

Python: Open gzip data in text mode with an explicit encoding.

Python✓ Tested

PowerShellStructured formats & encodings

Read JSON into a hashtable ↗

PowerShell: AsHashtable produces dictionary-style results for keys that are data rather than fixed property names.

PowerShell✓ Tested

SQLGetting Started

Read named columns from a table ↗

SQL: Choose the columns needed and request a deterministic row order.

SQL✓ Tested

SQL ServerGetting Started

Read named columns from a table ↗

SQL Server: Choose the columns needed and request a deterministic row order.

SQL Server✓ Tested

PowerShellText & data

Read rows from CSV text ↗

Parse CSV into objects with named properties.

CSV✓ Tested