The Ultimate
Snippet Library.

Performing Conditional Updates with CASE WHEN

Learn how to update multiple rows with different values based on specific conditions within a single SQL UPDATE statement using the powerful CASE WHEN clause.

Identify and Remove Duplicate Rows While Preserving One

Discover an efficient SQL method to find and delete duplicate records from a table, ensuring one unique entry is retained based on criteria like minimum ID.

Extracting and Querying Data from JSON Columns

Learn how to query and extract specific values from JSON data stored in database columns using functions like `->>`, `->`, `JSON_EXTRACT`, or `JSON_VALUE`.

Implementing Basic Full-Text Search with MATCH AGAINST

Learn to perform keyword-based searches across multiple text columns in MySQL using the `MATCH AGAINST` clause for efficient full-text querying.

Calculate Running Totals (Cumulative Sum) without Window Functions

Discover how to compute a running total or cumulative sum in SQL using a self-join and aggregation, offering an alternative to window functions.

Robust Directory Creation and Cleanup

Automate safe creation or cleanup of project directories. This bash snippet ensures directories exist and can be safely reset, crucial for build or deployment scripts.

Advanced CLI Argument Parsing with getopts

Build powerful, configurable bash scripts with `getopts`. This snippet demonstrates parsing short and long options, handling arguments for robust script execution.

Batch Rename Files Using Bash Loops and Patterns

Efficiently rename multiple files in a directory using bash scripting. This snippet renames files by adding a prefix or replacing parts of their names.

Load Configuration from Environment Variables with Defaults

Securely manage application configuration in bash scripts. This snippet loads settings from environment variables, providing default values for flexibility.

Automate Web Project File Permissions (chmod/chown)

Secure web directories and files by automating correct permissions. This bash script sets common `chmod` and `chown` settings for web server users.

Create a Custom useDebounce Hook for Input

Implement a reusable `useDebounce` custom hook in React to delay state updates from user input, optimizing performance for search bars and type-ahead features.

Global Theme Toggling with useContext

Easily implement a global theme toggling feature in React using `useContext` and `useState` hooks, avoiding prop drilling for application-wide styles.