The Ultimate
Snippet Library.

React `useWindowSize` Hook for Dynamic Layouts

A custom React hook to track and provide the current width and height of the browser window, useful for building responsive layouts and components.

Delete Duplicate Records While Retaining One Instance

Efficiently remove duplicate rows from a SQL table, preserving a single unique entry based on a chosen primary key or unique identifier, for robust data cleanup.

Batch Insert Multiple Records into a Table

Perform a high-performance batch insert operation in SQL to add multiple new records into a table efficiently, reducing database round trips and overhead.

Update Records Using Data from Another Table

Efficiently update existing records in one SQL table by correlating them with data from another related table using an INNER JOIN, ensuring data consistency.

Calculate Running Total Without Window Functions

Compute a cumulative sum or running total for a set of records in a SQL table using a self-join, offering an alternative to modern window functions for compatibility.

Enforce Data Validation with a CHECK Constraint

Add a CHECK constraint to a SQL table column to automatically enforce specific data validation rules, ensuring data integrity and preventing invalid entries.

Implement Secure Password Hashing with Bcrypt

Learn how to securely hash user passwords using the bcrypt library in Node.js to protect against brute-force and rainbow table attacks, a critical security measure.

Implement CSRF Protection Middleware in Express.js

Secure your Express.js applications against Cross-Site Request Forgery (CSRF) attacks by implementing the `csurf` middleware for robust token validation on state-changing requests.

Sanitize User Input to Prevent XSS with DOMPurify

Prevent Cross-Site Scripting (XSS) attacks by safely sanitizing user-generated HTML content before rendering, utilizing the robust DOMPurify library for comprehensive protection.

Enforce Essential HTTP Security Headers in Express.js

Strengthen your web application's defense against common attacks by automatically setting critical HTTP security headers using Helmet middleware in Express.js.

Identify and Count Duplicate Records in a SQL Table

Learn to find and count duplicate entries in your SQL database table using a simple GROUP BY and HAVING clause, essential for data cleansing and integrity checks.

Perform Basic Full-Text Search Using LIKE Operator

Learn how to execute simple full-text searches in your SQL database using the `LIKE` operator with wildcards across multiple text columns.