OpenLampTech No. 136
DrupalX | WP Transients API | Difference between localhost and 127.0.0.1 | ORM, Query Builder or Raw SQL? | WooCommerce 9.0 and MySQL Full-text index search
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:
And now, here is a message from this week’s sponsor. Thank you, Backpack for sponsoring the OpenLampTech newsletter!
Need an admin panel for your Laravel app? Backpack for Laravel is celebrating 8 years in the business with a HUGE discount campaign. Hurry up - there are limited spots with the 40% discount! If you haven't tried it yet, it's a great moment to do so. Use the coupon codes here while they're still active.
All commentary and opinions are mine unless otherwise quoted.
Jay Callicott Introduces DrupalX: Empowering Enterprise Website Development
If you're just getting started with Drupal development or have been working with the CMS already, you may want to give DrupalX a look.
DrupalX integrates with Bootstrap 5 for the front-end, in addition to Drupal modules such as Storybook.
More understanding can be had in this quote directly from the source,
“Overall, DrupalX provides a comprehensive and customizable foundation, making it easier for developers to create enterprise-level websites efficiently.”
[The Drop Times]
What is the difference between localhost and 127.0.0.1?
That's a good question and one that I can honestly say, “I have no idea”.
Until now.
Thanks to Joel Clermont over at Mastering Laravel.
While localhost and 127.0.0.1 are often thought of as the same thing (I surely did), they are not the same.
Learn about their differences in this quick tip.
[Mastering Laravel]
An introduction to the Transients API
I'm not at all familiar with the Transients API. Matter of fact, I didn't know such a thing existed for WordPress (although it seems quite useful to have it).
You can use the Transients API for a more performant WordPress site through either object or database caching.
Learn how and when you should use (if any) Transients on your WordPress website.
[WordPress Developer Blog]
OpenLampTech has sponsorship opportunities for your brand, product, or service in the weekly newsletter. As an independent publication, collaboration is very affordable.
Eloquent ORM, Query Builder, Raw SQL: When To Use Which?
Sometimes too many choices are a bad thing that can result in analysis paralysis.
However, I don't necessarily feel like that applies to database interaction options for your application. With Query Builders, ORMs, and plain SQL you can choose which fits best for the application (and user) needs.
Although the content in this particular piece focuses on Laravel (examples), this applies pretty much across the board for frameworks and development (that offer ORMs and Query Builders).
[Medium]
There is a lot to digest in this piece. Let's face it, maintaining a software/product of MySQL's magnitude is going to have its challenges (which I can’t even begin to imagine).
My thoughts on this piece are that there are other, more ‘open-source’ ways to steward MySQL.
Also, there is always PostgreSQL and MariaDB. Two great RDBMS products that are powerful and serve broad audiences as well.
[Percona]
WooCommerce 9.0: Our most accessible checkout and much more (June 18th, 2024)
One of the main things that caught my eye in this latest release is the (optional) experimental implementation of MySQL Full-text search indexes for order data.
Your WooCommerce store must be running HPOS to enable this feature.
Full-text searches should make more efficient database searches.
Note: a Developer Advisory was released the following day (June 19th) for other upgrade issues.
Update: Thursday, June 20th, 2024 WooCommerce 9.0.1: Dot Release addressed some of the issues (or most of them) from the previous release and developer advisory
[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.