OpenLampTech issue #102
PHP dev tools | OLT developer interview | WooCommerce product data management | Drop SQL columns | Laravel stack trace. OpenLampTech is a media and content source for MySQL, PHP, and the LAMP stack.
Thank you for reading the OpenLampTech developer 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.
Our fine-grained distributed caching backed by Ceph provides perfectly incremental builds that are accessible from CI and local machines. Working with AWS Graviton or M1/M2 Apple Silicon? Our native CPU support for both Intel and Arm means no more time wasted on emulation.
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.
Atakan Demircioğlu shared a great set of responses and information in this recent OpenLampTech text-based developer interview.
Read it here:
[#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.
All commentary is by me unless otherwise quoted.
How to optimize product data management in WooCommerce
This article has many good pointers on product management for WooCommerce. As much as WooCommerce offers out of the box, there are additional steps and practices a shop owner can use to better manage products. I have a goal to someday run my own WooCommerce online store and will keep many of these sources in mind. [onrec]
CodeWP v2.0 Launch Ushers in New Era of AI-Powered WordPress Development (October 19th, 2023)
I'm still skeptical of AI. I like it and use it (some) where I can. But still, when it comes to content writing, AI-generated content is not that difficult to spot. All that said, it seems CodeWP has figured out a way to make it work within WordPress and codgen for the ecosystem. I've not used CodeWP personally (yet). [Newswires]
How to build a custom PHP MVC Framework
Many developers probably don't think about this too often. I mean we are all busy and who has the time to build their own framework? We can just grab Laravel, Symfony, or CodeIgniter, right? I think this is a project I should undertake. My absolute favorite beginner PHP book, PHP & MySQL: Novice to Ninja, has dedicated chapters for this exact thing but I never followed through on it. I should revisit that someday (soon). [Medium]
So you can develop WordPress websites offline and without leaving your PC with LocalWP
LocalWP is an absolute game-changer for WordPress developers/professionals. I use it all the time. In fact, I've learned the WooCommerce that I do know by using LocalWP since I don't have access to or own a live WooCommerce store. I've tried DevKinsta in the past but for me, LocalWP is the best option. Plus, as I'm just now discovering, LocalWP has a Live Link you can enable with a temp URL, password, and user credentials to view the site. [gearrice.com]
Awesome development tools for PHP 2023
With as large of an ecosystem as PHP, it's no wonder there are developer-related tools galore. From IDEs with dedicated plugins to SQL (and other) database clients, there is likely a tool to fit your needs. Probably some out there already to solve problems you don't yet know you have. This list has a good rundown of some of the popular tools and software in 2023 catering to PHP developers. [dev.to]
Deleting a Column in SQL: Everything You Need to Know
In many instances, if you're working within an SQL TRANSACTION
, Data Manipulation Language (DML) operations like INSERT
, UPDATE
, and DELETE
can be undone or rolled back. Not so much when dropping a column. So be careful when performing ALTER TABLE
commands like DROP
. Nine times out of ten, Data Definition Language (DDL) commands of this flavor are unrecoverable. In other words, when the column is dropped, it is gone. Learn more in this article about dropping a column in SQL. [dev.to]
Security Tip: Hide Sensitive Parameters from Stack Traces
Laravel security expert Stephen Rees-Carter shares some tips in this piece we definitely should pay attention to. Although I don't (yet) program in Laravel, I think it's worth considering checking any PHP application code where sensitive data could be exposed through stack traces. Learn more about Stephen Rees-Carter in this OpenLampTech developer interview. [Securing Laravel]
[#Affiliate]
Take your Laravel applications to the next level. Learn how to improve the performance, maintainability, and security of your Laravel projects in this e-book by Ash Allen.
WooCommerce News and Release Information
Action Scheduler to Adopt “L-2” Dependency Version Policy (October 24th, 2023)
Woo and Canal Help Merchants Access Unlimited Third-Party Product Sales (October 24th, 2023)
WooCommerce Blocks 11.4.1 Release Notes (October 25th, 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.
Get your very own classified ad here at an affordable price. Email me at openlamptech@substack.com for more information.
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 and Development Services - Blog writing and editing; Shopify and WooCommerce customizations; Email newsletters, marketing, and copywriting.
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).