OpenLampTech issue #129
Releem MySQL performance tool | MySQL InnoDB and MYISAM storage engines | Deregister anonymous WordPress functions | WooCommerce products on sale with PHP
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, or service in the weekly newsletter. As an independent publication, collaboration is very affordable.
All commentary and opinions are mine unless otherwise quoted.
Improving Database Performance with ReadySet: A MySQL Caching Solution
When you are working with application data, speed and efficiency are likely some of the first and foremost thoughts. Yes, you need to retrieve the correct data and do something with it. But, the overall process should be performant.
This is where ReadySet can help by providing a caching solution for your MySQL database.
Follow along in this article and learn how to set up and configure ReadySet.
How to Successfully Deregister Anonymous Functions in WordPress
To my (limited) WordPress coding knowledge, most hooks (maybe mainly the action type?) accept a function you create to execute your code. This function can be either a named or anonymous function.
Here is an article in a series discussing how to track and deregister anonymous functions in WordPress.
An interesting bit of information I first learned about quoted directly from the source article:
“... all closures are anonymous functions but not all anonymous functions are closures.”
MYSQL — Choosing Between InnoDB and MyISAM Storage Engines
I often just default to InnoDB in the projects I work on and sometimes forget that MySQL has other storage engines. I (personally) think InnoDB is the better choice but your needs may differ. Where InnoDB is ACID-compliant, MyISAM does not have transaction support.
Although InnoDB is the default MySQL storage engine, you could consider MyISAM for things like efficient full-text indexing and table-level locking (InnoDB has row-level locking).
[Medium]
Laravel: Refining a database query from URL parameters
Scratching your own itch as a developer is one way to come up with app or package ideas. And that is exactly what the author did when creating the Laragear Refine package.
This package helps parse out URL parameters and adds to/edits/adjusts the underlying database query.
Based on my understanding, one of the key things I picked up from the article is moving a lot of the request validation from the Controller
to the Refiner
class, therefore limiting which keys are executed by the class.
[Medium]
WooCommerce 8.9: Pre-release updates (April 29th, 2024)
WooCommerce 8.9 is scheduled for release on May 14th, 2024.
Here are some highlights for this release that caught my eye:
The experimental Checkout Fields feature for Cart and Checkout Blocks will be stable.
A fix to REST API v3 reports/orders/totals endpoint for HPOS compatibility
Better validation for missing fields in the Store API
Can add custom product fields to products using the new Product Editor. (I'm still on the fence about this new block-based Product Editor. However, you can extend it with PHP)
[Woo Developer Blog]
WooCommerce: Get Products On Sale Via PHP
One of the things I am trying to learn more about and enjoy is seeing what underlying MySQL query makes a particular WordPress or WooCommerce function work.
In this article, WooCommerce expert Rodolfo Melogli dives deep into the code behind the WooCommerce wc_get_product_ids_on_sale()
function.
The Business Bloomer website is the best online source for WooCommerce coding and customizations that I am personally aware of.
I frequent it quite regularly myself.
[Business Bloomer]
Releem: MySQL Performance Tool
Releem CEO and (co)founder Roman Agabekov is a MySQL performance tuning expert. In this article, Another Boring Tech Blog analyzes the Releem product. Releem is a MySQL database performance tool used to keep your MySQL database running at an optimal level depending on your application needs and database settings.
This article goes into just what that entails and some of the things Releem does to make your MySQL database efficient and economical.
[#Affiliates and Classifieds] - Your support keeps the OpenLampTech newsletter free for readers
Take your Laravel applications to the next level with Battle Ready Laravel by Ash Allen. Learn how to improve the performance, maintainability, and security of your Laravel projects in this e-book. (affiliate)
Ultimate Laravel Boilerplate to help other indie hackers deliver their SaaS in hours. Get started with LaraFast today! (affiliate)
Popups, newsletters, and abandoned carts. Use Omnisend with integrated email and SMS campaigns. (affiliate)
Thank you for reading. I hope you have a great rest of your week.
Take care.
Josh Otwell
OpenLampTech is a reader-supported publication. You can support the publication with a virtual coffee for as little as $3 (USD).
Some links may be affiliate links from which I earn a small commission at no additional cost to you.