OpenLampTech issue #41
Is MySQL COUNT(*) slow; PHP testing tools; Linux sed command; Symfony UX Twig components; WordPress vs Joomla; Thank you for reading OpenLampTech and making the publication a success!
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!
Newsletter Shout-out 📣
Recently Published on the Digital Owl’s Prose Blog
We know that when filtering text data in a MySQL WHERE clause conditional, strings are placed in single quotes. In this blog post, learn how to filter numeric data in a MySQL WHERE clause conditional…
Recently Published in the OpenLampTech Publication
I published the OpenLampTech WordPress Wednesday #9 for August 24th, 2022. There are several links to great WordPress-related content.
Find out more in the publication piece:
Every day Refind picks 7 links from around the web for you, tailored to your interests. Loved by 50k+ curious minds.
Linux | Apache | MySQL/MariaDB | PHP
I have curated some fantastic reads for you this week. Let’s get to them!
Discover Symfony UX’s Twig Components. UI without JS or BS.
By: Reuben Walker
You can't go wrong reading any of Symfony Station's in-depth - and honest - articles.
In this article, there is a clear explanation of what Symfony UX is and how it works.
Also, learn about Twig and Twig Components with best practices and template code structure.
WordPress Vs Drupal – Major Differences
#wordpress #drupal #php
Both WordPress and Drupal are 2 powerhouses in the PHP CMS world but which to use?
Aside from the fact that both of these CMSs are likely running on the LAMP stack, what do they not have so much in common?
Find out by exploring these 3 (opinionated) sections:
Drupal is more flexible
Drupal allows for more advanced user permissions
WordPress requires less technical expertise
WordPress Vs Joomla – Major Differences
#wordpress #joomla #php
Joomla is not near the forefront of the PHP-based CMS discussion as perhaps Drupal or WordPress but nevertheless, it is there.
How different are both Joomla and WordPress from each other?
They obviously share some major similarities.
Visit these sections in the article to learn their differences as laid out by the author:
Better SEO leans towards WordPress
Joomla is less customizable than WordPress
WordPress is better supported for mobile📱
How I use the Linux sed command to automate file edits
By: Jim Hall (via opensource.com)
A few years back, I just barely scratched the surface of the Linux
sed command and realized just how powerful it really is. I even wrote an article about it in the early days of my blog.
Although it doesn't seem like
sed gets as much attention as other built-in Linux commands (
awk, etc…), ignore it at your own peril.
sed in this quick article with solid examples to get you going.
10 PHP Testing Tools for WordPress Plugins
By: Leonardo Losoviz (Kinsta)
Writing tests is Kryptonite to me in my coding journey so far and I need to 'tighten up' in this aspect.
This passage from the article got my attention from the get-go:
"No single tool is enough to handle all aspects of testing an application from all different possible angles."
Tools mentioned in the article, I am familiar with:
DevKinsta - I really like the ease of setting up a local WordPress install environment.
PHPUnit - I need lots of work to become better versed with PHPUnit.
WordPress Export Tool - Easily create database snapshots.
How to Export WordPress Form Entries to CSV and Excel
Collecting your form data into a spreadsheet makes sense for any number of reasons. There are form builder plugins galore in WordPress but honestly, none are easier to use than WPForms.
While I only use the free version, this article shows you how to use the premium WPForms plugin to export collected form data to a spreadsheet.
An Overview of SQL Text Functions in MySQL
By: Tihomir Babic
If you are processing data, you will encounter text data at some point. If PHP is your scripting language of choice, you can leverage many of the built-in string functions.
However, if you are working at the MySQL layer, there are text functions available for data processing there as well.
Learn about the common MySQL functions and see examples in this walkthrough.
Some text functions I use a great deal are covered here:
Similar: TRIM() string function in MySQL – with examples
Is COUNT(*) slow in MySQL?
By: Aaron Francis
This is a fantastic article and I really like this passage quoted directly from the source:
"While SELECT(*) selects all the columns, COUNT(*) is specifically optimized to count all the rows."
Here are some of the points I'm taking away from this great read:
COUNT(*)uses the smallest available secondary index to determine the count.
In InnoDB, secondary keys also have a copy of the primary key.
COUNT(column)if you are interested in a non-null count.
Similar: MySQL COUNT(*) and COUNT(column or expression) — Differences
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
MariaDB buys geospacial specialist CubeWerx
"Geospatial capabilities are a game changer."
Why Great Things Never Came From Comfort Zones
"I try every day to get more comfortable being uncomfortable."
"Foundational HTML knowledge can open many doors for you."
"They are definitely not one and the same."
14 Proven Ways to Drive Traffic to Your Website
"Without traffic, you are virtually unknown."
Twitter Treasure Find
I bookmarked the tweet I saw to this epic site that has HTML buttons galore you can use. Although I can’t find the tweet anymore, I did find the link. This is so cool! An HTML Buttons Generator!
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!
Some inspirational ‘Thank You’ cards are in this Etsy Shop.
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.
I run 2 niche WordPress websites and 1 CodeIgniter application, all proudly hosted on Hostinger. I couldn’t be happier with their product and support. And, they offer free SSLs.