The Ultimate
Snippet Library.

Efficiently Handle Data Inserts or Updates with UPSERT

Learn to perform an atomic "UPSERT" operation in SQL, either inserting a new row or updating an existing one based on unique constraints, crucial for web app data management.

Identify Records Lacking Related Data Using LEFT JOIN

Discover how to effectively query and identify parent records that do not have any corresponding child records in a related table using a LEFT JOIN and IS NULL check.

Aggregate Multiple Related String Values into a Single Column

Learn to concatenate multiple string values from grouped rows into a single, comma-separated string within your SQL query, useful for tag lists or multi-valued attributes.

Safely Process Queue Items Concurrently Using SELECT FOR UPDATE

Implement a robust queue processing mechanism in SQL, ensuring that only one worker can claim and process a task at a time, preventing race conditions.

Rank Items Within Categories Using SQL Window Functions

Learn to assign ranks to items within distinct groups (e.g., products within categories by sales) using RANK() or DENSE_RANK() window functions in SQL.

Implement Essential HTTP Security Headers with Node.js Helmet.js

Strengthen your Node.js Express application's security by adding critical HTTP headers like CSP, HSTS, and X-Frame-Options using the Helmet.js middleware.

Configure Secure and HttpOnly Cookies in JavaScript (Server-Side)

Learn to set essential `HttpOnly`, `Secure`, and `SameSite` attributes for cookies in Node.js, bolstering web application security against XSS and CSRF attacks.

Safely Sanitize User-Generated HTML to Prevent XSS Attacks with DOMPurify

Protect your web application from Cross-Site Scripting (XSS) by securely sanitizing user-provided HTML content on the client-side using the robust DOMPurify library.

Optimize React Input with a Custom `useDebounce` Hook

Implement a `useDebounce` hook in React to delay state updates or function calls, significantly improving performance for search inputs and frequent events.

Track Previous React Prop or State with `usePrevious` Hook

Create a custom `usePrevious` React hook to easily access the prior value of a prop or state variable, useful for comparing changes in `useEffect`.

Detect Clicks Outside a React Component with `useOutsideClick`

Build a custom `useOutsideClick` React hook to close modals, dropdowns, or dismiss elements when a user clicks anywhere outside a referenced component.

Track Browser Window Size with a `useWindowSize` React Hook

Create a `useWindowSize` React hook to dynamically get and respond to changes in the browser window's dimensions, perfect for responsive component rendering.