The Ultimate
Snippet Library.

Count Items by Status Using Conditional Aggregation

Efficiently count records for different categories or statuses within a single SQL query using CASE statements inside aggregate functions for clearer reporting.

Perform Upsert (Insert or Update if Exists)

Learn how to execute an "upsert" operation in SQL using PostgreSQL's ON CONFLICT clause, which inserts a new record or updates it if it already exists.

Retrieve the Nth Highest Value from a Column

Efficiently fetch the Nth highest distinct value from a specific column in a database table using SQL's ORDER BY, LIMIT, and OFFSET clauses for ranking.

Select N Random Records from a Table

Discover how to retrieve a specified number of random records from your database table using SQL's RANDOM() function and LIMIT, ideal for dynamic content.

Group Records by Month and Year

Aggregate data by month and year from a datetime column in PostgreSQL, providing quick insights into monthly or yearly trends for reports and dashboards.

Detect Online/Offline Network Status with a Custom React Hook

Create a custom React hook to efficiently detect and provide the current online or offline status of the user's browser, enabling adaptive UI experiences.

Get the Previous Value of a Prop or State in React

Implement a custom `usePrevious` React hook to easily access the value a prop or state had on the previous render, useful for comparisons and conditional logic.

Detect Clicks Outside a Component with a React Hook

Create a `useClickOutside` React hook to easily handle events when a user clicks anywhere outside a specified DOM element, perfect for dropdowns and modals.

Track Real-time Window Dimensions with a Custom React Hook

Build a `useWindowSize` React hook to dynamically get the current width and height of the browser window, enabling responsive component rendering.

Safely Manage `setInterval` with a Custom React Hook

Implement a `useInterval` hook to safely execute a function repeatedly with a fixed time delay, ensuring proper cleanup and preventing common `setInterval` pitfalls in React.

Split an Array into Chunks (Pagination/Batching)

Discover how to divide a large PHP array into smaller, manageable chunks, ideal for pagination, batch processing, or displaying data.

Toggle CSS Class on Click

Learn how to dynamically add or remove a CSS class from an HTML element when a user clicks it, enhancing interactive UI elements effortlessly.