Articles

Making WordPress Immutable

Learn how to make your WordPress site immutable for enhanced security and stability. Discover the benefits and step-by-step guide to creating an unchangeable WordPress environment

7 min read

Tutorials JavaScript Tooling

Test Stripe webhooks without using ngrok

Learn how to test Stripe webhooks without using ngrok. Discover alternatives, such as Stripe CLI and local reverse proxies, for seamless webhook testing.

6 min read

Tutorials WordPress PHP

What is the n+1 problem? (WordPress edition)

Learn about the N+1 problem in WordPress and how it impacts site performance. Discover techniques to avoid it using batch processing, eager loading, and caching.

5 min read

Tutorials JavaScript

What is the n+1 problem? (JavaScript edition)

Learn about the N+1 problem in JavaScript and how it affects performance. Discover strategies to avoid it using batch requests, eager loading, and GraphQL's DataLoader.

5 min read

Tutorials PHP

What is the n+1 problem? (PHP edition)

Learn about the N+1 problem in PHP and how it can impact performance. Discover techniques to avoid it using eager loading and query optimization in frameworks like Laravel and Symfony.

5 min read

Tutorials Database Design Tooling

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