OpenLampTech No. 154
PHP Service Template | SQL tips and tricks | Massive WordPress cheat sheets | Database migrations | Frameworks for small tasks
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, thoughts, and opinions are mine unless otherwise quoted.
I saw this shared on Reddit and wanted to include it in this week's newsletter.
I've been using a (similar) roll-your-own, non-PHP microservices for a project in my day job, and PHP Service Template caught my eye.
The PHP Service Template's foundation is API Platform 3, PHP 8, and Symfony 7, providing a modern development stack.
Seems very interesting and useful.
[Github]
170+ WordPress Cheat Sheets for Web Developers and Designers
Bookmark alert!
This resource has a massive list of links to pages for things you can use daily.
The cheat sheets are further broken out into subcategories.
I'm most interested in the RestAPI, PHP, and MySQL sections, but I'm sure there is something here for most [web] developers.
[WP Shout]
How to Use ACF Blocks to Customize the WordPress Experience
Advanced Custom Fields are foundational for building (many) customized WordPress sites. Extending the block editor or creating new custom blocks may require some React knowledge and may not be for everyone.
This is where ACF can come in.
Just know the free version of ACF does not support ACF Blocks.
[The WP Minute]
[Affiliate]
Manage all your WordPress websites from one place and automate most of the necessary maintenance tasks with Modular DS. Centralized updates, cloud backups, uptime monitoring, vulnerability checks, and even automatic client maintenance reports.
What is the best framework for a super small task?
I've used CodeIgniter 4 for a couple of small projects and/or tasks in the past, with great results.
While part one of this series lays out an example of a small one-off task using Laravel, the downsides are quickly realized.
Part 2 provides an example with vanilla PHP and while lightweight, maintainability and readability can quickly become a concern.
In reality, there isn't a one-size-fits-all type of solution but frameworks do provide many solid features right out of the box.
[Mastering Laravel]
Not all databases run migrations the same
More great information here from Joel Clermont of Mastering Laravel on database TRANSACTIONs.
I knew that MySQL would automatically commit Data Definition Language (DDL) commands within a TRANSACTION. However, I was unaware that SQLite, SQL Server, and PostgreSQL allowed them without fully committing the DDL.
As always, great stuff from this resource.
[Mastering Laravel]
This repo is best described, quoted here from the source article:
“A (somewhat opinionated) list of SQL tips and tricks…”
The more I use SQL in capacities other than web development, the more I add to my own tips and tricks sheet.
This is a fantastic page with many handy tips that I am bookmarking and hopefully, you find some of them useful as well.
I’ve still not (yet) embraced the ‘leading comma’ in the SELECT clause list practice. But, there are several tips and tricks like that here.
[Github]
🚀 Build your Shopify store with ZERO time limits – at no upfront cost! 🎉
I'm now offering onboarding through my Shopify Partner account for DIYers, self-starters, and those who want to set up their store without time constraints or trial periods.
📩 Hit Reply and ask me about it to learn more and get started. FREE until you launch!
WooCommerce news and updates
More options coming to the express checkout (October 28th, 2024)
WooCommerce Releases Update (October 28th, 2024)
[#Affiliates and Classifieds] - Your support keeps the OpenLampTech newsletter free for readers
Take your Laravel applications to the next level with Battle Ready Laravel. (affiliate)
Popups, newsletters, and abandoned carts. Use Omnisend with integrated email and SMS campaigns. (affiliate)
Like newsletters? Here are some newsletters you may also enjoy. (affiliate)
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.