Discover more from OpenLampTech
OpenLampTech issue #12 - My RTC Interview
My RTC Interview; Parsing data with SQL; WordPress plugin database tables; Best open source databases; AJAX and PHP in WordPress; A really cool tweet for PHP devs
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 recently participated in an interview over on the Real Tough Candy website where I answer questions about my backend developer journey, why I like PHP and SQL development, and other PHP-related questions. I share a lot of my story in this post that is not published online anywhere else. Thanks, RTC for allowing me to participate! Enjoy!
I have curated some fantastic reads for you this week. Let’s get to them!
This Week’s Picks
✔️ Creating Custom Database Tables for Your WordPress Plugins
I am slowly making my way into trying to learn WordPress development. Having only been mostly exposed to Vanilla PHP and CodeIgniter, I definitely find something interesting about WordPress's ecosystem for PHP development. Not that I have anything against CodeIgniter or Vanilla PHP. I just want to keep my options open for some freelance development opportunities. I am a devout reader of the WPMUDEV newsletter, "The Whip", and they always have fantastic blogs and articles.
I recently enjoyed this one in which they cover the pros and cons of creating database tables for your plugins. If you need to create a database table for your plugin, then they cover the best practices from what I interpret as the "WordPress Way" to go about it.
✔️ The Best in Open Source Database Software: Top 10 Picks
SQL is my first and most favorite programming language and I have published (mostly) SQL-related blog posts on my blog, Digital Owl's Prose, for over 4 years now. All that said, it is no surprise that I thoroughly enjoyed this article by the Kinsta team. I have said it before and I will say it again; Kinsta writes some great blog posts.
There are quite a few databases in this article that I am not all that familiar with but nevertheless, MySQL and MariaDB both are in my sweet spot so I enjoyed this article that covers an enriched, high-level overview of each of these 10 mentions.
✔️ Using AJAX and PHP in Your WordPress Site Creating Your Own Plugin
I use AJAX quite often in development and it is handy for a smooth interactive flow in web pages.
In this post by the WPMUDEV blog, they cover:
What is AJAX
What AJAX does.
Advantages of AJAX
How AJAX works in WordPress.
The post then demonstrates how to create a plugin in WordPress that uses AJAX. Great stuff for someone like me learning more about WordPress development.
✔️ Parsing Data with Just SQL
The Arctype blog content always impresses me and always teaches me something valuable every time I read one of their articles. I have shared many of their pieces in the OpenLampTech newsletter in the past.
This blog post covers useful tips for parsing large files with MySQL in an efficient way using commands like:
CREATE TABLE AS
LOAD DATA INFILE
We also learn valuable database settings to use when parsing a large amount of data along with some problems that can occur.
✔️ How to build a basic web application with CodeIgniter 4
Here is a 6-part series treat for readers. I have learned so much from these 6 articles. Thanks to them, I really turned the corner in my CodeIgniter understanding and development. I actually learned about, somewhat understood, and began using Entities because of a couple of these articles.
Read them all and enjoy.
✔️ A cool and resourceful PHP tweet
⭐⭐⭐ 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
A fantastic guest post covering how to set up MySQL in a docker container.
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.
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.
How can I help you?
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.