The Ultimate
Snippet Library.

Find Top N Records Per Group with ROW_NUMBER()

Efficiently retrieve the top N items (e.g., latest comment, highest score) for each distinct group within your dataset using the powerful `ROW_NUMBER()` window function.

Upsert (Insert or Update) Data

Learn how to perform an 'upsert' operation, inserting a new record if it doesn't exist, or updating an existing one, using database-specific syntax like `ON DUPLICATE KEY UPDATE` or `ON CONFLICT`.

OAuth 2.0 Client Credentials Flow (Python)

Securely authenticate server-to-server API calls using Python with the OAuth 2.0 Client Credentials flow for automated backend access.

Idempotent API Requests with Idempotency-Key (Node.js)

Prevent duplicate operations in API integrations by sending unique 'Idempotency-Key' headers, crucial for reliable transaction processing in Node.js.

Uploading Files to API with FormData (JavaScript)

Upload files efficiently to a web API from the browser using JavaScript's Fetch API and FormData, handling 'multipart/form-data' content type.

Consuming a GraphQL API (JavaScript)

Perform basic GraphQL queries and mutations from a JavaScript client using the Fetch API, demonstrating efficient data retrieval from GraphQL endpoints.

Simple Client-Side API Request Queue with Delay (JavaScript)

Implement a basic JavaScript queue to process API requests with a delay, preventing rate limit issues for external services without complex retry logic.

React usePrevious Hook for Storing Past State

Learn how to create a custom React hook, `usePrevious`, to store and retrieve the previous value of any state or prop, enabling advanced comparison logic.

React useThrottle Hook for Limiting Function Calls

Implement a custom `useThrottle` React hook to limit how often a function can execute, improving performance for events like scrolling or resizing.

React useWhyDidYouUpdate Hook for Debugging Renders

Create a `useWhyDidYouUpdate` hook to log component re-renders and identify which prop or state changes are causing them, aiding performance debugging.

React useMediaQuery Hook for Responsive UI Logic

Build a `useMediaQuery` React hook to integrate CSS media queries directly into your component logic, enabling dynamic, responsive UI behaviors.

React useIsMounted Hook for Safe State Updates

Create a `useIsMounted` React hook to track a component's mount status, preventing state updates on unmounted components and avoiding memory leaks.