OpenLampTech issue #108
Flow PHP | SQL Window Functions | Why PHP? | Bunch of WooCommerce content. OpenLampTech is a media and content source for PHP, MySQL, and the LAMP stack.
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, a message from this week’s sponsor. Thank you, Depot for sponsoring the OpenLampTech newsletter!
Depot is a remote container build service hosting BuildKit as a service, the same build engine that backs Docker. We can build Docker images up to 20x faster, thanks to fast persistent caching on NVMe SSDs, 16 CPUs, 32GB of memory, and fast native CPUs for Intel and Arm.
If you’re tired of waiting for slow Docker image builds, check out depot.dev.
OpenLampTech has sponsorship opportunities for your brand, product, or service in the weekly newsletter. As an independent publication, collaboration is very affordable. Inquire by email at openlamptech@substack.com for more information on reaching the OpenLampTech readership. Sponsorships are available for early 2024.
Tanner Record shared a great developer interview with OpenLampTech. Don't miss this one.
Read it here:
WooCommerce: Create Order From Fluent Form Submission
Like I've said in past newsletters where I share content from the Business Bloomer website; this site is the de facto goldmine of WooCommerce knowledge/code snippets/customizations/etc. Here is another such great read showing how with some craftiness, WooCommerce hooks, and some code, you can accomplish almost anything with WooCommerce. [Business Bloomer]
Getting to Know Woo: Extensibility in the New Product Editor
I'm just not that keen (yet) on the whole Blocks ecosystem within WordPress and WooCommerce. I normally forgo using the default block-based theme for something I am more familiar with like Astra.
There is a block-based Product Editor for WooCommerce (in beta at the time of this publication). While reading this article, I discovered there is a PHP-based API that allows you to extend the Product Editor which is cool for PHP devs. Perhaps this workflow could be used as an alternative to something like Advanced Custom Fields (ACF). [Woo]
How I Made $70K Self-Publishing a Book About Database Performance
What a great read and story. Incredible achievement by the author. While I haven't gotten this book (yet), it seems to be a smashing success. Database knowledge is timeless and the more you can learn, the better. I'm hoping someday to have the author, Tobias Petry, share an OpenLampTech developer interview with the newsletter readers. [petry.me]
Flow PHP - strongly typed data processing framework
I recently saw this on Reddit and have bookmarked It here to share. In my day job, I have been looking for a data processing framework that stays close to what I know (PHP). I've not tested or delved into Flow PHP at the time of publication but it's now on my radar. If Flow PHP saves me from (attempting) to write something from scratch, I am very interested. [Reddit/Github]
Exploring SQL Window Functions: ROW_NUMBER, RANK, and DENSE_RANK
Window Functions are game-changers for complex SQL queries. I love them and look forward to any chance I get to use them. Window Functions such as ROW_NUMBER(),
RANK()
, and DENSE_RANK()
can be used in many crafty ways. Replicating any of these functions' functionality requires a lot of SQL code (I had to do this in MS Access once - pure nightmare). Just be aware that Window Functions weren't implemented until MySQL v8 if you are using that SQL dialect. [Medium]
Have you ever wondered this yourself? Or, do you want to share a good read with someone doubting and hating PHP? This is a good start. Yes, the PHP of the past was full of junk and garbage code practices (long before I started using it). However, these days, PHP is one of the front-runners of programming languages in terms of widespread use and ease of learning. Explore and learn more about ‘Why PHP?’ in this article. [dev.to]
WooCommerce News and Updates
The WooCommerce Legacy REST API extension is now available (December 1st, 2023)
Developer Office Hours: December Edition (December 1st, 2023)
WooCommerce Blocks Merging into the WooCommerce Monorepo (December 1st, 2023)
WooCommerce Blocks 11.7.0 Release Notes (December 5th, 2023)
What’s new with Woo: December 2023
[#Classifieds, #Affiliates, #Click Ads, #Shoutouts]
🤝 OpenLampTech earns a small commission (or payment/gain in some form) from many of these links. Your support helps keep the weekly 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.
- author is offering a pay-what-you-want, 12 Days of Content. A very accessible and value-packed deal.
Thank you for reading. I hope you have a great rest of your week.
Take care.
Josh Otwell
When you are ready, here are more ways I can help...
Content, E-commerce Development, and Email/Newsletter Services - Photography services; Shopify and WooCommerce customizations, development, and setup; Email and Newsletter setup and management.
Interested? Great!
Just hit Reply and ask for more information about any of these services.
OpenLampTech is a reader-supported publication. You can support the publication with a virtual coffee for as little as $3 (USD).
Thanks so much for the shout out Josh, much appreciated!