Results for “Form serialization & state”
Small, practical examples. Search by task or narrow things down below.
Enable and use foreign keys
Turn on relationship enforcement for the connection.
foreign keys✓ Tested
Encode and decode binary data as Base64
Python: Use Base64 when a text format must carry bytes; it is encoding, not encryption.
Python✓ Tested
Enforce a numeric range at a function boundary
PowerShell: ValidateRange performs argument validation before work begins.
PowerShell✓ Tested
Exclude a purely decorative image from accessible content
HTML: An empty alt indicates that this image adds no information beyond nearby content.
HTML✓ Tested
Expand a JSON array into rows
Iterate array elements using a table-valued function.
json_each✓ Tested
Expand an abbreviation with explanatory text
HTML: The title attribute supplies the full form while nearby text remains useful without hovering.
HTML✓ Tested
Expand an array into rows
Use WITH ORDINALITY to retain original element order.
unnest✓ Tested
Extract a JSON field
Read a scalar value from JSON text.
json_extract✓ Tested
Extract part of a date
Read a calendar component with EXTRACT.
EXTRACT✓ Tested
Extract part of a string
Use one-based positions with substr.
substr✓ Tested
Filter by a numeric comparison
SQL: Keep rows whose quantity exceeds a chosen threshold.
SQL✓ Tested
Filter by a numeric comparison
SQL Server: Keep rows whose quantity exceeds a chosen threshold.
SQL Server✓ Tested