Picture an order-list page. It has one job: print the orders on screen. I built a sample service graph and counted the constructors — seven objects were created during that single request, two were used. Five went straight to the bin untouched. A PHP autowiring container is both the cure and the accomplice here. It […]
Last week I moved the PHP on my server from 8.1 to 8.5 and wrote it up as a maintenance job. This week’s radar entry demands that version as a precondition. TypePHP is an AOT (ahead-of-time) compiler that turns PHP source into C++ and then into native machine code. Your PHP stops being a script […]
My own blog’s Site Health screen said PHP 8.1.2. A patch level from early 2022, running in September 2026, on a server open to the internet. I had been putting the PHP 8.5 upgrade off for years with “I’ll get to it”; what I was putting off no longer had the name old, it had […]
Hello, tech enthusiasts! Today, we’re diving into one of SQL’s most fascinating features: WITH RECURSIVE. This powerful tool is perfect for unraveling complex data structures, like company hierarchies, road networks, or even simple number sequences. It’s like having a trusty guide to navigate through intricate data mazes. So, grab a cup of tea, and let’s explore how WITH RECURSIVE can make your SQL queries shine!
If you’re using Phalcon, you’ve probably fallen in love with its speed and flexibility. But let’s be real—sometimes it throws curveballs that make you question your life choices.
Choosing an identity in the world of databases is not as simple as it may seem. In fact, the choice of each identity (or ID) is part of a much larger strategy. “Life is short, data types are long,” someone once said (of course, they didn’t actually say it, but it would have been very cool if they had). This article leaves you face-to-face with the question “INTEGER or BINARY?” and aims to help you find the correct answer to it.
Let’s take a lesson from the world of A Song of Ice and Fire: “Chaos is a ladder.” But this rule does not apply to MySQL queries! On the contrary, if you let chaos into your queries, your performance can tumble down a cliff. Introducing the sinister N+1 Query Problem, the silent killer of database performance.
Hello MySQL enthusiasts! Today, we’re diving into a commonly used yet often underrated topic in the world of databases: the “INSERT INTO … ON DUPLICATE KEY UPDATE” statement. In this article, we’ll explore the advantages and disadvantages of this handy SQL command while also taking a look at what’s happening behind the scenes.