OpenLampTech No. 173
SQLite on the server | PHP goto | MariaDB GROUP BY error | WooCommerce Product Rest API | Laravel Auto CRUD package | Atomic CREATE/DROP SCHEMA in MySQL
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 is mine unless otherwise quoted.
MariaDB and the GROUP BY error
This type of error is one of those SQL errors that will bite you.
This article has good pointers and explanations, and it's one of the better ones I've read on the topic.
I have often forgotten how MySQL will suppress this error for certain versions.
Quote from the source article:
“As the error says, when a GROUP BY clause is present, you can’t select any column. You can only select columns that are:
Mentioned in the GROUP BY clause;
passed to aggregate functions”
[Vettabase]
I'm one of the newer PHP developers who doesn't know anything about goto. Nor have I seen it in the wild that I can recall, much less used it.
Seems like goto could be confusing.
Quote from the source article:
“Newer PHP developers probably don't even know that it exists and those who do often try to pretend that it doesn't.”
[Ryan Chandler]
Making CREATE/DROP SCHEMA Truly Atomic in MySQL
Data integrity is of utmost importance and most databases utilize ACID. In particular, the Atomicity component of ACID.
Quote from the source article:
“While DDL operations for InnoDB tables have long been atomic and crash-safe, we recognized that DDL operations for schemas lacked the same level of robustness.”
[The Oracle MySQL Blog]
This looks like an interesting package that you can use in Laravel to create all the necessary CRUD files with a single command.
Some of the options I noted are:
Use for a specific Model
Create for a certain type of application (API, etc)
Generated files have code and (some) logic
[Laravel News]
Extending WooCommerce Product REST API Responses
In addition to Business Bloomer and WP Sites, this website is another great source for WooCommerce developers.
Learn more about utilizing responses from the WooCommerce Product Rest API with these areas of focus:
Add Custom Fields to Product Schema
Modify Product Response Data
Prepare Product Data for Insert
SQLite-on-the-Server Is Misunderstood: Better At Hyper-Scale Than Micro-Scale
Like I always say, SQLite is the little engine that could.
I was first exposed to SQLite in Android development around 2015.
Personally, I find SQLite to be the most useful in prototyping, but it seems there is more than meets the eye for this file database.
Partial quote from the source article:
“… SQLite's strengths really shine at scale, instead of with small hobbyist deployments that it's frequently referenced in.”
[Rivet]
WooCommerce and WordPress news and updates
Keep your server safe with Approved Download Directories (March 11th, 2025)
WooCommerce Blocks client files relocated to complete monorepo merge (March 11th, 2025)
A little something extra, Timeless Classic: Belair In Black-and-white.
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.