The Ultimate
Snippet Library.

Read and Process File Line by Line

A bash script to efficiently read and process text files line by line, useful for parsing logs, configuration files, or lists of data for web development tasks.

Check if a Port is in Use

A practical bash script to determine if a specific TCP port is currently being listened on, essential for debugging network issues or starting services.

Basic Log Archiving with Date Stamping

A bash script to automate the archiving of log files by date-stamping them and optionally compressing, helping manage server disk space and log history.

Aggregate Multiple Metrics with Conditional Counts

Learn how to use conditional aggregation with CASE WHEN inside aggregate functions to create a single report showing counts of different statuses or types in one SQL query.

Perform an Upsert (Insert or Update) on a Single Record

Master the SQL UPSERT operation using PostgreSQL's INSERT ... ON CONFLICT DO UPDATE to either insert a new record or update an existing one atomically.

Identify and Delete Duplicate Rows While Keeping One

Learn to find duplicate records in a table based on specific columns and then delete all but one occurrence, maintaining data integrity.

Calculate Running Totals or Cumulative Sums with Window Functions

Discover how to compute running totals or cumulative sums in SQL using window functions like SUM() OVER (ORDER BY ...) for financial and analytical reports.

Batch Download Files from a List of URLs

Automate downloading multiple files from a list of URLs using `wget` in a bash script, ideal for bulk content retrieval and asset management.

Get All Unique Values from an Array

Discover how to efficiently remove duplicate values from a PHP array, ensuring each element is unique, and retaining the first encountered key association.

Reverse the Order of Elements in an Array

Learn to easily reverse the order of elements in any PHP array, whether indexed or associative, using the array_reverse function while optionally preserving keys.

Check if an Array is Associative or Sequential

Determine whether a given PHP array is associative (string keys, or non-sequential numeric keys) or a simple numerically indexed (sequential) array.

Get a Random Element from an Array

Learn how to fetch a single random element or multiple unique random elements from any PHP array using array_rand and array access.