OpenLampTech issue #115
Building robust LAMP stack apps | WooCommerce database optimization | PHP method chaining | CakePHP templating | wp_mail() is not broken.
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:
And now, a message from this week’s sponsor. Thank you, Backpack for sponsoring the OpenLampTech newsletter!
Backpack is one of the most popular admin panels for Laravel. Their simple stack and many many features make it a good choice for both devs who are now getting started and devs who plan to maintain a project for years to come - they've been doing this since 2016 and their track record speaks for itself.
If you're building a Laravel app, try Backpack, their free version is enough for most projects. Even better - if your project becomes complex, they have paid 1st party add-ons for the most common needs. Same vendor, all features you need.
OpenLampTech has sponsorship opportunities for your brand, product, or service in the weekly newsletter. As an independent publication, collaboration is very affordable.
Efficiently Delete Old Rows with Partitions
The longer an application is in service, the larger its data is likely to grow. Logs, audits, or other historical information data will surely surpass the main application data. Regardless, large amounts of data have to be dealt with at some point. This article contains example syntax and explanations in MySQL and PostgreSQL for deleting old data with partitions.
[SQL For Devs]
Building a Robust LAMP Stack on Ubuntu/Debian
Unless you have been living under a rock in the web development world for the last 25+ years, you would have heard of the LAMP stack. One of the core/key components of the LAMP stack is the Linux operating system it runs on. This article has command line examples of how to install the LAMP stack core components: Linux, Apache, MySQL, and PHP.
[Linux Journal]
An introduction to WooCommerce database optimisation
While WooCommerce uses the base WordPress database tables and structure, it adds its own specific tables too. This means WooCommerce database optimization can extend beyond that which is required to optimize a regular non-commerce WordPress site. WooCommerce has made significant strides in database optimization itself with the introduction of High-Performance Order Storage (HPOS).
[20i.com]
Unleashing the Power of Method Chaining in PHP
One of the more powerful aspects of working with ORMs or ORM-like features (I'm thinking of the Query Builder class in CodeIgniter 4 - I'm not sure if it is an ORM or not) is the ability to method chain on an object. By designing methods to return $this
, you can often write method chains like: select()->orderBy()->limit(4)
or something similar.
[dev.to]
Security Tip: Don’t Trust User Input!
Words To Live By.
If you're serious about the security of your Laravel application, you should be reading the Securing Laravel newsletter by Stephen Rees-Carter.
Laravel has many options for validating user input. A code snippet using the Request object in controller actions is provided for more detail.
[Securing Laravel]
I have zero experience with the Bricks builder in WordPress. For no ill intent. I've just not explored it any. However, Bricks has a growing userbase and the fanbase can often be seen championing their favorite page builder. This is the mega-curated resource for Bricks using a neat little platform/service I want to explore myself.
[bricks-links]
Templating and Icons in CakePHP
I'll admit I'm not on the up and up on CakePHP. I've never used it nor looked into it as a framework. I see some content about it here, there, and yonder but is it used that much? Anyway, I want to share as much variety as I can of PHP/MySQL/LAMP stack content so here is a piece about icons and templating in CakePHP.
Programmatically, I'm a novice in email programming. Just a regular “type and send it guy”.
Here is a quote directly from the article I find insightful and informative:
“Internally wp_mail() is just a wrapper around an open source PHP library called phpMailer. By default, this library uses PHP’s internal function called mail().”
There is plenty of good information in this piece about the back-end internals of email to learn about.
[KONSTANTIN KOVSHENIN]
WooCommerce
Email sender requirements: What you need to know for February 1, 2024
Thank you for reading. I hope you have a great rest of your week.
Take care.
Josh Otwell
When you are ready, here are more ways I can help...
Content, E-commerce Development, and Email/Newsletter Services - Photography services; Shopify and WooCommerce customizations, development, and setup; Email and Newsletter setup and management.
Interested? Great!
Just hit Reply and ask for more information about any of these services.
OpenLampTech is a reader-supported publication. You can support the publication with a virtual coffee for as little as $3 (USD).
[#Classifieds, #Affiliates, #Click Ads, #Shoutouts]
🤝 OpenLampTech earns a small commission (or payment/gain in some form) from many of these links. Your support helps keep the weekly 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.
The online DNS course for developers. Learn more at Nslookup.
AI-powered SQL generator and data analytics tool. Learn more at SQLAI.ai - AI, SQL & DATA.