OpenLampTech No. 167
Drupal CMS 1.0 | Page builder naming conventions | A dbt alternative | WP-CLI prod to local | MySQL 9.2
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.
As an independent publication, collaboration is very affordable.
All commentary, thoughts, and opinions are mine unless otherwise quoted.
Why SQLMesh Might be The Best dbt Alternative
The only SQL-type tools I have experience with are MySQL Workbench and Oracle SQL Developer. So dbt and SQLMesh are both new to me.
Based on my understanding, dbt and SQLMesh work best on the Transform part of ETL/ELT.
Until recently, I hadn't done much ETL/ELT type of work. But someone who works in that type of role might find good use out of these tools.
[The Data Toolbox]
Trying out the brand new Drupal CMS 1.0
I should do myself a solid and become more familiar with Drupal as a whole. I just have never used it or explored it in any detail. Drupal CMS is a very enticing option.
Quote from the source article:
“So Drupal Core is for developers who know exactly what and how they want to do stuff and Drupal CMS is for the rest.”
🚀 Shopify Store Setups and Onboarding! 🚀
As a developer experienced with WordPress and other web technologies, I'm now expanding my skills by offering Shopify store setups through my Partner account.
I'm gaining hands-on experience with Shopify and that means (for you):
✓ Competitive pricing
✓ Enthusiastic learning mindset
✓ Commitment to your project's success
✓ Honest communication about my current skill level
📩 Hit Reply and ask me about it to learn more and get started.
A Call for Better Naming Conventions in Page Builders
I get by with the page builder I use (Spectre) for my Louisiana Wandering photography site. But I'm far from an expert with it or page builders in general.
Quote from the source article:
“Page builder developers have been pretty bad at naming things for the last decade. It makes for a frustrating experience for advanced users and a much steeper learning curve for beginners.”
[Kevin Geary]
MySQL 9.2 Released, Adds JavaScript Transactional API
This release has a lot of enhancements and features related to JavaScript. I'm not the biggest fan nor that experienced with the language (jQuery some), but I do realize its importance in web development.
One of the more interesting updates that caught my attention (as someone who works with GIS data) is the CREATE_SPATIAL_REFERENCE_SYSTEM privilege. This privilege allows users to CREATE, REPLACE, or DROP spatial reference systems.
[linuxiac]
Pull WordPress from Prod to Local with WP-CLI Bash Script
Are you looking for a workflow between your production WordPress site and a local version?
This article shares great ideas for that and more.
An example (base) starter script code is included in the content.
Command-line skills and Bash scripting are powerful. I use both quite often.
[Brian Coords]
WordPress and WooCommerce News and Updates
Product Gallery (beta) block: Roadmap update (January 24th, 2025)
Demo your Woo extension with WordPress Playground (January 24th, 2025)
Stay connected with WooCommerce developer updates (January 30th, 2025)
Shopify News and Updates
Updates to the app review process: additional preliminary steps for a faster review (January 29th, 2025)
I'm looking for on-the-side freelance work (8-10 hours/month) on those projects that are most meaningful to me. If you need a hand with backend PHP programming, SQL, WordPress, or Shopify store setups, email me at openlamptech@substack.com, and let’s see if we are a good fit.
Thank you for reading OpenLampTech. 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.