OpenLampTech issue #105
SQL Upsert | WordPress nonces | WordPress CLI | Microservices with PHP | Laravel vs Symfony. OpenLampTech is a media and content source for PHP, MySQL, and the LAMP stack.
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, Depot for sponsoring the OpenLampTech newsletter!
Depot is a remote container build service hosting BuildKit as a service, the same build engine that backs Docker. We can build Docker images up to 20x faster, thanks to fast persistent caching on NVMe SSDs, 16 CPUs, 32GB of memory, and fast native CPUs for Intel and Arm.
If you’re tired of waiting for slow Docker image builds, check out depot.dev.
OpenLampTech has sponsorship opportunities for your brand, product, or service in the weekly newsletter. As an independent publication, collaboration is very affordable. Inquire by email at openlamptech@substack.com for more information on how you can reach the OpenLampTech readership. Sponsorships are available for early 2024.
Choosing a PHP Framework for Microservice Architecture
If you're exploring the idea of using a PHP framework for any microservices, this article covers (the most) popular options out there. Not surprisingly, Laravel ranks at the top with Symfony right there in the mix as well. I've got to get my butt in gear and learn more about both of those frameworks. And microservices as well. [HackerNoon]
WooCommerce 2024: Innovation or Alienation
I'm guessing you would have to be living under a rock to not have heard about WooCommerce rebranding as Woo. (I honestly think sometimes I'd rather live under a rock - but that's another story.) Based on my understanding, WooCommerce is (still) the open-source software that enables a regular WordPress site to have online e-commerce functionality. On the other hand, Woo is the brand (by Automattic) that develops and maintains WooCommerce. Automattic also has - and boasts - Woo Express, a done-for-you hosted e-commerce solution. [WP Mayor]
Upserts are a handy feature most SQL implementations support where new records are added to a database table (which would be the INSERT
operation) while existing records are updated. This article covers many SQL flavors but the important one (for me) is how MySQL handles upserts. MySQL v8 includes alias possibilities for the upserts. [Anton Zhiyanov]
[#Affiliate]
The DNS course for developers
Who is this course for?
This course is for you if you want to gain mastery over DNS.
It assumes you have a basic understanding of how the internet works, but you don't need to be an expert. This course assumes no prior networking experience and involves no programming.
If you've worked on DNS full-time for over a year, this course is probably not for you. Otherwise, you'll learn a lot! If you invest in your knowledge today, you'll benefit for the rest of your career.
Laravel Vs Symfony: Choosing the Right PHP Path
I think this could go either way honestly. Two huge, powerful PHP frameworks. Both have dedicated users who support the cause. I've not used either so I don't necessarily have a dog in the hunt. This article provides a good context review of both frameworks and even mentions how Laravel is ‘built with’ (those may be bad word choices on my part) a number of Symfony components. [Medium]
WordPress Nonce 101: What are they and why do they matter?
WordPress has many functions in place to work with nonces. Nonce stands for “number used once” and is integral (or should be) in the request life cycle. Nonces are used to verify that certain requests are made by users who have the correct permissions. Nonces help mitigate the risks of nefarious activities in the form data to name but one of its uses. [Tanner Record]
The Case of a Curious SQL Query
SQL is more than just selecting data from some table. Or, stuffing your query into an ORM and taking what you get. With SQL, you get back exactly what you ask for. Which can be totally wrong, data-wise. There is a big difference. In other words, you should know what you're asking for because it's up to the SQL engine to figure out how to get that data and return it to you. [Null Bitmap]
Bulk delete posts in WordPress with WP CLI (+variants)
Efficiency is key for large sets of tasks and operations and WP CLI seems to be very efficient. I've been aware of WP CLI for a long while now, I've just never used it. This article provides steps and commands on how to bulk delete pretty much any post type. Be careful though because once they are gone, those posts can't be recovered. [REMKUS DE VRIES]
WooCommerce News and Release Information
FAQ: Cart and Checkout Blocks by Default (November 6th, 2023)
WooCommerce Blocks 11.5.0 Release Notes (November 7th, 2023)
WooCommerce Blocks 11.5.1 Release Notes (November 8th, 2023)
WooCommerce Blocks 11.5.4 Release Notes (November 13th, 2023)
FAQ: Joining the WooCommerce Marketplace (November 8th, 2023)
WooCommerce 8.3.0 Released (November 16th, 2023)
[#Classifieds, Affiliates, and Click Ads]
🤝 OpenLampTech earns a small commission (or payment in some form) from many of these links. Your support helps keep the weekly OpenLampTech newsletter free for readers.
Take your Laravel applications 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.
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).