OpenLampTech issue #46
Low-cost mailing list with phpList; WordPress plugin boilerplate; MySQL FULLTEXT indexes; Linux bash files; We are growing and I can't thank you enough!
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:
Newsletter Shout-out 📣
Recently Published in the OpenLampTech Publication
I published the OpenLampTech WordPress Wednesday #14 for September 28th, 2022. There are many many articles for us all to learn something from:
[#Ad]
Every day Refind picks 7 links from around the web for you, tailored to your interests. Loved by 50k+ curious minds.
Linux | Apache | MySQL/MariaDB | PHP
I have curated some fantastic reads for you this week. Let’s get to them!
What’s the Difference Between .bashrc and .profile on Linux?
By: Dave McKay
#linux
That's a dang good question.
One I've often wondered about myself.
This article begins with an overview of different types of interactive and non-interactive shells. Also, learn which file to place bash customization settings in.
Many distros differ in how they read specific bash-related files.
Learn from a general summary and overview of the difference between these 2 key files.
Revised PHP Backend Roadmap
By: (discovered shared via PHP Weekly)
#php
I'll add to the already stated in this article; web development is tough for newcomers and seasoned developers alike.
There is always something to learn and just knowing where to go and what to learn are half the battle in and of itself.
This article somewhat lays out a massive roadmap of different facets of PHP development you can follow.
Code Like a Pro in PHP with Interfaces
By: .com software
#php
I'm still learning the ins and outs of Interfaces and how to use them in my PHP code.
I see them a lot in the base files of my framework of choice (CodeIgniter), but don't typically write any of my own.
The author provides 2 fantastic quotes, summarizing Interfaces:
"Interfaces allow you to specify the behavior of an object without having to worry about the implementation details”
"The most important thing to understand about interfaces is they are nothing but a promise of how the code WILL BEHAVE, not how it exactly “will work.”
How FullText index works in MySQL
By: Amit Tiwary
#mysql
MySQL has different index types you can use for different purposes in order to make your queries more performant.
One such index is FULLTEXT,
which works well for multi-word character-based data.
Learn the details of how InnoDB creates and uses an FULLTEXT
index in this article.
Semi-related: SQL Performance Explained is hands-down one of the best books out there on SQL indexing.
3 WordPress Plugin Boilerplate
By: Kamal
#wordpress
WordPress plugins need a base set of starter files or boilerplate.
Learn about 3 useful programs you can use to create a starter boilerplate:
WP CLI
WP Strap
WPPB.me
I've not personally used any of these programs in my limited WordPress development experience but plan to make use of one (or all) of them when I learn plugin development.
5 Things you might not know about PHP
By: Vlad Reshetilo
#php
The more I use PHP, the more I am surprised by this powerful language (and even more why it receives such a bad rap).
Out of the 5 topics in this article, 1 is a pleasant surprise for me and 1 is a favorite.
Surprise - Multiple arguments in
isset()
Favorite - Null Coalescing Operator (
??
)
There is always more to learn and I appreciate discovering new features about PHP.
AWS Low Cost Mailing List Using phpList And SES
By: Ian Elliot (discovered shared via opensource.com)
#php #mariadb #aws #linux
I'm not nearly gutsy (or knowledgeable) enough to run my own mailing list server. But, if that sounds like something you are interested in, then this article is for you.
Essentially, these steps are covered:
Provisioning a LAMP stack
Installing phpList (a PHP-based open source list manager)
Configuring MariaDB and building the schema
Setting up Amazon's SES service for sending emails.
[#Ad]
Leads for your business or agency done right!
Malthus helps you connect with new prospects and leads for your business or agency needs to help drive sales and growth.
The Creat[ive][or] In Us
Blogging Mistakes: 10 Signs Your Blog Post Is Going Horribly Wrong (Discovered shared via Refind)
"Redirect if you see any of these signs."
How to insert a text box in Google Docs
"Google Docs are the foundation of my content efforts. Learning all I can about them."
When designer email software doesn't work out: My Gmail inbox tabs hack
"My Gmail looks like a teenager's room. I have work to do."
10 Self-Publishing Resources for Authors
"Write your own way."
"It's not limiting."
Thank you for reading OpenLampTech. This post is public so feel free to share it. Thanks!
Job Ad Placement
Have a job you need to fill? Tell the OpenLampTech audience all about it.
Get your job ad in the OpenLampTech newsletter for only 35$ USD/week.
Send me an email at openlamptech@substack.com if you are interested in a job ad placement.
Interesting Tech News and Articles 📰
🔎 Oracle Sanctioned By The SEC (Again) For Corrupt Misconduct In The Middle East And India
🔎 Arcion Announces Agentless Change Data Capture for Azure, SQL Server, Oracle, SAP HANA, and MySQL
Thank you for reading OpenLampTech. 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.💰
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 operate 2 niche WordPress websites and 1 CodeIgniter application, all proudly hosted on Hostinger. I couldn’t be happier with their product and support. Plus, they offer free SSLs.
Tons of info, Josh. Lot of reading to do. 👍