OpenLampTech issue #99
SQL Injections | WordPress HTML API | Stop blaming open-source maintainers | Active Record. OpenLampTech is a content and media source for PHP, MySQL, and the LAMP stack.
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 for your brand, product, or service in the weekly newsletter. As an independent publication, collaboration is very affordable. Inquire by email at openlamptech@substack.com for more information.
I published more of my favorite type of content this week in OpenLampTech; a fantastic developer interview.
This time around, with Joey Farruggio.
Read it here:
[#Affiliate]
The DNS course for developers
Who is this course for?
This course is for you if you want to gain mastery over DNS.
It assumes you have a basic understanding of how the internet works, but you don't need to be an expert. This course assumes no prior networking experience and involves no programming.
If you've worked on DNS full-time for over a year, this course is probably not for you. Otherwise, you'll learn a lot! If you invest in your knowledge today, you'll benefit for the rest of your career.
All commentary is by me unless otherwise quoted.
PHP Design Patterns: Active Record
The Active Record design pattern can have many responsibilities within its scope. Thus, differing from the Single Responsibility Principle. Read and learn about Active Record with example class methods in this article. The content demonstrates how to do INSERT
and UPDATE
operations with Active Record as well. [dev.to]
How to Ensure Database Consistency: A Guide to Laravel Migrations for Version Control
We know that in web applications, we have to store data in a database. Preferably, an SQL database. Migrations keep your database Data Definition Language (DDL) commands in (PHP) code in the application codebase. Also, ensure they are part of your version control workflow. [Medium]
The HTML API: process your tags, not your pain
WordPress is (attempting) to make it easier to work with HTML within the core product. There isn't any doubt that regular expressions can be(come) one cryptic mess. Real fast. Especially those parsing HTML. The WordPress HTML API is looking to solve all of that and more. I'm pretty excited about it. And I'm not necessarily having to parse HTML in WordPress either. Looks like a great feature add nonetheless. [WordPress Developer Blog]
What Are SQL Injections, and What Is the Risk to Businesses?
Everyone (yours truly included) should do the most they can in educating themselves on SQL Injection. SQL Injection is common, successful, powerful, and oftentimes very destructive for the business (many times unrecoverable). I'd say that is one nasty combination. Using prepared statements and other best practices can help minimize the risks associated with SQL Injection. [BizTech]
Stop blaming maintainers for open source risks
This piece is a whole can of worms unto itself. I honestly am not on the up-and-up with open-source software. Therefore, this quote from the article struck a (truth) nerve in me:
"And this largely stems from the fact that those consumers have no idea what open source software they’re even using to begin with."
I definitely don't think the (US) government is going to do anything for open source. [techradar]
DigitalOcean Introduces Cloud-Hosted Scalable Storage for Managed Databases
I've not personally used DigitalOcean for any hosting or server-related projects so I don't have first-hand experience with the platform. However, I know DigitalOcean is a popular service among all types of developers. Here is a quote directly from the source article:
“DigitalOcean’s portfolio is tailored to meet the needs of startups and tech entrepreneurs, enabling them with flexible and cost-effective solutions like Scalable Storage. With this new offering, businesses can easily accommodate dynamic database storage requirements and expand their data footprint with confidence, making it easier to grow in the cloud.”
[businesswire]
[#Affiliate]
Take your Laravel applications next level with Battle Ready Laravel by Ash Allen. Learn how to improve the performance, maintainability, and security of your Laravel projects in this e-book.
WooCommerce News and Updates
WooCommerce Blocks 11.2.0 Release Notes (September 29th, 2023)
The Legacy REST API will move to a dedicated extension in WooCommerce 9.0 (October 3rd, 2023)
[#Classifieds, Affiliates, 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.
I’m an avid photographer selling prints over on my Darkroom page. Help support me with a purchase today.
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).