OpenLampTech No. 172
Database sharding | OOP concepts | WP class action lawsuit | Simplify complex SQL | Reusable SQL queries | MySQL 9.2 contributions | CodeIgniter or Laravel?
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.
The Key Concepts of Object-Oriented Programming
While learning OOP, I finally felt like a real programmer (whatever that means in my head, at least 😎). Most modern programming languages support OOP so it's something worth learning.
Quote from the source article:
“At its core, OOP is based on four fundamental principles: Abstraction, Encapsulation, Inheritance, and Polymorphism.”
[System Design Codex]
WordPress dispute escalates with class action lawsuit over blocked updates
At first, I decided I wouldn't cover any WordPress dramas in the OpenLampTech newsletter. But I did.
Then I stopped.
Now I'm back to sharing articles on it again.
Quote from the source article:
“Keller, who runs Keller Holdings – a company that creates websites for businesses and individuals – is seeking damages for affected businesses and a permanent injunction to prevent Automattic from using its control over WordPress.org to interfere with competitors.”
[Techspot]
LUC #75: Database Sharding Explained — Strategies for Scalable Database Management
Database sharding is far outside my wheelhouse at this time in my career. However, I know as the database grows, it is the bottleneck and some measures must be taken to account for and deal with that.
Quote from the source article:
“Database sharding divides a database into smaller, more manageable segments known as "shards," which are distributed across various servers.”
[Level Up Coding]
Best Practices for Simplifying Complex SQL
I can write complex spaghetti SQL code like a true champ 🏆 😁.
But, in my defense, I don’t have a 5,000+ liner under my belt yet (yikes).
Quote from the source article:
“With tools like ChatGPT and Cursor making it easier than ever to generate SQL, I have a feeling we’ll see even more of these sprawling queries in the wild.”
[SeattleDataGuy’s Newsletter]
MySQL 9.2 ! Thank you for your contributions!
This article covers a list of features and fixes made by contributions from contributors to MySQL 9.2 (of which I have not used).
Some of the fixes that caught my attention are:
Work on in-place
ALTER TABLEstatement for duplicate key errors and concurrent purgesFull text search comparisons
Command-line improvements for
mysqlslap ssl-mode
Crafting readable and reusable SQL queries
This can be a challenge without Common Table Expressions (CTEs). CTEs are one of the most powerful SQL features in my opinion.
Quote from the source article:
“Think of CTEs as temporary helpers that cleanly organize your query’s logic into structured, readable sections, making your SQL both reusable and easy to follow.”
CodeIgniter vs Laravel: Which Framework is Better?
Although the internet is riddled with these comparisons, I still like to read them occasionally.
On paper and feature-wise, Laravel is the clear winner here. And, this is coming from a CodeIgniter fan boy who's never used Laravel.
But in the end, it's all subjective and just depends on what you need.
I've found that for the work I do, CodeIgniter's lightweight footprint works best.
WooCommerce News and Updates
WooCommerce 9.8: Pre-release updates (March 4th, 2025)
WooCommerce 9.7.1: Dot Release (March 4th, 2025)
Upcoming changes to the WooCommerce release process (March 5th, 2025)
Developer Advisory: WooCommerce is upgrading all Monorepo React 17.0.2 Dependencies to React 18.3.X (March 5th, 2025)
Performance insights from refactoring our custom Block Registration in WooCommerce (March 5th, 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.