The Ultimate
Snippet Library.

Extract All Link URLs from HTML

A JavaScript regex snippet to efficiently find and extract all `href` attribute values from `<a>` tags within an HTML string for scraping or content processing.

Parse URL into Components (Protocol, Host, Path, Query)

A JavaScript regex solution to break down a given URL string into its core components: protocol, host, port, path, and query parameters.

Custom React Hook for Debouncing Values

Optimize performance by delaying state updates with a custom React useDebounce hook, preventing excessive re-renders and API calls during rapid input.

Detect Clicks Outside a React Component

Create a custom React hook `useClickOutside` to easily detect clicks that occur outside a specific DOM element, useful for closing modals or dropdowns.

Track Previous Value of React State or Prop

Keep track of the previous value of any React state or prop using a simple `usePrevious` custom hook, enabling comparisons and conditional logic.

Get Dynamic Window Dimensions in React

Access and react to changes in the browser window's dimensions with a custom `useWindowSize` React hook, enabling responsive UI components.

Finding Records Without Related Data (Anti-Join)

Discover how to efficiently find records in one table that do not have a corresponding entry in another related table using an anti-join pattern.

Calculate Changes Between Consecutive Rows Using LAG

Learn to use SQL window functions like `LAG` or `LEAD` to compare a value from the current row with a value from a preceding or succeeding row.

Implement Basic Full-Text Search (PostgreSQL Example)

Discover how to perform basic full-text searches on text columns in your database, returning results based on relevance (PostgreSQL specific).

Perform Conditional Updates on Multiple Columns

Learn how to update multiple columns with different values based on various conditions within a single `UPDATE` statement using `CASE` expressions.

Querying Hierarchical Data with Recursive CTEs

Learn to traverse and query hierarchical data like organizational structures, product categories, or forum threads using SQL's powerful Recursive Common Table Expressions.

Performing Conditional Aggregation for Dynamic Pivoting

Transform rows into columns and summarize data based on specific conditions using SQL's CASE WHEN expressions within aggregate functions for insightful reports.