The Ultimate
Snippet Library.

Performing Upsert (Insert or Update) Operations in SQL

Learn how to perform an "upsert" operation in SQL, which inserts a row if it doesn't exist or updates it if a matching record is found, crucial for data synchronization.

Calculating Running Totals and Cumulative Sums in SQL

Generate running totals or cumulative sums over ordered data in your SQL database using window functions, perfect for trend analysis and financial reporting.

Email Address Validation

Validate email addresses with a robust regular expression in JavaScript to ensure correct format for forms and user input, improving data quality.

URL Validation and Protocol Extraction

Validate full URLs, including protocol and optional path, and extract the protocol using JavaScript regex for link verification and parsing.

Password Strength Validation

Implement a JavaScript regex pattern to validate password strength, ensuring it meets minimum requirements like length, uppercase, lowercase, numbers, and special characters.

Extracting Hex Color Codes

Discover how to efficiently extract all valid hex color codes (3-digit or 6-digit) from any string using JavaScript regular expressions for styling or parsing.

Sanitizing Script Tags from User Input

Prevent basic Cross-Site Scripting (XSS) by removing script tags and their content from user input using a JavaScript regular expression for initial sanitization.

Extracting and Analyzing Web Server Logs

Learn to process web server access logs using `grep` and `awk` to extract common errors, unique IP addresses, and request statistics for debugging.

Check and Restart a Linux Service by Name

Automate checking if a critical Linux service (e.g., Nginx, a Node.js process) is running and restart it if it's found to be inactive, ensuring application uptime.

Define Global Environment Variables and Aliases

Create a Bash script to set up common environment variables and useful command aliases for all new shell sessions, enhancing developer productivity and consistency.

Vue 3 Programmatic Navigation with Vue Router 4

Implement programmatic navigation using `router.push`, `router.replace`, and `router.go` in Vue 3 applications with Vue Router 4 for dynamic route changes.

Vue 3 Custom Directive for Auto-Focus

Create a reusable custom Vue 3 directive to automatically focus an input element when a component is mounted or when the element becomes visible, improving UX.