OpenLampTech No. 171
MySQL performance metrics | Strangler Fig | Laravel IDEA database and field updates | WooCommerce shipping zone data | Sessionless Transactions in Oracle database
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, thoughts, and opinions are mine unless otherwise quoted.
When I read a lot of this content, I felt It was tailored for me. Especially dealing with legacy code and projects (that I created) which are in bad need of modernization. Porting them over isn't always easy because business processes still need to run.
I once thought about this as trying to change a flat tire while still moving. Impossible in the literal sense, but hopefully you get where I'm going.
Also, one new(er) concept I took away is being okay with writing (temporary) code that will go away once the modernization is complete.
Laravel IDEA 10 automatically completes database and field entries
Laravel developers using PhpStorm as their IDE will likely appreciate additional autocompletion support for database-related code.
Quote from the source article:
“Intelligent database table and field completion allows developers to work more effectively with Laravel's query builder by automatically suggesting tables and fields to be used in migration and validation rules.”
[heise online]
Sessionsless Transactions in 23ai
Although not technically open-source, the Oracle Database is a robust option and I do use it from time to time in my current role. Mostly for spatial functionality.
Something interesting about this article that caught my attention is the topic of Sessionless Transactions.
Quote from the source article:
“By using Sessionless Transactions, you can suspend and resume a transaction at any point after starting it.”
Get Shipping Zone Data for Coding in WooCommerce
WP Sites is another fantastic WooCommerce source for developers.
If you need shipping information for code snippets, a child theme’s functions.php file, or a custom plugin, refer to this article.
[WP Sites]
Roman Agabekov of Releem shares the RED method and the 8 key metrics that are essential for optimal MySQL performance
Quote from the source article:
“The RED method, paired with Releem’s powerful monitoring capabilities and easy-to-apply configuration recommendations, does the heavy lifting for you.”
[Releem/Roman Agabekov]
Combine Multiple CSV Files Into One CSV Using Shell Scripting
I’m pretty sure I have shared this before in the OpenLampTech newsletter. But, since it is so useful, I am sharing again.
I recently answered this same type of question for an acquaintance targeting a different OS environment.
Believe it or not, this little hack is easier in Windows (lol).
[Medium]
WooCommerce News and Updates
WooCommerce 9.7 is Delayed (February 24th, 2025)
WooCommerce 9.7: Smarter shipping displays and faster performance (February 25th, 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.