The Ultimate
Snippet Library.

Combine Multiple Query Results with UNION ALL

Merge the results of two or more SELECT statements into a single result set using the UNION ALL operator, preserving all duplicate rows.

Insert Multiple Rows in a Single SQL Statement

Efficiently add multiple new records to a database table using a single INSERT statement with multiple VALUES clauses for better performance.

Find Records Unique to One Table Using EXCEPT

Identify and retrieve rows that exist in one table but not in another, effectively finding differences using the SQL EXCEPT set operator.

Calculate Aggregate Statistics with Grouping and Filtering

Learn how to group rows with GROUP BY and filter those groups using HAVING to calculate powerful aggregate statistics like sums, averages, and counts.

Retrieve Data from Multiple Tables Using INNER JOIN

Master fetching related data from different tables by combining rows based on a common column with INNER JOIN, essential for relational databases.

Perform an Upsert Operation (Insert or Update on Conflict)

Efficiently insert new rows or update existing ones if a unique key conflict occurs, using database-specific syntax like ON CONFLICT or ON DUPLICATE KEY UPDATE.

Paginate Query Results Using LIMIT and OFFSET

Learn to efficiently retrieve subsets of data for pagination by specifying the number of rows to return and the starting offset, crucial for large datasets.

Find the Nth Largest Value Using ROW_NUMBER Window Function

Discover how to rank rows within partitions and find specific ranked items (like the Nth largest salary) using the powerful `ROW_NUMBER()` window function.

Securely Deploy Static Website via Rsync with Configuration

Automate the deployment of a static website to a remote server using rsync, including secure SSH key authentication and configurable paths for web developers.

Check and Wait for a TCP Port to Become Available

Create a robust Bash script to repeatedly check if a specific TCP port on a host is open, useful for ensuring service dependencies are ready in CI/CD pipelines.

Parse Command-Line Arguments with Getopts for Flexible Bash Scripts

Learn to parse short command-line options and their arguments in Bash using `getopts`, enabling more powerful and user-friendly script interactions for developers.

Graceful Service Restart with PID File and Health Check

Implement a robust Bash script to gracefully stop, start, and restart a service using a PID file, including a basic HTTP health check for reliability in deployments.