OpenLampTech issue #13
Database concurrency; .com or .org for WordPress; Laravel Eloquent Tips; MySQL COALESCE(); Upgrade MariaDB; WordPress database prefix
Hey glad to have you here! 👍
If someone shared this newsletter with you and you are not yet subscribed, please use the Subscribe button below and join:
Newsletter shout-out 📣
You absolutely must check out Rick’s Tech Tips Newsletter. Get easy-to-follow tech tips in your email inbox.
I have curated some fantastic reads for you this week. Let’s get to them!
This Week’s Picks
✔️ Database concurrency as simple as possible
#php #sql #database
I read this article I first discovered shared in the Symfony Station newsletter (one of my favorite newsletters that you should definitely check out).
There is good information in this article, explained in a simple way that is easy to digest for someone (like me) still learning the ropes on concurrency, using a sample bank account flow.
✔️ WordPress(dot)com vs WordPress(dot)org: Which Is Better for Your Website?
#wordpress
I must fully admit when I started blogging consistently over 4 years ago, I had no idea there was a difference between the .org and .com WordPress flavors. I've been on and stuck with .com for my site, Digital Owl's Prose.
However, I'm learning to install, use, and develop on the .org WordPress flavor nowadays. But, I don’t really have any plans to move off of .com honestly.
In this post from Kinsta, you'll find an in-depth comparison between these 2 WordPress variants with the pros and cons of each.
✔️ 🔥 🚀 30 Laravel Eloquent Tips
#php #laravel
I'm not even a Laravel developer (yet) as I mostly use Vanilla PHP and CodeIgniter 4. All I can say is wow! This is a list of tips to help work with the database layer through Laravel's Eloquent ORM.
What's even better than just a list of tips, is that each tip has example code and explanations.
If I were a Laravel developer, I would bookmark this one. 🔖
✔️ Transform NULL values with the MySQL COALESCE function
#mysql
I published this post on my Medium account here recently and enjoyed writing it. I think NULL
can be one of those mysteries of SQL. But, the more you work with SQL and the database, the more you are exposed to NULL
and start to understand what it is and what it isn't.
MySQL has NULL
-specific functions you can use when dealing with NULL
and the COALESCE()
function is one option and is a powerful function.
✔️ WordPress Quick Reference
#wordpress #php
This is a resource page with links to common developer-related topics for WordPress developers. I love handy pages like this that just provide a useful resource for anyone to use and in this day in age of information overload, these types of resources are pure gold.
I want to create something similar for MySQL/PHP database operations. Could also be a great swipe file idea.
✔️ How to Upgrade MariaDB in Ubuntu 18.04 LTS
#linux #mariadb
Good article with step-by-step instructions on how to upgrade MariaDB. I like how this article includes an important step that a lot of people skip over; backup your database before you begin the upgrade.
Isn't there an old saying out there in the wide yonder that goes along the lines of, "You're only as good as your best backup?"
Words to live by...
✔️ Change Your WordPress Database Prefix to Improve Your Security
#wordpress #mysql #mariadb
SQL Injection (SQLi) is a real threat to any software using an SQL database and WordPress is definitely in this category as one of its critical and foundational pieces of core software is either MySQL or MariaDB. One method you can use to somewhat mitigate - but not foolproof - the potential for SQLi in WordPress is to rename the MySQL or MariaDB database table name prefixes.
This article by the WPMUDEV blog covers how to implement these database changes in a step-by-step plan. There are examples of sample queries for many of the tables you need to alter along with search queries to find other tables needing change as well.
⭐⭐⭐ Many of the posts I curate and share in this newsletter, I read and enjoyed on Medium. If you are not yet and member and wish to join the platform, I would be more than grateful if you would use my sign-up link. At no extra cost to you, I will receive a small portion of your membership fee when you sign up. Thank you! 🙏
Do you need to learn MySQL? Just starting and confused about how to query a table and get the data you need? I am creating premium MySQL Beginners content for this specific reason. To help those who want to learn the basics of MySQL but don't know where to start. Learn more about my premium MySQL blog posts and content as I develop and release them.
Extra stuff…
Support OpenLampTech, my blog, and my work with a coffee if you would like.☕
Similar Reading…
I recently published an article over on my Medium account, MySQL Beginners Series — The SELECT statement. This article is unfinished and I am seeking your feedback in order to help me craft the best MySQL beginner-friendly blog post I can. Check it out and drop me a line with your thoughts and feedback. Thank you! 🙏
Check out this post I published here on my OpenLampTech substack outside of the newsletter. Learn how to collapse multiple rows into a single row per group using the ROW_NUMBER()
window function and an CASE
expression. Neat and handy stuff!
Did you enjoy this issue of OpenLampTech? Please share it with others so that they can enjoy the content as well. Thank you!!!
“Reply” or comment and let me know what you think of this issue of OpenLampTech.
What do you want to see more of?!?
What do you want to see less of?!?
I’d love to know!
Also, share with me links to your published blogs and articles so that I can read them and possibly include them here in the newsletter!
Thank you for reading. I hope you have a great rest of your week.
Take care.
Joshua Otwell
Visit my blog Digital Owl’s Prose, where I write regularly on CodeIgniter, PHP, and SQL. I’m also active on Medium, LinkedIn, Twitter, and Instagram.
How can I help you?
Are you thinking of starting up a blog? I use WordPress for my blog, Digital Owl’s Prose. Let’s both save money on the plans offered. 💸
Grab a Gmail HTML Email Signature template from my Etsy shop and make your emails pop and stand out. ✉️
Need hosting for your next web application or WordPress site? I use and highly recommend Hostinger. They have great pricing and service.
I enjoy reading Refind: The essence of the web, every morning in your inbox. Subscribe for free. Help me get a premium subscription by signing up yourself with my referral link.
Grab a free pack of mobile Creator wallpapers with my referral link.
Just getting started or wanting to learn MySQL? Find out about my premium blog posts and MySQL Beginner Series here.
Want to support this newsletter and my work? Drop some spare change in my Tip Jar.💰
Disclosure: Some of the services and products 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.
Cover photo credits: Image by Click on 👍🏼👍🏼, consider ☕ Thank you! 🤗 from Pixabay