OpenLampTech No. 175
Boring WordPress features | Hierarchical SQL data | WAMP stack with multiple PHP versions | SQL execution order | MariaDB mojo
Thank you for reading the OpenLampTech newsletter!
If someone awesome shared this newsletter with you and you are not yet subscribed, please use the Subscribe button below and join:
OpenLampTech has sponsorship opportunities for your brand, product, service, or job listing in the weekly newsletter.
As an independent publication, collaboration is very affordable.
All commentary is mine unless otherwise quoted.
Hierarchical Data in SQL: The Ultimate Guide
Hierarchical data often requires specific design considerations. This article's examples use classic employee/manager data, showing how many tables could result in the database without hierarchical design.
SQL expert Ben Brumm has some fantastic SQL content, and I highly recommend his work.
[Database Star/Ben Brumm]
Be careful when using assertViewHas with null
Joel Clermont of Mastering Laravel has some fantastic content on all things Laravel in addition to testing best practices.
Joel covers that assertViewHas() Laravel method doesn't work as expected with null values and how to test them.
[Mastering Laravel/Joel Clermont]
How to properly set up WAMP stack with multiple PHP versions in parallel
I've used LAMP or XAMPP stacks for development environments despite having a Windows work environment.
For personal projects on my MacBook, I use MAMP.
I've only worked with the LAMP stack on actual websites and applications.
This article provides some pointers for setting up a Windows-based (WAMP) development stack that supports multiple PHP versions.
[dev.to]
How Does SQL Execution Order Work, and Why is it so Important? (Recap)
This is one of the more important SQL concepts to learn and understand. I personally didn't realize how the execution order worked until I started trying to use SELECT clause column aliases in the WHERE clause, which doesn't work (you need to use a Derived Table or Inline View).
[Level Up Coding]
MariaDB CEO on database company regaining its mojo
MariaDB has had quite a rocky journey these last couple of years.
Having been the default in many Linux installations, to plans on closing its Azure Database for MariaDB later in 2025, the wins and challenges are both far and wide.
However, it appears MariaDB is not yet ready to write its final chapter.
[Blocks & Files]
Why ‘Boring’ Features Benefit WordPress Professionals
With contributions and development cutbacks, most updates to WordPress will likely be the necessary ones (security and bug fixes).
Any features are a bonus and a nice addition, but those fixes and patches behind the scenes that keep things working and stable are ultimately what keep the software moving forward.
[The WP Minute]
WooCommerce and WordPress news and updates
Updated WooCommerce 9.8 Release Schedule (March 24th, 2025)
Getting to know the Woo Marketplace: Tools we use and what we look for (March 26th, 2025)
Thank you for reading OpenLampTech. I hope you have a great rest of your week.
Take care.
Josh Otwell
Some links may be affiliate links from which I earn a small commission at no additional cost.