OpenLampTech issue #54
SQL wildcards | CSS in WordPress block themes | PHP magic methods | Linux app equivalents. Thank you for reading the OpenLampTech developer newsletter!
I’m so glad to have you here reading OpenLampTech! 👍
Thank you!!!
If someone awesome shared this newsletter with you and you are not yet subscribed, please use the Subscribe button below and join:
This email may contain affiliate links from which I earn a small commission on purchases you make using them at no extra cost to you.
[#Sponsored]
I’ve partnered up with Releem to bring you this issue of OpenLampTech.
Releem is a cloud service that helps developers tune MySQL servers to improve the performance of web apps and reduce the costs of server resources.
Using Releem you could monitor your current MySQL server performance and get recommendations to improve performance for Free.
It has a simple one-step installation, a clear dashboard, and applies recommended configuration just in one command.
To use Releem just sign up (https://go.releem.com/SQU3QF) and install Releem Agent on your server.
Not happy with the current MySQL Performance? Moving to a premium plan, you can access Releem's best configuration to improve MySQL Performance.
Using promo code “OpenLampTech” get a 40% discount on all Premium Plans only for OpenLampTech subscribers.
Thank you Releem for partnering with me in this OpenLampTech developer newsletter issue!
Use the promo code to get a great deal on a great product!
Recently Published on the Digital Owl’s Prose Developer Blog
Now that you have created a Reusable Block for your WordPress site, how do you make changes to it? Learn how in this article.
[#Ad]
If there is one newsletter I am reading every week, week in and week out, it is Growth Currency. If you are like me and wish to grow your own newsletter, Growth Currency is your currency.
Here is this week’s content.
Managing CSS Styles in a WordPress Block Theme
(css-tricks.com)
#wordpress
My thoughts: It's highly likely these days that if you are using block themes, your theme's CSS isn't stored in the (theme) required style.css
file anymore.
With Site Editing, there seems to be a preferred file to store a block theme's styling: the theme.json
file.
As a matter of fact, the Twenty Twenty-Three block theme has no styling in the style.css
file.
Times, are changing…
SQL Wildcards
(databasestar.com)
#sql #mysql
My thoughts: Many times you may not know the exact match or phrase for a WHERE
clause predicate.
Fortunately, in SQL we can use the LIKE
(or ILIKE
in certain implementations) operator and query for a partial match using either or both of the SQL wildcards: %
and _
.
% - represents zero or any number of characters
_
- represents a single character
Wildcard pattern matching is powerful but could cause performance hits for large tables.
WordPress Developer Blog
(developer.wordpress.org)
#wordpress
My thoughts: WordPress.org now has a beta version of a WordPress Developer Blog. This appears to be a nice effort to provide an online resource for developers to contribute their knowledge and for others to learn from. There are dedicated pages for developer docs, tips, themes, and how to contribute just to name a few.
As of the time of (this) publication, there are already a few quality blog articles available to read.
I'm looking forward to spending more time on the site in the near future.
Linux app equivalents for those interested in making the jump
(zdnet.com)
#linux
My thoughts: There is definitely a shift in the way you can work and with what applications you have available if you go 'all in' on Linux.
For the most part, you will be just fine with Linux alternatives. A few Linux alternatives take some getting used to while others feel like familiar companions.
Learn about many popular equivalent apps in the Linux ecosystem here.
Finding a new home for the WordPress community
(olliewp.com)
#wordpress
My thoughts: With the dumpster fire that Twitter has become, many are looking for an alternative place to gather online. Substack recently released chats which seem to be mini 'watering holes' for writers and their audiences on the platform (I've not tried Chats - my mobile provider isn't supported yet).
Imagine if your WordPress site could become its own mini Twitter and in turn, integrate with other similar sites. How cool would that be?
📰 Get your brand, product, or service the attention it deserves with affordable classified ad placement in the OpenLampTech newsletter.
PHP Magic Methods Explained
(medium.com)
#php
My thoughts: As PHP developers, we've all at the very least come across the __construct()
magic method (the constructor) and have more likely than not, typed it out ourselves.
What is a PHP Magic Method and which Magic Methods does the language support?
See clear explanations and learn more about the many PHP Magic Methods in this article.
Thank you for reading OpenLampTech. This post is public so feel free to share it.
[#Ad]
Get smarter every single day by reading Refind. I read Refind every morning and there is always something interesting in the emails because I tailor the content to what I want to read.
Interesting Tech News and Articles 📰
🔎 WooCommerce and Wordpress Go Passwordless with OwnID Free Plugin
🔎 SQLite 3.40 released with official support for Wasm – Web SQL reborn? (Released Nov 17th, 2022)
🔎 Yes, staging can be a pain — but here’s why you shouldn’t skip it
🔎 Google's Winning Business Intelligence Pieces: Looker and BigQuery SQL
🔎 WooCommerce and DePay Partner to Bring Web3 Payments to Online Merchants
🔎 Project vs Product - Plan and Delivery, Agile Characteristics
Job Ad Placement
Have a job you need to fill? Tell the OpenLampTech developer audience about it!
Get your job ad placement in the OpenLampTech newsletter for only 35$ USD/week.
Send me an email at openlamptech@substack.com if you are interested.
Thank you for reading. I hope you have a great rest of your week.
Take care.
Joshua Otwell
Visit my developer blog, Digital Owl’s Prose, where I write regularly on CodeIgniter, PHP, WordPress, and SQL.
OpenLampTech is a reader-supported publication. You can support the publication with a virtual coffee for as little as $3 (USD).