OpenLampTech issue #34
WP-CLI; Is Drupal a shark; 15 VPS security tips; CodeIgniter 4 CRUD; MySQL backslashes; PHP and Airtable? Laravel vs WordPress? Thanks for reading OpenLampTech!!!
Hey hey glad to have you here reading OpenLampTech! 👍
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 the Digital Owl's Prose developer blog, I published a fantastic guest post by Harikrishna Kundariya.
Harikrishna Kundariya is the Director of eSparkBiz Technologies @Software Development Company.
Read the article, Using WordPress For Your Next Website Project? Understanding Its Pros And Cons!, for a high-level overview of the CMS's strengths and weaknesses.
Thank you Harikrishna Kundariya for contributing to the blog!
Recently Published in the OpenLampTech Publication
The OpenLampTech publication shared the WordPress Wednesday #2 article for July 6th, 2022.
Check it out:
Linux | Apache | MySQL/MariaDB | PHP
I have curated some fantastic reads for you this week. Let’s get to them!
15 VPS Security Tips to Prevent Attacks on Your Server
By: Noviantika Gita (via Hostinger)
The Linux server is the base of the LAMP stack and keeping it safe is of utmost importance.
I have these tips from the article on my mind moving forward:
Change default SSH port
Use SSH keys
Use SFTP instead of FTP
Simple CRUD App in CodeIgniter 4
By: Sanjay Bandla
Frameworks' built-in functionality helps with the common CRUD operations and CodeIgniter 4 shines in this area in my opinion. This is a fantastic, in-depth article that covers building a CRUD App with CodeIgniter 4.
I am particularly interested in extending the
ResourceController in a Controller class as I've not (yet) had to use it for a REST API.
Why Drupal is a Shark
By: Dominique De Cooman (discovered shared via Symfony Station)
Look out! Sharks cruising the depths…
This article shares the take on how Drupal is more about quality than quantity.
And, it's also the first place I can recall encountering the DXP (digital experience platform) term.
Other interesting points I'm thinking about:
Drupal using MACH architecture.
Drupal's barrier to entry is becoming more challenging.
Drupal's impact is a better indicator than its number of installs.
Our Guide to WP-CLI Command Structure
By: Erik Torsner
This article on the WordPress command-line interface covers the different commands and their structures.
The commands are broken into 2 categories:
I've not personally used WP-CLI but I am familiar with the command line and use it in other aspects and know it is quite powerful.
I feel like WP-CLI affords the developer great power as well.
By: Michael McLaughlin
Are there some backslashes in your JSON data you want to remove? With a few
REGEXP_REPLACE() function calls and some good ole MySQL, you absolutely can.
I'm digging this author's blog and content so be sure and check it out for a take from one of the experts.
Write to an Airtable with PHP
By: Stoyan Stefanov
There is a lot of information out there on PHP. There is also a lot on the internet about Airtable. But, you don't see them mentioned together (or I haven't) too much.
However, between using
curl in PHP and an Airtable API key, apparently, you can get it done.
Pretty neat concept and has me wondering if there is a side-hustle market for this type of PHP and Airtable use?
SQL tips for beginners; what I learned after 10+ years of occasionally writing queries and schemas as a web dev
By: Raphaël Huchet
Although I've not been working towards being a Web Developer for anywhere near 10 years, I've known SQL a lot longer than PHP (but still not 10 years).
There are several great pointers in this article and I'm adding my touch to these 3:
Use raw SQL for complex queries. The ORM or Query Builder can't always do it all. For the CRUD operations, yes. But other stuff, not so much. I use the
ROW_NUMBER()Analytic function and
GROUP BY WITH ROLLUP(learn more about
WITH ROLLUPhere) quite often in reporting queries that are sent to a Web page with PHP and I write the raw SQL code and use the CI4
query()function (in my particular situation).
Just as the author mentions, you can use indexes to a lot of advantage but there is also a write cost. Indexing everything is not a good practice either.
Using the correct data type is very important. If you are working with a date value, use
DATE. Not a text-based type. You lose a lot of type-based benefits if not using the appropriate data type.
WordPress vs Laravel PHP Framework: Which is the Best Option for You?
By: Ismat Babirli
#php #wordpress #laravel
I'm glad that early on in this article, the author points out that about all these 2 have in common is they both use PHP.
Because that's pretty much it (other than being open-source but perhaps not even with the same type of license?).
All that said, there is a lot of good information here on both tools. A good read you can learn about the differences and individual strengths of each.
I like it because this isn't just another comparison article you see floating around on the web.
I discover many articles I read and share in the OpenLampTech newsletter 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.
The Creat[ive][or] In Us
"Getting out of it is what counts."
"Accessibility is important."
"I've been wondering about this myself." 🤔
"Are you having any adventures?"
"I'm glad someone else can describe what I'm always feeling."
Check out this free HTML book I saw on Twitter.
I downloaded a copy myself and it covers some of those overlooked gems of HTML. Good stuff!
Thank you for reading OpenLampTech. This post is public so feel free to share it.
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.