Articles

When to Use UNION Queries

Learn when to use UNION queries in SQL to combine results from multiple SELECT statements. Discover practical examples, tips, and key considerations to optimize your database operations.

6 min read

Tutorials PHP Tooling

Laravel preventLazyLoading - Prevent Unintended Queries

Learn how to use Laravel's preventLazyLoading feature to catch and prevent unintended database queries, optimize performance, and avoid the N+1 query problem in your applications

4 min read

PHP JavaScript Sysadmin

What is DX?

Learn about Developer Experience (DX), why it matters, and see examples of good and bad DX that highlight its impact on software development productivity.

8 min read

Tutorials Database Design Tooling

MySQL `GROUP BY` Explained

Learn everything about the GROUP BY clause in MySQL, from basic to advanced usage, with examples, pitfalls, and best practices for effective data aggregation.

7 min read

Tutorials WordPress Tooling

How to rebuild permalinks in WordPress

Learn how to rebuild permalinks in WordPress using multiple methods, including through the control panel and via code, to fix broken links and improve site structure.

5 min read

Tutorials PHP Database Design

Naming Conventions for Laravel Database Tables

Learn about Laravel's naming conventions for joining tables. This guide covers how to name pivot tables and columns, ensuring automatic relationship mapping in Laravel.

5 min read

Tutorials Tooling

The Ultimate Guide to User Agents

Explore the intricacies of the user agent in this comprehensive guide. Learn about its structure, applications, and future trends to optimize web experiences for all users.

10 min read

Tutorials Tooling

Markdown cheatsheet

Master Markdown with this comprehensive cheatsheet! Learn basic to advanced syntax, including links, images, tables, and more. Perfect for beginners and experts alike.

7 min read

Tutorials Tooling

`-webkit-box` Explained

Learn about `-webkit-box`, an early CSS layout model, its properties, and how it compares to the modern Flexbox. Ideal for maintaining legacy code.

5 min read

Tutorials Database Design

Count(*) or Count(1) - Which Should You Use?

Learn the differences between COUNT(*) and COUNT(1) in SQL. Understand when to use each method for optimal performance and clarity in your database queries.

5 min read

Tutorials PHP Tooling

How to use the Vibration API in JS

Learn how to use the Vibration API in JavaScript to enhance mobile user experience with vibration feedback. This guide covers implementation, best practices, and examples.

5 min read

Tutorials PHP Tooling

How Does Laravel's Pluralizer Work?

Understanding the workings of Laravel's pluralizer. Learn how it handles different words, including those with the same singular and plural forms, with detailed examples.

4 min read

Tutorials PHP

When to use `if`, `switch`, and `match` in PHP

Discover when to use `if`, `switch`, and `match` in PHP for optimal code efficiency and readability. Learn their syntax, use cases, and practical examples.

4 min read

Tutorials WordPress PHP Tooling

Don't ignore multilingual support in WP

Learn why multilingual support in WordPress is crucial and discover best practices for implementation. A developer's guide to enhancing global reach and user experience.

4 min read

Tutorials WordPress PHP JavaScript

A guide to WordPress Coding Standards

Explore WordPress coding standards and expected syntax with extensive examples. Learn how to write clean, consistent, and maintainable code in PHP, HTML, CSS, JavaScript, and SQL.

10 min read