OpenLampTech issue #29
This issue of OpenLampTech is full of all the MySQL, PHP, and LAMP stack content you didn't know you were missing. We've reached 100+ subscribers! Woot woot!
Hey glad to have you here! Thank you so much for reading the publication. We have passed the 100 subscriber mark! Thank you! 👍
If someone shared this newsletter with you and you are not yet subscribed, please use the Subscribe button below and join:
Receive a free copy of my eBook, “10 MySQL Tips For Everyone” when you subscribe to the weekly OpenLampTech newsletter!
Recently Published on the Digital Owl’s Prose Blog
This week on my Digital Owl’s Prose developer blog, I published a fantastic guest post by guest contributor, Regi Publico.
Read, Python vs PHP: Which is Better for Web Development?, for Regi’s take on these 2 popular programming languages, both of which have widespread use in web development.
Many articles I read and share in the OpenLampTech newsletter, I discovered on Medium. With a membership, you can read unlimited articles on the platform. Consider using my sign-up link to become a member, and at no extra cost to you, I will receive a portion of your membership fees which helps me continue publishing the OpenLampTech newsletter.
Linux | Apache | MySQL/MariaDB | PHP
I have curated some fantastic reads for you this week. Let’s get to them!
Nick Diego: Builder Basics – Working with Templates in Full Site Editing (Part 2)
By: Nick Diego
This video is Part 2 of a 3-part series covering WordPress Full Site Editing (FSE) using templates and template parts. I shared Part 1 in a recent OpenLampTech newsletter. If you missed that issue, here is the link for part 1.
So far, these videos are a great help to me in understanding the whole FSE landscape better. I bet you will enjoy them also if you're like me, and interested in learning this direction WordPress is taking.
Apache vs Nginx - Detailed Comparison
By: Marko Aleksic
I think it's safe to say that without either of these web servers, we wouldn't be able to create web applications or sites. Or, the caliber of them we are used to.
This head-to-head article covers:
History and overview
Migrating from MariaDB to MySQL using MySQL Shell
MySQL Shell is such a powerful tool. In this article, we learn the exact steps to follow on both the MariaDB and MySQL instances for a successful migration.
There are also detailed steps for loading/importing the logical dumps.
Another handy tip, use MySQL Shell Upgrade Checker if upgrading from an older MySQL version to v8.
WordPress Relationships Explained
By: Lana Miro
There are 3 fundamental relationships in SQL:
One to One
One to Many
Many to Many
This article provides a high-level overview of these same 3 relationships as applied to WordPress.
After all, the MySQL relational database is a core piece of software of the CMS.
One to One: post ID -> post content and post slug
One to Many: authors -> books
Many to Many: wp_posts -> wp_term_taxonomy
The Search For the Perfect Foot: A Tale of Database Normalization
By: Seth Rhine
Personally, database normalization is one of the toughest concepts for me to learn and use effectively.
The data I primarily process in my day job fits more into the Concrete Table Inheritance model.
Nevertheless, this article covers moving to a more normalized structure and I can definitely see those benefits especially when it comes to data duplication (the same data stored in several tables).
17 Methods to Optimize Laravel Performance
By: Mahitab Mostafa
The Kinsta blog publishes great, knowledge-based articles. Typically, I associate Kinsta with WordPress but that doesn't necessarily mean they don't cover Laravel well either.
In fact, the author did just that with this article.
A few interesting insights I picked up on (in my very limited Laravel experience):
Optimize Composer by removing dev dependencies.
Use the latest PHP version.
Compress photos to minimize their size.
5 Things to do to write better PHP
By: Mhd Omar Bahra
I would do well to remember - and implement - these tips because I'm absolutely guilty (not a bad thing) of them all.
Most meaningful to me; simplifying the use of
I'm sure you will find these 5 tips useful as well.
Understanding /etc/passwd file in Linux
By: Sneh Chauhan
The Linux /etc/passwd file is a text file that stores important user information. There are specific commands made to edit this file with additional information for existing users or in the case of adding a new user.
I haven't needed to edit this file for any of my personal single-user Linux installs.
PHP print_r() Function With Example
By: Parvez Alam
I always use
file_put_contents() when logging errors to a log file. Many PDO database errors are in the form of an array and
print_r() returns arrays as human-readable.
One interesting point I learned is that
print_r() shows both private and public object properties.
Insert data from user uploaded spreadsheets in your MySQL database
By: Love Spreadsheets
I say it all the time; CSVs are everywhere.
I appreciate any type of tooling or process that makes uploading CSVs easier and less involved.
And, that's just what this tool does according to the excellent information and walkthrough in this article.
The Creat[ive][or] In Us
"Stand out in the crowd."
"Print and hang above the desk."
"I'm adjusting accordingly."
“I am currently here.”
How Can I Help You
📰 Get your brand, product, or service the attention it needs with affordable classified ad placement in the OpenLampTech newsletter.
Discover premium MySQL learning material over in my Kofi Shop today!
Thank you for reading. I hope you have a great rest of your week.
Visit my developer blog, Digital Owl’s Prose, where I write regularly on CodeIgniter, PHP, WordPress, and SQL.
Want to support this newsletter and my work? Drop some spare change in my Tip Jar.💰
Disclosure: Some of the services and product links in this email are affiliate links. At no additional cost to you, should you make a purchase by clicking through one of them, I will receive a commission.