The Ultimate
Snippet Library.

Convert Newlines to HTML <br> Tags

Automatically replace all newline characters (`\n`, `\r\n`) in a string with HTML `<br>` tags for web display.

Validate String for Alphanumeric Characters (and optional spaces/hyphens)

Verify if a string contains only letters, numbers, spaces, and hyphens, commonly used for validating usernames or simple text inputs.

Find Top N Items Per Group Using Window Functions

Discover how to use SQL window functions like `ROW_NUMBER()` to efficiently retrieve the top N items for each distinct group within your dataset.

Perform Upsert (Insert or Update) Operations

Master the upsert pattern in SQL to either insert new records or update existing ones based on a unique constraint, preventing data duplication.

Pivot Rows to Columns Using Conditional Aggregation

Transform your data from rows into columns, or "pivot" it, using SQL's conditional aggregation with `CASE` statements for better reporting.

Responsive CSS Grid Layout with `auto-fit` and `minmax`

Create dynamic and responsive grid layouts where items automatically adjust their width and quantity based on the available space using `repeat(auto-fit, minmax(...))` for optimal display.

Two-Column Layout with Grid Areas

Design a flexible two-column layout, such as a main content area with a sidebar, using CSS Grid `grid-template-areas` for semantic and easy-to-understand structure.

Overlapping Grid Items for Stacking Effects

Create sophisticated stacking or overlay effects by making multiple CSS Grid items occupy the same grid cells, enabling easy layering of content, images, or interactive elements.

Validate Semantic Versioning (SemVer)

Essential regex to accurately validate semantic version numbers (e.g., 1.2.3, 1.0.0-alpha.1) for consistent version management in web projects.

Extract All Links (`href`) from HTML Anchor Tags

Discover how to efficiently extract all URL links from `<a>` tags within an HTML string using a simple yet powerful regular expression in JavaScript.

Validate CSS Hex Color Codes

Quickly validate common CSS hexadecimal color formats (e.g., #FFF, #FFFFFF, FFF, FFFFFF) with a concise regular expression for UI development.

Remove C-style Multi-line Comments

Learn to strip multi-line `/* ... */` comments from code or configuration files using a regular expression, useful for minification or processing.