OpenLampTech issue #10
WordPress Hooks; Reporting queries in MySQL; NULL return types; Logging in PHP; mysqldump best practices; CodeIgniter 4 application checklist
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:
Support Shout-out 📣
Thanks so much to Bryant for buying me a coffee! ☕
I appreciate your support!!!
Support OpenLampTech, my blog, and my work with a coffee if you would like.
I have curated some fantastic reads for you this week. Let’s get to them!
This Week’s Picks
✔️ Hooks, Actions, and Filters of WordPress
#php #wordpress
This post has easy-to-understand explanations and examples of WordPress Hooks, Actions, and Filters. There is also a list of additional resources included in the article to learn more about these foundational concepts and principles in WordPress development.
✔️ Somewhat complex reporting and data analysis in MySql 8 — Part 1
#mysql
MySQL version 8 brought us 2 very important upgrades (among many in that release), Common Table Expressions (CTEs) and Window Functions. Both of these are game-changers in how you can write complex queries and I use each of them every chance I get when I find an appropriate application.
This post has great examples of both CTE's and one analytic window function, in particular, LAG(), showcasing some powerful reporting queries.
✔️ Null Return Types
#php
I first discovered this post shared in the fantastic Symfony Station newsletter.
There is so much to learn about programming and development every day. It's articles like this one that help those of us who need all the help we can get (raises hand) avoid all the rough edges and sharp corners on those things we might not have experience in (yet).
Great stuff in this one. Read and implement. I sure am...
✔️ Investigating an incident: how to log effectively (PHP)
#php
Admittedly, I use logging all the time for different reasons in application development. Mainly to understand database queries or debugging return values (or the absence thereof). This post has useful information and examples for writing a logger Interface and highlights the PSR-3 logger implementation.
✔️ Building WordPress Sites: The Eternal Battle Between Simplicity & Complexity
#wordpress
This post observes the fact that a lot of well-established WordPress sites out there didn't get that way overnight or immediately. Many long-standing sites took years of steady blood, sweat, and tears. Small and consistent improvements, iteration, and content make them what they are today. Start small, iterate, improve, and grow steadily is the overall feel of this post.
✔️ mysqldump Best Practices
#mysql
I am more of an SQL Developer / Backend PHP programmer so many of the important DBA-related tasks are outside of my wheelhouse. I recently read 2 fantastic blog posts on some best practices for taking - and restoring - backups with mysqldump. Check them out.
➡️ Part 1
➡️ Part 2
✔️ The checklist of things to check when your CodeIgniter 4 web application is not working
#codeigniter #php
CodeIgniter 4 definitely makes it super-easy to get a web application/site up and running quickly with a nice framework and scaffolding to build off of. However, if you run into any issues, here is a great post on some things to check over in your CI4 application.
✔️ What is a PHP framework? Which one is the best?
#php
There are many popular PHP frameworks out there today. I am most familiar with - and use - CodeIgniter 4. Laravel is heavily on my mind as well simply for the market share it has, not to mention that it is powerful. I feel like I should definitely learn Laravel someday. That being said, there are other PHP frameworks besides CodeIgniter 4 and Laravel. I read this great round-up post that you can check out for more insight into these frameworks.
⭐⭐⭐ 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! 🙏
Recently from the Digital Owl’s Prose blog
I learn a great deal about SQL by porting over queries from one SQL dialect to another. I wrote about this as I learned some new tricks in MySQL in this week’s post. Check out, Fill in missing Date ranges using MySQL.
Extra stuff…
Amazing HTML5 Features That Just 3% of Developers Knows — Easy and Surprising
Git for Web Development: Get to Know the Typical Workflow of a Project
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.
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 Денис Марчук from Pixabay