The Ultimate
Snippet Library.

Using Common Table Expressions (CTEs) for Multi-Step Queries

Simplify complex SQL queries and improve readability by breaking them into logical, named subqueries using Common Table Expressions. Ideal for multi-step data processing.

Performing Upsert Operations (INSERT OR UPDATE)

Efficiently insert new records or update existing ones in a database table without explicit checks. Essential for data synchronization and preventing duplicate entries.

Aggregating String Values with GROUP_CONCAT or STRING_AGG

Combine multiple string values from related rows into a single, comma-separated string within a grouped result. Ideal for listing tags, categories, or associated items.

Implementing Basic Full-Text Search in SQL

Add powerful search capabilities to your web application by querying text columns efficiently with database-native full-text search features.

Calculating Row Ranks and N-th Largest Values using Window Functions

Determine rankings (e.g., top N, N-th largest) or partition data using advanced SQL window functions like ROW_NUMBER(), RANK(), and DENSE_RANK().

Monitor Web Server Error Logs in Real-time

A bash script to continuously monitor Apache or Nginx error logs, displaying new error entries as they occur. Essential for quick identification and debugging of issues on a live web server.

Set Up New Web Project Directory with Correct Permissions

Automate the creation of a new web project directory, ensuring proper ownership and read/write permissions for web server access and secure development workflows.

Check Server Disk Space and Alert if Low

A bash script to monitor available disk space on a server. It checks all mounted filesystems and alerts if usage exceeds a configurable threshold, preventing outages from full disks.

Extract Unique Domain Names from a List of URLs

A powerful bash one-liner to parse a file containing URLs and extract only the unique domain names. Ideal for analyzing web server access logs, link lists, or creating whitelists/blacklists.

Gracefully Restart a Web Service and Check Status

A robust bash script to gracefully restart common web services (e.g., Nginx, Apache, PHP-FPM) and verify their running status, minimizing downtime during deployments or configuration changes.

Filtering Null, Empty, and False Values from a PHP Array

Learn how to quickly clean up a PHP array by removing all null, empty strings, and false boolean values using a simple built-in function.

Grouping PHP Associative Arrays by a Specific Key

Learn how to efficiently group a list of associative arrays or objects by the value of a common key, creating a structured, categorized dataset.