OpenLampTech issue #118
Why PHP is still relevant in 2024 | Drupal vs WordPress | WooCommerce dev business numbers | MySQL vs PostgreSQL
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.
Bosun Egberinde shared a fantastic developer interview in OpenLampTech this week.
Read it here:
All commentary is mine unless otherwise quoted.
Breaking Down DENSE_RANK(): A Step-by-Step Guide for SQL Enthusiasts
Window functions are some of the most powerful in SQL. Differing from the standard aggregate functions, window functions operate on a group of rows based on the current row within a result set. This group can vary depending on many factors. In some instances, you may want to provide a sort of ranking amongst groups of rows. DENSE_RANK()
is one such option with RANK()
and ROW_NUMBER()
being others.
Should there be any ties in the ranking, the tied rows will receive the same ranking (e.g., two 3rd places). However, DENSE_RANK()
continues with the next available number in the ranking (e.g., 1,2,3,3,4).
[KD Nuggets]
Lessons Learned After 37% Drop in WooCommerce Dev Business
I've shared several pieces of content from WooCommerce expert Rodolfo Melogli over on the Business Bloomer website. Business Bloomer is one of the de facto sources of WooCommerce coding and knowledge bases in my opinion. This article has an insightful interview that Rodolfo participated in for The WP Minute.
This sentence quoted directly from the source has me wondering about (and tinkering with) platforms like Shopify:
“I think that WooCommerce is losing a bit of market share and it is exactly because it’s too delicate; a single line of code can break a full website.”
[The WP Minute]
Drupal vs. WordPress: Differences, pros and cons in 2024
These 2 juggernauts are mainstays in the open-source CMS ecosystem. Each servicing a different user and client. While WordPress may be the most popular, Drupal is there also, managing large knowledge base sites with ease.
In this article there are some comparisons with WordPress(.)com however, I feel that the more fair comparison would be with WordPress(.)org.
Also, I feel like there is a division going on in WordPress with the traditional vs block-based design/programming/user base. I'm not 100% sure if Drupal is experiencing something similar or not.
[USA Today]
How do Log in and Registration work for developers?
WordPress has built-in scripts and dedicated functions for the complete login and registration lifecycle. However, developers can implement their validation steps with in-built authentication filters.
This article from the WordPress Developer Blog has information covering the basic WordPress login and registration lifecycle with code samples and hook details.
[WordPress Developer Blog]
Why PHP is Still Relevant in 2024
For the time being, I'll give you my answer: WordPress. Is that not good enough for you? How about Laravel?
Symfony?
PHP will stay relevant for years to come since a massive portion of the internet is built on and with PHP. Each release brings more features and enhancements. Frameworks galore are using PHP.
Learn PHP.
[Medium]
MySQL vs PostgreSQL: Choosing the Right Database for Your Needs
I've used both MySQL and PostgreSQL and although both are relational databases, they are vastly different. While I have magnitudes more experience with MySQL, PostgreSQL is without a doubt the one to choose if you need robust Spatial capabilities. Through the PostGIS extension, PostgreSQL geospatial functionalities far outshine those found in MySQL. However, MySQL is part of the LAMP stack and is a mainstay in modern web application development. In my experience, MySQL seems to have a lot of availability by default in most hosting provider's offerings.
[Medium]
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).
[#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.
The online DNS course for developers. Learn more at Nslookup.
AI-powered SQL generator and data analytics tool. Learn more at SQLAI.ai - AI, SQL & DATA.