OpenLampTech

Share this post

OpenLampTech issue #41

openlamptech.substack.com

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!

Joshua Otwell
Aug 26, 2022
1
Share this post

OpenLampTech issue #41

openlamptech.substack.com

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 📣

A Byte of Coding


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…

Continue reading...

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:

OpenLampTech
OpenLampTech WordPress Wednesday #9
WordPress is changing at such a pace that it's a full-time gig just keeping up with it. That’s where I come in and why you are here. I’m not a WordPress developer, professional, or guru. However, I am a WordPress blogger and user and I am interested in learning WordPress…
Read more
7 months ago · Joshua Otwell

[#Ad]

Every day Refind picks 7 links from around the web for you, tailored to your interests. Loved by 50k+ curious minds.

Subscribe for free today.


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

#php #symfony

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. 

↗️ Read this article…

WordPress Vs Drupal – Major Differences

By: teadmin

#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:

  1. Drupal is more flexible

  2. Drupal allows for more advanced user permissions

  3. WordPress requires less technical expertise 

↗️ Read this article…

WordPress Vs Joomla – Major Differences

By: teadmin

#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📱

↗️ Read this article…

How I use the Linux sed command to automate file edits

By: Jim Hall (via opensource.com)

#linux

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 (grep, awk, etc…), ignore it at your own peril.

Dive into sed in this quick article with solid examples to get you going.

↗️ Read this article…

10 PHP Testing Tools for WordPress Plugins

By: Leonardo Losoviz (Kinsta)

#wordpress #php

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.

↗️ Read this article…



How to Export WordPress Form Entries to CSV and Excel

By: WPBeginner

#wordpress

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. 

↗️ Read this article…

An Overview of SQL Text Functions in MySQL

By: Tihomir Babic

#mysql

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:

  • TRIM()

  • SUBSTRING()

  • REPLACE()

Similar: TRIM() string function in MySQL – with examples

↗️ Read this article…

Is COUNT(*) slow in MySQL?

By: Aaron Francis

#mysql

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.

  • Use COUNT(column) if you are interested in a non-null count.

Similar: MySQL COUNT(*) and COUNT(column or expression) — Differences

↗️ Read this article…


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."

A gentle introduction to HTML

"Foundational HTML knowledge can open many doors for you."

Newsletters ≠ Email Marketing

"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!

https://markodenic.com/tools/buttons-generator/


Thank you for reading OpenLampTech. This post is public so feel free to share it.

Share


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.

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.💰

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.


[#Affiliate]

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.

Get Hosting with Hostinger!

Share this post

OpenLampTech issue #41

openlamptech.substack.com
Comments
TopNewCommunity

No posts

Ready for more?

© 2023 Joshua Otwell
Privacy ∙ Terms ∙ Collection notice
Start WritingGet the app
Substack is the home for great writing