The Ultimate
Snippet Library.

Efficiently Insert or Update Records (UPSERT) in SQL

Learn to perform atomic 'upsert' operations in SQL using INSERT ... ON CONFLICT DO UPDATE (PostgreSQL) or REPLACE INTO (MySQL) to manage data.

Query Hierarchical Data with SQL Recursive Common Table Expressions

Navigate and query hierarchical or tree-like data structures efficiently using SQL Recursive Common Table Expressions (RCTE) for categories, comments, or org charts.

Effortless Centering with CSS Flexbox

Achieve perfect horizontal and vertical centering for any element using a minimal amount of CSS Flexbox properties on the parent container, ideal for layouts and components.

Sticky Footer Layout with CSS Flexbox

Implement a classic sticky footer layout ensuring the footer always stays at the bottom of the viewport, even when content is sparse, using Flexbox for robust placement.

Dynamic Content Reordering with Flexbox order and Grid grid-area

Effortlessly change the visual order of elements in Flexbox using the `order` property, or in Grid using `grid-area` with named layouts, without altering the HTML structure.

Get Real-time Window Dimensions

A React hook to dynamically track and provide the current browser window's width and height, useful for creating responsive layouts and adapting UI components.

React to CSS Media Queries

A custom React hook that allows components to react dynamically to CSS media queries, enabling responsive UI changes directly within your React logic.

Generic Event Listener Hook

A versatile React hook for safely attaching and detaching event listeners to DOM elements or the window, ensuring proper cleanup and preventing memory leaks.

Detect Browser Online/Offline Status

A React hook to efficiently track and provide the current browser's online or offline connectivity status, enabling network-aware user interfaces.

Sanitize HTML Output to Prevent XSS

Learn to prevent Cross-Site Scripting (XSS) attacks by properly escaping HTML special characters before displaying user-generated content in the browser.

Implement CSRF Protection with Tokens in PHP

Protect your web applications from Cross-Site Request Forgery (CSRF) attacks by generating and validating unique tokens for state-changing requests in PHP.

Implement Content Security Policy (CSP) via Nginx

Enhance your website's security against XSS and data injection by configuring a robust Content Security Policy (CSP) using Nginx server headers.