OpenLampTech issue #89
Index URLs in MySQL | The .htaccess file | Slackware Linux | MySQL Heatwave and data lakes | WooCommerce Blocks 10.7.1
Thank you for reading the OpenLampTech developer newsletter!
If someone awesome shared this newsletter with you and you are not yet subscribed, please use the Subscribe button below and join:
OpenLampTech has sponsorship opportunities in the weekly newsletter for your brand, product, or service. As an independent publication, collaboration is very budget-friendly. Inquire by email at openlamptech@substack.com for more information.
Small e-commerce layouts and design touch-ups make for a great learning experience for me. In this post, we will move the product title from its original location to just above the product image on the Shopify Dawn Theme collections page.
Mobile wallpapers, digital downloads, photos, development services, and content - all in one E-Commerce Shop. Find your next digital purchase today!
All commentary is by me unless otherwise quoted.
Learn about some of the limitations of MySQL's default index key prefix length when it comes to dealing with URLs. Since URLs can vary in length and contain multi-byte characters, hashing may be a better solution. [ssv45.com]
How MySQL Tuning Can Dramatically Improve WordPress Performance
Without a performant database, a WordPress site, or any site or application for that matter, will not operate to its fullest potential. MySQL tuning is an art just as much as the science behind it. Roman Agabekov of Releem is a pro at this type of programming configuration. [Medium]
Everything you need to know about the WordPress .htaccess file
In my opinion, the .htaccess file is the wizard's spell book of a website using the Apache web server. You can control so many different behaviors at the directory level (and more!) with the .htaccess file. [Security Boulevard]
Slackware wasn't the first Linux distro, but it's the oldest still alive and kicking
I'll never forget somewhere around late 2013/early 2104, I took an old dead-in-the-water Dell Inspiron notebook and installed Slackware on it. My Linux enthusiasm and knowledge changed forever. Talk about fun and an incredible learning experience (unfortunately most of which I have forgotten). [The Register]
Master Symfony URLs with this 5 Minute Definitive Guide
User and SEO-friendly URLs are crucial for websites. I'm most familiar with CodeIgniter's routing structure. Here we can learn about how another of the powerful PHP frameworks, Symfony, handles routing. [anastasionico.uk]
The WordPress Dashboard Needs Some Love
There is no doubt the WordPress backend is a hot mess. You know, honestly, I think I would be okay with it if there weren't so many notification bubbles from every plugin you have installed when they are running some kind of promotion. An overhaul is due. And, probably is coming. But, who knows how that will be either. [The WP Minute]
Release and upgrade information
WooCommerce Blocks 10.7.1 Release Notes
MySQL Heatwave dives into object storage data lakes
📰 Get your brand, product, or service the attention it deserves with affordable classified ad placement in the OpenLampTech newsletter.
[#Classifieds and Click Ads]
🤝 OpenLampTech earns a small commission (or payment in some form) from many of these links. Your support helps keep the weekly OpenLampTech newsletter free for readers.
Grab this free M2 MacBook Air Desktop Wallpaper and let me know what you think about it.
We make incorporating a company as easy as possible so that you can focus on the essential things. Visit IncFile today.
Compliantly hire anyone, anywhere, in 5 minutes with Deel
Deel is your one-stop shop for hiring, paying, and managing your remote team.
Thank you for reading. I hope you have a great rest of your week.
Take care.
Josh Otwell
When you are ready, here are more ways I can help...
Content and Development Services - Blog writing and editing; Shopify and WooCommerce customizations; Email newsletters, marketing, and copywriting.
Interested? Great!
Just hit Reply and ask for more information about any of these services.
OpenLampTech is a reader-supported publication. You can support the publication with a virtual coffee for as little as $3 (USD).