The Ultimate
Snippet Library.

Check Git Status and Pull Latest Changes

Automate checking the Git status of a repository for uncommitted changes or untracked files, and pull the latest changes from a specified branch, ensuring your repo is up-to-date.

Make HTTP Request and Extract JSON Field with jq

Effortlessly make HTTP GET requests to API endpoints using `curl` and parse JSON responses with `jq` to extract specific data fields, useful for scripting API interactions.

Delete Old Files or Directories by Age

Automate the efficient cleanup of old files or empty directories within a specified path based on their age using `find`, perfect for managing logs, caches, and temporary data.

Interactive Script with User Menu and Actions

Create an interactive Bash script with a dynamic menu, allowing users to select and execute various administrative or development tasks through a `case` statement, streamlining workflows.

Efficient Data Ranking and Pagination with SQL Window Functions

Master SQL window functions like ROW_NUMBER() and RANK() to efficiently rank rows within partitions or implement advanced pagination logic for web applications.

Transform Rows to Columns with SQL Conditional Aggregation (Pivoting)

Discover how to pivot data and create dynamic reports using SQL conditional aggregation with CASE expressions inside aggregate functions like SUM or COUNT.

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.