The Ultimate
Snippet Library.

Load Environment Variables from .env File in Bash

Learn how to load environment variables from a .env file into your Bash script for dynamic configuration, commonly used in web development projects.

Validate Presence of Essential CLI Tools in Bash

Ensure your Bash scripts have all necessary command-line tools installed (e.g., node, npm, git) before execution, providing robust error handling.

Create Timestamped Directory Backup with Tar

Safely backup your web project directories by creating a timestamped gzipped tar archive, ensuring you have a restore point before major changes.

Robust HTTP Server Health Check with Retries

Implement a Bash script to health-check a web server's HTTP status with retry attempts, crucial for deployment verification and CI/CD pipelines.

Automate NVM Setup and Node Version Switching

Streamline your Node.js development workflow by automating NVM (Node Version Manager) initialization and switching between Node versions in Bash scripts.

Automate Web Server Restart with Status Check

Learn to write a robust bash script for restarting Nginx or Apache, including pre-check for configuration syntax and post-check for service status.

Deploy Project Files Incrementally with rsync

Efficiently deploy web project files to a remote server using rsync, ensuring only changed files are transferred and excluding sensitive directories.

Automate Log File Archiving and Cleanup

Create a bash script to automatically archive and clean up old log files, helping manage disk space and keeping server logs organized.

Efficient Data Pagination for API Results

Implement efficient pagination in SQL queries using OFFSET and LIMIT clauses to retrieve specific subsets of data, ideal for API results and large datasets.

Identify and Delete Duplicate Records in a Table

Learn to effectively identify and remove duplicate rows from your SQL tables, ensuring data integrity and improving database performance by eliminating redundant entries.

Retrieve All Parent Records with Optional Child Data

Use a LEFT JOIN in SQL to fetch all records from a primary table and their matching related data from another table, returning NULLs for unmatched children.

Summarize Data by Group with Basic Aggregations

Generate summary reports using SQL's GROUP BY clause with aggregate functions like SUM, AVG, and COUNT to gain insights into grouped data.