OpenLampTech No. 159
Laravel custom query builders | Pagination deep dive | Drupal single component automation with Python | Are devs ditching MySQL/Postgres/Mongo | What writers/bloggers think of WordPress block editor
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, service, or job listing in the weekly newsletter. I am offering discounts on pricing for the holidays so grab yours now.
New! Job ad placements are now available in OpenLampTech - for cheap!
Book yours today.
As an independent publication, collaboration is very affordable.
All commentary, thoughts, and opinions are mine unless otherwise quoted.
Laravel Custom Query Builders Over Scopes
Here is a description of Laravel custom query builders quoted from the source article:
“…a custom query builder let's you move all your query abstractions into a dedicated class.”
I don't have a lot of development experience with Laravel but it seems like custom query builders would be ideal for specific, granular queries.
Maybe those that are not-so-common or not generally found across applications. I'm thinking along the lines of not your typical CRUD-type queries.
[dev.to]
Add Purchase Price to WooCommerce Products
This post details a handy code snippet you could use in the child theme's functions.php file that adds a custom field for the cost of goods.
WP Sites provides a great deal of free, usable content that helps WooCommerce shop owners customize their online stores.
Be sure and check out this site.
[WP Sites]
🚀 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!
Why Developers Are Ditching PostgreSQL, MySQL and MongoDB
Hmm… Ditching might be too stout of a word here.
I have no real-world experience with MongoDB and not much at all with PostgreSQL either.
But, MySQL, I am well versed in.
Many of the databases mentioned in this article are more niche than MySQL (or PostgreSQL for that matter). Especially since MySQL is the backbone and one of the key components of the LAMP stack.
All that said, GraphQL has my attention as I look to expand my development skills in Shopify.
[Medium]
Automating Single Directory Component Creation in Drupal with YAML Script
Although YAML files are foreign to me, I do use a good amount of Python in my current day job role. And that's what mainly caught my eye about this article.
Using Python to automate tedious or redundant tasks is one of my favorite things to learn and implement these days.
In this article, learn about how Python is used with YAML script automation and parsing in Drupal.
[The Drop Times]
[#Affiliate]
Do you need a domain for your next website or project? I use Namecheap for all of my domain needs. Please help support OpenLampTech by clicking through to the affiliate link for your next domain purchase! Thank you!
I take pagination for granted.
But, do you really, deeply know or understand how paging through query results works?
I sure didn't.
Luckily, SQL expert Markus Winand explains the 2 means of how query results are paginated through.
Multiple database vendors are covered here and the overall explanations for both the offset method and the seek method are top-notch.
Great stuff here everyone. A very insightful read.
[Use The Index, Luke!]
What Writers and Bloggers ACTUALLY Think of the WordPress Block Editor
I'm quite positive that if you dug through the OpenLampTech archives from a year ago, you would find that I didn't have much good to say about the WordPress block editor.
I'm still learning how to use it.
But, I am learning.
And using it over on my Louisiana Wandering online photography zine.
I have to say it's growing on me.
This article shares a general consensus on the WordPress block editor.
[Themeisle]
[#Affiliate]
I use Hostinger for all of my WordPress sites and other hosting needs. Help support OpenLampTech by clicking through to the affiliate link for all your web hosting needs! Thank you!
I wanted to share this tool with OpenLampTech readers in case anyone needs or is working with GraphQL in your PHP application.
Quoted from the GitHub page:
“Build GraphQL Queries and Mutations in a safe and easy way.”
[LinkedIn/GitHub]
Bridging the gap: Hybrid themes
Interesting bit of information here (of which I had no idea) quoted directly from the source article:
“While classic themes support the block editor, they do not support the Site Editor, which requires all parts of its templates to be block markup.”
This article covers a walk-through tutorial on working with WordPress hybrid themes.
[WordPress Developer Blog]
WordPress and WooCommerce News and Updates
WooCommerce 9.4.3 and WooCommerce 9.3.4 available now (December 3rd, 2024)
Event recap: “Let’s Talk Themes with Ellen Bauer” (December 4th, 2024)
Exciting News: Cost of Goods Sold Coming to WooCommerce Core! (December 4th, 2024)
Personal note: I am interested in any leads or introductions for remote PHP programming jobs. If you know of any, I would be forever grateful for any information or introductions.
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.
[#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)
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 automatic client maintenance reports.
Like newsletters? Here are some newsletters you may also enjoy. (affiliate)