OpenLampTech issue #45
Symfony's Twig; MySQL PIVOT; 5 SQL books you must have; 10 popular Linux distros; Thank you for making OpenLampTech a success!
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've been publishing more content this week in OpenLampTech.
Want to grow your SQL skills? Here are 5 books that will help you get there 📚
I published the OpenLampTech WordPress Wednesday #13 for September 21st, 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!
Static and Dynamic Pivot in MySQL 8
By: Mickael Andrieu
#mysql
As of the time of this writing, MySQL does not have a dedicated PIVOT
function. Yet, there are some crafty ways you can get around not having a native PIVOT
function — namely GROUP BY
and CASE
.
But, if you don't know how many expressions are needed for the CASE
statement, how can we have dynamic-like code?
Explore more and find out.
Top 10 popular Linux Distros in September 2022
By: Heyan Maurya
#linux
There are many different Linux distributions or distros for users to choose from. They all serve different purposes and cater to a user's particular needs. The swap over friction of changing from Windows or macOS to Linux is less and less these days.
This article has a nice synopsis and benefits of use for popular Linux distros you can use.
I like these 3, having used them all at one time or another:
Linux Mint
Manjaro
Ubuntu
Pro Tips: How to avoid database deadlocks when working with CRON jobs
By: Peham Raza (Discovered shared via Symfony Station newsletter)
#mysql #php #Apache
I've only encountered a deadlock once on a production MySQL server for a web application I developed. However, the deadlock wasn't related to any CRON jobs/tasks.
Nevertheless, getting it all sorted out and taken care of was nerve-wracking, to say the least.
It's better to avoid them altogether.
How to Send Reset Password Link Email Using PHP?
By: Your Blog Coach (Discovered shared via PHP Weekly)
#php
We all know how important email is as a communication means and link to users. Maintaining email credentials is necessary for any application, service, or project.
In this post, see examples of creating the necessary forms and sending email reset password links for those users.
Remove Permissions for a MySQL User on Linux via Command Line
By: Ronald Caldwell
#mysql #linux
Certain MySQL users need or don't need certain permissions.
Permissions help manage and control access to the MySQL database. If you're using CentOS Linux and comfortable with the command line, this is a great resource to learn how to remove any unneeded permissions from a MySQL user with the REVOKE
command.
How Long Does it Take to Build a Niche Website?
By: Sandeep Singh
#wordpress
Without a doubt, WordPress 'fits the bill' for most of the niche website use cases and requirements. I just wish I would have found - and followed - a lot of the planning steps outlined in this article when building my bass fishing niche site.
I'm slowly learning a lot more goes into a niche website than just tossing one together.
Twig: The Ultimate Guide to the Premier PHP Templating Language
By: Reuben Walker
#php #symfony
Unfortunately, at the time of writing, my PHP framework of choice doesn't have built-in templating.
However, if you're using Symfony, you have Twig.
This article has in-depth information on:
Twig's history
How to use Twig
The benefits of Twig and why you should use it.
[#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
A Web Developers Workflow for GitHub
"Git gets the best of me."
"It's inspiring to see someone boldly scrap it all and start over."
How do you stick with one idea when you have multiple?
"Someone was kind enough to write this for all of us."
What type of programmer are you? Hacker, mathematician, or maker?
"Certainly not a mathematician."
7 mistakes creators make from a creator who’s made them
"Many greats are paving an easier path for us all."
Thank you for reading OpenLampTech. This post is public so please share it to generate more reads.
I'm enjoying this fantastic ebook, Next-Level Database Techniques For Developers.
You most certainly should add it to your reading list.
How Can I Help You
Support OpenLampTech, my blog, and my work with a coffee if you like.☕
📰 Get your brand, product, or service the attention it needs with affordable classified ad placement in the OpenLampTech newsletter.
Some inspirational ‘Thank You’ cards are in this Etsy Shop.
Thank you for reading. 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.