The Ultimate
Snippet Library.

Custom `useList` Hook for Array State Management

Create a powerful custom `useList` hook in React to efficiently manage arrays of items, enabling add, remove, and update operations with ease.

Querying JSON Data Stored in a Column

Learn how to efficiently query and extract specific values from JSON data stored within a database column, common in modern web applications.

Upserting Records (Insert or Update on Conflict)

Discover how to perform an 'upsert' operation, inserting a new record if it doesn't exist or updating it if a unique constraint conflict occurs, streamlining data synchronization.

Concatenating Grouped Strings (GROUP_CONCAT / STRING_AGG)

Efficiently combine multiple related string values from a grouped set of rows into a single comma-separated string within your SQL query, useful for tag lists.

Simplifying Complex Queries with Common Table Expressions (CTEs)

Improve SQL query readability and structure complex logic by breaking down queries into logical, named sub-statements using Common Table Expressions (CTEs).

Aggregating Sales Data by Month and Year

Learn to aggregate and analyze data by specific time periods like month and year, and filter results within a date range, essential for reporting and analytics.

Validating Email Addresses with Regex

Learn to validate email address formats in JavaScript using a robust regular expression, ensuring user input meets standard email criteria for forms.

Validating and Extracting URLs with Regex

Discover how to validate URLs and extract them from text using JavaScript and a regular expression, essential for link handling and content processing.

Enforcing Password Strength with Regex

Implement robust password strength validation in JavaScript using regex to ensure passwords include uppercase, lowercase, numbers, and special characters.

Extracting Hashtags and Mentions from Text

Learn to easily extract hashtags (#) and mentions (@) from user-generated text using JavaScript regex, perfect for social media features.

Cleaning and Sanitizing Text Input with Regex

Effectively clean and sanitize user input by removing extra spaces, HTML tags, or unwanted characters using JavaScript regular expressions.

Finding Duplicate Rows in a Table

Learn to identify and retrieve duplicate records in your SQL database based on one or more columns, essential for data cleansing and integrity checks.