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:
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)
#linux
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
#php #codeigniter
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)
#php #drupal
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
#wordpress
This article on the WordPress command-line interface covers the different commands and their structures.
The commands are broken into 2 categories:
Parent commands
Subcommands
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.
MySQL Backslashes
By: Michael McLaughlin
#mysql
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
#php
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
#sql #mysql
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 andGROUP BY WITH ROLLUP
(learn more aboutWITH ROLLUP
here) quite often in reporting queries that are sent to a Web page with PHP and I write the raw SQL code and use the CI4query()
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."
Should I have a lawyer create my business entity?
"I've been wondering about this myself." 🤔
Adventures of being a solopreneur.
"Are you having any adventures?"
Get Comfortable With Being Uncomfortable
"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
Support OpenLampTech, my blog, and my work with a coffee if you like.☕
📰 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.
Take care.
Joshua Otwell
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.