The Ultimate
Snippet Library.

Count Distinct Values Per Group with HAVING

Learn to count the number of unique occurrences of a field within different groups using GROUP BY and COUNT(DISTINCT ...), filtering results with HAVING.

Delete Duplicate Rows Keeping First Occurrence

Efficiently remove duplicate entries from your database table based on specific columns in MySQL, ensuring only one unique record remains for each set of duplicates.

Automate Actions with Eloquent Model Observers

Centralize logic for responding to Eloquent model lifecycle events like creation, update, and deletion using dedicated observer classes.

Perform Batch Updates and Deletes Efficiently

Execute mass updates or deletes on multiple records without retrieving and iterating over each individual Eloquent model, optimizing database operations.

Configure Custom Database Connections and Table Names

Learn how to configure Eloquent models to use a different database connection or a custom table name than Laravel's default conventions.

Reusable Query Filters with Eloquent Local Scopes

Define reusable query constraints within your Eloquent models to simplify filtering and improve code readability for common data retrieval patterns.

Filter Records Based on Related Model Existence

Efficiently query parent models based on the existence or absence of specific related records using Eloquent's `has` and `whereHas` methods.

Load .env File into Bash Environment

Learn how to securely load environment variables from a .env file into your Bash session or scripts, enabling easy configuration management for web projects.

Perform Authenticated API Request with curl

Discover how to use `curl` in Bash to make authenticated POST requests to web APIs, including sending JSON payloads and authentication headers.

Update Configuration Value in File using sed

Learn how to use `sed` in Bash to programmatically update specific configuration values within text files, useful for automated server setups.

Set Secure Web Project File Permissions

Secure your web applications by correctly setting file and directory permissions in Bash, ensuring proper access for the web server while maintaining security.

Create Basic Web Project Directory Structure

Quickly bootstrap new web projects by generating a standard directory and file boilerplate structure using a simple Bash script.