Code snippets

137 snippets

• PHP Tested

  Decode JSON safely in PHP

  Parse JSON with exceptions on error and a depth limit, instead of silently getting null.

• SQL Tested

  Running total with a window function

  Compute cumulative sums per group without self-joins using SUM() OVER (PARTITION BY ... ORDER BY ...).

• JavaScript Tested

  Retry an async operation with exponential backoff

  Retry a failing promise-returning function with growing, jittered delays and a retry predicate.

• Python Tested

  Retry decorator with exponential backoff

  Re-run a flaky function a limited number of times with growing delays, only for chosen exception types.

• TypeScript Tested

  A typed Result type for error handling without exceptions

  Model success and failure as a discriminated union so callers must handle both cases.

• HTML

  Responsive images with srcset and the picture element

  Serve modern formats and the right image size per device, with explicit dimensions to prevent layout shift.

• CSS

  Responsive card grid without media queries

  Use CSS Grid with repeat(auto-fit, minmax()) so cards wrap automatically at any width.

• PHP

  Query a database with PDO prepared statements

  Connect with PDO in exception mode and bind parameters to prevent SQL injection.

• JavaScript Tested

  Fetch every page of a paginated API with an async generator

  Iterate cursor-paginated API results with for await, loading pages lazily and stopping early when needed.

• CSS

  Truncate text with an ellipsis (single and multi-line)

  Clip long text to one line or N lines with an ellipsis using text-overflow and line-clamp.

• SQL Tested

  Keyset (cursor) pagination instead of OFFSET

  Page through large tables quickly and stably by filtering on the last seen sort key.

• TypeScript Tested

  Safely narrow unknown JSON with type guards

  Replace "as any" on parsed JSON with small type guards that check shape at runtime.