Discover more from OpenLampTech
OpenLampTech No. 148
Drupal at your fingertips | Handling NULL in SQL | MariaDB ownership | Laravel funding | Gutenburg in Drupal and WordPress | WooCommerce 9.3 | CakePHP 5.1.0
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.
After a much-needed break last week, I am back with this week’s OpenLampTech newsletter. Thank you for reading and subscribing.
All commentary is by me unless otherwise quoted.
This is an exciting concept and one I would like to create (something similar) one day, perhaps around SQL.
There are numerous beginner-friendly resources but what about mid-level to advanced? According to the source article's content, Drupal at Your Fingertips is made for those developers who already have a working knowledge of Drupal but may be looking for more advanced topics and coverage.
[The Drop Times]
NULL
represents missing, undefined, or unknown values in SQL. Understanding NULL
is crucial because NULL
can affect query results and calculations in (often) unforeseen ways. Using both IS NULL
and IS NOT NULL
, especially when filtering in the WHERE
clause, along with all of the dedicated NULL
-handling functions are the best practices to handle NULL
in SQL.
[Medium]
Website security checks – WP-CLI for site owners and administrators
I don't (at this time) have many WordPress sites to manage but I am aware of WP-CLI and its potential.
In my mind, WP-CLI excels in maintaining multiple WordPress installations but is more than adequate for single-site tasks.
This article shares understandable examples of basic commands and how they are structured along with optional flag usage.
[WordPress Developer Blog]
🚀 Build Your Dream Shopify Store Without Time Constraints – For FREE! 🚀
Are you ready to launch your Shopify store but need more time to gather products, perfect your design, and get everything just right?
Are trial periods just not long enough for you? 💻
With a Shopify Partner's account, I can help!
Build your store with ZERO time limits – at no cost to you! 🎉
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 all about it to learn more and get started. FREE until you launch!
How YouTube Was Able to Support 2.49 Billion Users With MySQL
MySQL is a powerful RDBMS in its own right. However, sometimes even MySQL needs a little something extra (to get the job done more efficiently).
I really enjoyed reading this piece and learning more about the why and how of Vitess for YouTube.
Very interesting and well-structured content here.
[@System Design Newsletter]
What’s new for developers? (September 2024)
I'm torn most times on the direction of the juggernaut that is WordPress. Regardless of how I feel (one day blocks aren't so bad, another day I don't care for them at all), the project moves on.
Some highlights worth mentioning here:
Data Views components: updates around unregistering core actions associated with restoring, deleting, and trashing posts.
Register templates for plugins: A new API that allows developers an easy way to provide default front-end templates.
HTML tag processor has a new
set_modifiable_text()
function that performs proper HTML text escaping.
[WordPress Developer Blog]
Laravel raises a $57 million Series A from Accel
(Article from September 5th, 2024)
This is great for Laravel and the community. Especially since Laravel is as big in the open-source ecosystem as it is along with the PHP sphere.
This funding should definitely enhance Laravel as a framework overall as time goes on.
[Laravel News]
WooCommerce 9.3: Optimizations, accessibility improvements, and more (September 12th, 2024)
WooCommerce 9.3 brings several quality updates and enhancements. Here are a couple of the more interesting ones that grabbed my attention:
The database
woocommerce_coming_soon
field is now on by default and the meta key value for this setting is in theuser.woocommerce_meta
instead ofuser.meta
attribute.Accessibility improvements in the WooCommerce shortcode checkout.
aria-required="true”
also included when thewoocommerce_form_field()
function is used.
WooCommerce 9.3.2: Dot Release (September 18th, 2024)
[Woo Developer Blog]
What’s in the cards for MariaDB?
The last several months have been rocky for MariaDB.
K1 Investment Management is MariaDB's (new) owner and the (new) CEO has past experience in resale and acquisitions. At this point, I'm personally glad to see MariaDB in a solid place instead of the volatile trip it's been on lately.
[InfoWorld]
Comparing the Drupal and WordPress Implementations of Gutenberg themes, blocks, and more!
My buddy Reuben Walker of Symfony Station has one fantastic write-up here. I must (mostly) live under a rock when it comes to Gutenberg because I need reminding (thanks to content like this) that Gutenberg is open-source. Gutenberg can be (and is) used in other software besides WordPress. Drupal for one has Gutenberg availability through modules.
[Symfony Station]
Browsing the release notes, these enhancements and upgrades look pretty useful to me (I’ve not used CakePHP any but I think it is important to share with the community here in OpenLampTech):
These functions have been added:
toString
,toInt
,toBool
,toDate
, andtoDateTime
. They provide a typesafe way to cast request data (and other input) returningnull
when the conversion(s) fail.pathCombine()
help build paths and handle the issues of duplicates and trailing slashes.HtmlHelper
can create a meta tag containing a CSRF token.
[CakePHP Github]
[#Affiliates and Classifieds] - Your support keeps the OpenLampTech newsletter free for readers
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.
Subscribe to OpenLampTech
The LAMP stack and the PHP technologies and frameworks it runs. Code, content, and community for developers.