The Ultimate
Snippet Library.

Calculate Running Totals Per Group using SQL Window Functions

Utilize SQL window functions with `SUM() OVER (PARTITION BY ... ORDER BY ...)` to efficiently compute cumulative sums or running totals for data within distinct categories or groups.

Transform Rows to Columns (Pivot Data) with SQL `CASE` Statements

Learn to dynamically pivot data in SQL, converting unique row values into distinct columns using conditional aggregation with `SUM()` and `CASE` statements for clearer reporting.

Construct and Query JSON Data in MySQL

Master MySQL's JSON functions like `JSON_OBJECT`, `JSON_ARRAYAGG`, and `JSON_EXTRACT` to dynamically create, manipulate, and query JSON data directly within your database tables.

Get and Set Custom Data Attributes on a DOM Element

Efficiently retrieve and update custom data attributes (data-*) on any HTML element in the DOM using JavaScript's dataset property for dynamic behavior.

Update Multiple Text Contents of Selected Elements

Learn to efficiently update the text content of multiple elements in the DOM using querySelectorAll and textContent, perfect for lists or repeated elements.

Smoothly Scroll to a Specific Element with JavaScript

Implement smooth scrolling to any target element on the page using JavaScript's scrollIntoView method for enhanced user navigation and experience.

Optimize Batch DOM Appends with DocumentFragment

Improve performance of adding many elements to the DOM by using DocumentFragment to minimize reflows and repaints with a single DOM insertion.

Fetching All Pages from a Paginated API in JavaScript

Learn how to programmatically fetch all available data from a paginated API endpoint using JavaScript's Fetch API, iterating through pages until complete.

Uploading Files to an API with FormData in JavaScript

Learn to send files, such as images or documents, to a backend API using JavaScript's Fetch API and the FormData object, perfect for file uploads.

Retrying Failed API Requests with Exponential Backoff

Implement a robust retry mechanism with exponential backoff for API calls in JavaScript, enhancing application resilience against transient network or server issues.

Authenticated GET Request with Bearer Token in JavaScript

Learn to make secure API GET requests using JavaScript's Fetch API, including how to pass an Authorization Bearer token header for authentication.

Sending JSON Data with a POST Request in JavaScript

Master sending data to APIs using JavaScript's Fetch API with a POST request, including how to correctly set headers and serialize a JSON body.