The Ultimate
Snippet Library.

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.

Prevent Default Form Submission

Understand how to intercept and prevent the default browser behavior of a form submission, allowing for custom AJAX submissions or client-side validation.

Insert Element Before Sibling

Learn to dynamically insert a new HTML element right before an existing sibling element within the DOM, useful for flexible content arrangement on the fly.