The Ultimate
Snippet Library.

Find and Delete Old Files by Age and Type

A bash script to locate and safely remove old files (e.g., logs, backups, temporary files) older than a specified number of days in a given directory.

Parse JSON API Response and Extract Data with JQ

A bash snippet demonstrating how to use `curl` to fetch a JSON API response and `jq` to parse, filter, and extract specific data fields from it.

Add, Remove, and Get Element Attributes

Master manipulating HTML element attributes using JavaScript, including setting custom data attributes, removing existing attributes, and retrieving their values dynamically.

Handle Form Submission and Input Events

Discover how to capture user input from form fields and respond to form submission events using JavaScript, preventing default browser behavior for custom validation.

Secure HTML Output Escaping

Learn to prevent Cross-Site Scripting (XSS) attacks by properly escaping user-generated content before rendering it in HTML, ensuring robust web application security.

Implement CSRF Protection with Tokens

Protect your web forms from Cross-Site Request Forgery (CSRF) attacks by generating and validating unique tokens with each form submission.

Securely Hash Passwords with Bcrypt

Discover how to securely store user passwords using the Bcrypt hashing algorithm, preventing plaintext storage and enhancing application security against breaches.

Enhance Security with HTTP Headers

Boost your web application's security posture by setting essential HTTP security headers like HSTS, CSP, and X-Frame-Options to mitigate common web vulnerabilities.

Calculate Running Totals or Moving Averages in SQL

Compute cumulative sums (running totals) or moving averages over time using SQL window functions for financial or analytical reports.

Apply Conditional Logic with SQL CASE Statements

Implement conditional logic with SQL CASE statements to categorize data or customize sorting rules directly within your SELECT or ORDER BY clauses.

Efficiently Check for Related Record Existence with EXISTS

Discover how to use the SQL EXISTS operator for performance-optimized checks to see if related records exist, often outperforming JOINs for simple existence.

Identify and Remove Duplicate Records in SQL

Learn essential SQL techniques to find duplicate rows based on specific columns and safely delete redundant entries while preserving a unique record.