OpenLampTech No. 143
MySQL Visual EXPLAIN | Saloon API in Laravel | MySQL secure_file_priv | Go next-level in Linux | WooCommerce product type change? | Better hashing in PHP code
Thank you for reading the OpenLampTech 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 for your brand, product, or service in the weekly newsletter. As an independent publication, collaboration is very affordable.
All commentary is mine unless otherwise quoted.
Testing Saloon API Integrations in Laravel
This article is a snippet from Ash Allen's book, Consuming APIs In Laravel, where you can take your API skills even higher.
See code examples with excellent explanations each step of the way in Ash’s fantastic content.
[Ash Allen Design]
Security Tip: Stop Using MD5 and SHA-1!
Laravel security expert Stephen Rees-Carter shares information on why we should use other alternatives to MD5 and SHA-1 in our PHP code.
The password_hash() method with bcrypt is a solid choice in addition to other means covered in the article.
[Securing Laravel]
If you have ever tried to decipher the default output of MySQL EXPLAIN, then you know it is akin to reading ancient hieroglyphics.
This tool should drastically help with solving the riddle of MySQL query EXPLAIN contents.
[MySQL Visual Explain]
[Affiliate]
Consuming APIs in Laravel - Learn how to confidently integrate third-party APIs in your Laravel projects using maintainable, testable, and extensible code.
Want to Go Next-Level in Linux? Advanced Terms Explained
I love how the first section of this article is about shell, Bash, and scripting.
When working in/with Linux, scripting prowess is a huge benefit. Even on non-enterprise personal boxes, you can automate tons of things with shell scripting.
Learn more about the many advanced areas in Linux and their associated terms.
[How-To Geek]
Using secure_file_priv to Prevent Illicit MySQL Uploads
A long time ago, I wrote about the secure_file_priv setting, over on (the dying) Digital Owl’s Prose blog.
The secure_file_priv variable defines the location for safe data uploads in MySQL when either the SELECT INTO OUTFILE or LOAD DATA INFILE commands are used.
[dev.to]
Request for feedback: Simplifying WooCommerce products – A shift from types to traits (August 6th, 2024)
I'm not sure if this is a good idea or not. Product types have been around and have been used for no telling how long. However, I see where product traits could be a game changer too.
I'd be quite interested to see how backward compatibility would be implemented.
One thing I like is, it's open for feedback in the article link on Github.
[Woo Developer Blog]
Streamlining Data Integration with Views CSV Source: Insights from Daniel Cothran
Very interesting concept to use spreadsheet data as the source for a View instead of an actual database table (as I understand it).
Dealing with a lot of spreadsheet data myself, I can see where easy integration into a website is very appealing. Oftentimes, it’s not so easy to get the spreadsheet data up on a website without jumping through hoops (at least in my experience).
[The Drop Times]
Unlock MySQL Performance: Mastering Query Cache Optimization
As I learned from the author, Roman Agabekov of Releem, when sharing this article online, MariaDB still supports query cache but it was removed from MySQL v8x.
Learn about the different settings for query cache, why it may be useful, and who might potentially need to use it for better MariaDB performance.
[Medium]
[#Affiliates and Classifieds] - Your support keeps the OpenLampTech newsletter free for readers
Ultimate Laravel Boilerplate to help other indie hackers deliver their SaaS in hours. Get started with LaraFast today! (affiliate)
Popups, newsletters, and abandoned carts. Use Omnisend with integrated email and SMS campaigns. (affiliate)
Check out the Ecommerce Coffee Break newsletter (and podcast) for the latest in Shopify news. (subscriber incentive)
Thank you for reading. I hope you have a great rest of your week.
Take care.
Josh Otwell
Some links may be affiliate links from which I earn a small commission at no additional cost to you.