OpenLampTech No. 134
WooCommerce database backups | Deskilling of web dev | wc-smooth-generator | Laravel Eloquent JoinWith package | Drupal API Client Initiative | Modern WP Development
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 and opinions are mine unless otherwise quoted.
How to back up your WooCommerce Database
The WooCommerce MySQL database stores all of the customers, orders, products, and other valuable data for an e-commerce store.
Keeping this data safe, accessible, and updated is a necessity.
Learn how to manually back up the WooCommerce database in addition to some tips using a more automated workflow via plugins.
[UpdraftPlus]
I'm in the middle of and enjoying Brian Coords’ Exploring Modern WordPress Development where he is sharing 7 useful tools over a period in his email list. I need to expand my WordPress skills and find these videos very informative.
MariaDB vs MySQL – Which is Better in 2024?
Both of these RDBMS are great options and are used in many applications. The more you use each of them, it's easy to see their similarities. On the other hand, they are not identical either and do have some differences.
Learn more in this article.
[Ultrahost]
I first discovered this article shared in my buddy Reuben Walker's fantastic Symfony Station newsletter, which you should be reading.
Although this piece isn't necessarily LAMP stack-focussed, it is (web) developer-focused and I can assure you if you're anything like me, this one hits a bit differently.
Read this article if you read nothing else in OpenLampTech this week.
[Baldur Bjarnason]
Eloquent JoinWith Package for Laravel
This Laravel package aims to improve query efficiency using a new joinWith() method on existing HasOne and BelongsTo model relationships. joinWith() will execute only 1 query instead of 2, therefore reducing the number of queries and round trips to the server.
[Laravel News]
How to Query WooCommerce Purchase Data using SQL in WordPress
There seems to be a WooCommerce or WordPress function for anything database-related. I've read that using these built-in functions in theme and plugin code is the preferred way.
It is nice to see raw SQL used (in the wild) like this.
Especially with Common Table Expressions (CTEs). MySQL v5.7 has reached EoL and CTEs are available in the new(er) version(s)
This article covers a relatively complex SQL query for customer data insights.
[Medium]
Releem is on Product Hunt - Ultra congratulations to Roman Agabekov for getting his database performance tool, Releem, on Product Hunt. Releem helps developers tune the MySQL application database, saving them time.
wc-smooth-generator is a neat little tool that can generate all kinds of WooCommerce test data (orders, customers, coupons, products, etc…) I first saw it in an issue of the Within WordPress newsletter.
The Drop Times newsletter shared information on a Drupal API Client initiative. This framework-agnostic build will be used to retrieve and cache data. It appears to be created with and uses JavaScript.
extract Get a Field from a Date or Time Value
Learn how to use extract for different database vendors to retrieve specific parts from temporal (date, datetime, timestamp) data types. Most major SQL implementations do support extract (some with limitations).
Do note the WHERE clause anti-pattern mentioned using extract of which I'm guilty of using myself.
[Modern SQL]
HPOS Full-text search for orders is available in experimental mode
WooCommerce 9.0 (scheduled for June 11th) will feature experimental MySQL Full-Text Search functionality. Moving in this direction makes sense since order data is now (or can be) segregated with the HPOS implementation into its own table(s).
[Woo Developer Blog]
[#Affiliates and Classifieds] - Your support keeps the OpenLampTech newsletter free for readers
Take your Laravel applications to the next level with Battle Ready Laravel by Ash Allen. (affiliate)
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)
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.