OpenLampTech issue #123
DataBase OS | Register WordPress block variations with PHP | CakePHP SPAs | New WooCommerce payment providers | SQL self joins | Who is WordPress for?
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 is mine unless otherwise quoted.
'What if the operating system is the problem': Linux was never created for the cloud…
PostgreSQL creator, Apache Spark co-founder, and others have created DBOS or DataBase OS.
Here are some of the details quoted directly from the source article:
“DBOS operates by coding operating system services in SQL on a high-performance distributed, transactional, fault-tolerant database management system (DBMS).”
[Tech Radar]
Fortis and WooCommerce Partner to Expand Capabilities in the $1T B2B Market
Woo is adding another B2B payment provider with Fortis.
More information behind the “Why” quoted directly from the source article:
“In these markets, the seller and buyer dynamics are very different than the B2C experience. This partnership will deliver core payments capabilities specifically designed to support these highly valued customers and solidifies.”
[PR Newswire]
MySQL InnoDB’s Instant Schema Changes: What DBAs Should Know
With MySQL v8.0.29, you can add a column anywhere within a table's schema without blocking it during the definition change. This comes with some caveats though. INSTANT
(the algorithm) DDLs or Data Definition Language like this have a maximum of 64 uses and then the table must be rebuilt instead of just applying the definition changed to the data dictionary metadata. It is likely a good practice to specify the algorithm for these ALTER TABLE
commands.
[Oracle MySQL Blog]
How to register block variations with PHP
WordPress 6.5 will come with a PHP filter hook you can use to register custom block variations.
I'm happy to know that WordPress (core) has remembered us PHP devs who may not be so comfortable with JavaScript (raises hand). There are syntax examples and more about the get_block_type_variations()
filter hook in this article.
[WordPress Developer Blog]
Good question. I have no idea (anymore). With all of the page builders, the block editor, and powerful plugins like ACF, WordPress can be anything. A CMS? An application framework? A mix of the 2 (and more)?
I think the more important question is whether it is a good or bad thing.
[The WP Minute]
When Do You Self Join? A Handy Trick
Sometimes an INNER JOIN
or one of the OUTER
joins (LEFT
, RIGHT
, etc) won't retrieve the particular data you need. Here is where Self Joins comes in. For larger-size database tables, you may even consider some Window Functions, which can often be more performant. I've had to use Self Joins a lot when working with MS Access. Just be aware there are no Self Join keywords or syntax. Self Join is more of an action or how-to JOIN
a table to itself.
[Medium]
Build a Single Page Application Using CakePHP and InertiaJS
Here is a solid step-by-step tutorial on creating a Single Page Application (SPA) in CakePHP. Docker and Composer commands structure the project and take care of the dependencies, including the inertia plugin. Vue for the front end.
I don't have a lot of experience with CakePHP but I'm sure it has its place and following like the rest of the many - and varied - PHP frameworks.
[CakeDC]
What are Slow Queries in MySQL?
There is a slow_query_log
where non-performant query information is logged.
This quote directly from the source article explains why the slow_query_log
is important:
“By examining the data recorded in the slow_query log, you can uncover patterns and trends in query performance, pinpointing repetitive queries that may be contributing to overall system slowdowns.”
Learn more about Releem founder and MySQL tuning expert Roman Agabekov, in this OpenLampTech developer interview.
[Releem]
[#Affiliates] - Your support keeps the OpenLampTech newsletter free for readers
Take your Laravel applications to the next level with Battle Ready Laravel by Ash Allen. Learn how to improve the performance, maintainability, and security of your Laravel projects in this e-book.
Ultimate Laravel Boilerplate to help other indie hackers deliver their SaaS in hours. Get started with LaraFast today!
Thank you for reading. I hope you have a great rest of your week.
Take care.
Josh Otwell
OpenLampTech is a reader-supported publication. You can support the publication with a virtual coffee for as little as $3 (USD).