OpenLampTech

Share this post
OpenLampTech issue #9
openlamptech.substack.com

OpenLampTech issue #9

MySQL server triage; CodeIgniter 4 YouTube playlist; WordPress book roundup; ETL in MySQL; UNION queries in Laravel; Explaining Explain; The Hub by WPMU DEV

Joshua Otwell
Jan 14
Share this post
OpenLampTech issue #9
openlamptech.substack.com

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:

Thanks for reading OpenLampTech! Subscribe (it’s free) and receive new posts by email, be part of a great community, and support my work.


I have curated some fantastic reads for you this week. Let’s get to them!

This Week’s Picks

✔️ How to search multiple models easily with Laravel Eloquent without using packages

#php #laravel #mysql

This post covers UNION queries with Laravel's Eloquent ORM. I'm not 100% sure if the framework I use (CodeIgniter 4) has a dedicated UNION method but this option in Laravel seems way cool to me. UNION is one of the SET operators and is used to stack SELECT query results one on top of the other.

➡️ Read this post…

✔️ CodeIgniter 4 Tutorials for Beginners

#php #codeigniter

I mostly share written content in the OpenLampTech newsletter. But, I have to share this YouTube video playlist. This is a massive 50+ video playlist covering CodeIgniter 4 development for beginners. I've learned so much from these videos and continue to do so to this day. If you want to learn CodeIgniter 4 and gain a good understanding of the framework, this is a great place to start.

➡️ Visit the playlist…

✔️ Best WordPress Books To Learn Platform

#wordpress

I'm familiar with a couple of books on this list and since I like book roundups so much, I thought to share this one about WordPress books here. Let me know which of these (if any) are your favorites.

➡️ Read this post…

✔️ MySQL 101: Basic MySQL Server Triage

#mysql

The Percona blog has top-notch content about open-source databases and we can learn a lot by reading any one the posts there written by the experts. This post has several tips and suggestions for collecting diagnostic information on a downed server. I'm definitely keeping this one bookmarked.🔖

➡️ Read this post…

✔️ EXPLAINing the Different EXPLAINS In MySQL

#mysql

The MySQL EXPLAIN command can be used on several different types of queries to know and understand just how the server is executing that statement. It should have been named, EXPLAIN TO ME PLEASE, in my opinion, because much of the output is difficult to decipher. This post covers available alternative output formats you can use with the EXPLAIN command.

➡️ Read this post…

✔️ Run Your WordPress Business Like a Pro with WPMU DEV

#wordpress

I am a WordPress blogger and user. I feel that if I put in the work, I can learn WordPress development and someday join the freelancer pool in this ecosystem. With my affinity for PHP and MySQL, I already have a pretty good head-start at least in the area of 2 of the CMS’s core languages.

All that said, I read this post (and watched a similar YouTube video) about a phenomenal piece of software that I think of as a "WordPress Professional's Delight".

Manage multiple sites, apply updates to plugins (on multiple sites), offer reseller hosting, bill your clients, set up sites with pre-made templates, etc. It's all there.

I am talking about WPMU DEV's The Hub (I highly recommend subscribing to their newsletter, The WHIP, also). It looks like one incredible piece of software and makes me want to really explore the WordPress Professional freelance route.

➡️ Read this post…

✔️ ETL in MySQL – How to automatically load data into a table every day

#mysql

I am soon-to-be-tasked with figuring out how to upload a large amount of CSV data into several MySQL tables in a processing workflow. Admittedly, I have no idea how to do it (yet). However, I found this fantastic article that has me optimistic and looks to at least put me on the starter path.

➡️ Read this post…

✔️ It doesn’t belong in the database — WordPress + ACF

#mysql #php #wordpress

I've not used the ACF plugin for any project work (yet) but I'm aware that it is a popular WordPress plugin. This post looks at registering the custom fields programmatically in PHP.

➡️ Read this post…


⭐⭐⭐ 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 republished a post this week on my blog, Digital Owl’s Prose, that I first shared over on my Medium account. Check out:

CodeIgniter 4 Query Helper getLastQuery() method – MySQL Prototyping


Extra stuff…

  • 3 SQL Swaps to Write Better Code

  • The Power of Doing Only One Thing

  • SQL Joins: A Guide That Makes It Stupid – Simple

  • This Is Why Our 3000 Apache Servers Went Down On The First Day of 2022


Did you enjoy this issue of OpenLampTech? Please share it with others so that they can enjoy the content as well. Thank you!!!

Share


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

Share OpenLamp.tech


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

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 Image by Andrew Martin from Pixabay

Share this post
OpenLampTech issue #9
openlamptech.substack.com
Comments

Create your profile

0 subscriptions will be displayed on your profile (edit)

Skip for now

Only paid subscribers can comment on this post

Already a paid subscriber? Sign in

Check your email

For your security, we need to re-authenticate you.

Click the link we sent to , or click here to sign in.

TopNewCommunity

No posts

Ready for more?

© 2022 Joshua Otwell
Privacy ∙ Terms ∙ Collection notice
Publish on Substack Get the app
Substack is the home for great writing