OpenLampTech issue #59
Effective Eloquent | WordPress and phpMyAdmin | Choose CodeIgniter | MySQL Document Store. Thank you for reading the OpenLampTech developer newsletter!
I’m so grateful you are 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:
Newsletter and YouTube Channel Shout-out
“Practical, easy to follow tech tips, directly to your email inbox!”
If there is one newsletter you should be reading, it’s Rick’s Tech Tips Newsletter. I read it every day and always enjoy the useful tips and information Rick shares.
Rick now has a complimentary YouTube channel for short, but awesome tech tips. You’ll want to be sure and subscribe to it as well.
OpenLampTech has top-level sponsorship opportunities in the weekly newsletter for your brand, product, or service. As a starter publication, collaboration is very budget-friendly. Inquire by email at openlamptech@substack.com for more information.
Below is the content I am sharing I enjoyed this week:
Effective Eloquent
#laravel #php #database
My thoughts: Eloquent is the Object Relational Mapper (ORM) for the Laravel PHP framework. An ORM allows the developer to abstract away the SQL into related objects. However, if more robust SQL abilities are needed, they are available.
Eloquent has a method for everything under the sun you could need for working with SQL. If not, you can use its Query Builder.
Learn about best practices for methods and calls to save application memory where available.
➡️ Read more…
WordPress and phpMyAdmin
#wordpress #php #database
My thoughts: Where would websites, WordPress, and hosting, in general, be without phpMyAdmin? Likely lost and in the dark is where.
Take advantage of these pointers from the post.
phpMyAdmin…
Supports both MySQL and MariaDB
Is a web application
In a WordPress context, uses MySQL user accounts and not WordPress accounts
Requires both PHP and MySQL/MariaDB in order to work
There are more WordPress-specific pieces of information throughout the article as well.
➡️ Read more…
MySQL 8.0 Document Store – How to deal with date & time
#mysql #database
My thoughts: MySQL v8 was a landmark release for the world's most popular open-source database. Among the many new features is the Document Store, allowing MySQL to store and manipulate data as JSON records through the X DevAPI.
Working with any temporal data presents its own challenges. However, the MySQL Document Store can query and work with date, time, and timestamp values using CRUD methods. Most SQL functions can be used in conjunction with the X DevAPI methods however many are not available. But we learn of a workaround using some indexing and virtual columns.
➡️ Read more…
The Significance of Choosing CodeIgniter for Web Development
#php #codeigniter
My thoughts: Ever heard the saying, "Preaching to the choir"?
CodeIgniter rocks! And it's fast too!
I really like CodeIgniter 4 overall. But, working with the Models and Query Builder may be my favorite pieces of the framework.
Here are just a few great features of CodeIgniter:
Supports MVC design architecture but also the freedom not to use MVC if desired
Can create custom core libraries
Lightweight footprint
Data encryption
Security features - CSRF protection, XSS filtering, etc
Although CodeIgniter 4 might not be the most popular regarding numbers-wise in use, it still makes up for a significant percentage of use in PHP web framework development.
➡️ Read more…
Just Use Postgres for Everything
#sql #database #postgresql
My thoughts: PostgreSQL is powerful.
I've kinda fallen out of the loop with PostgreSQL. It is actually the first database I really dug into (at the time) and wrote about my (limited) understanding extensively early in my blog's infancy.
This article suggests using PostgreSQL in place of other pieces of software. Many I never would have thought about or thought were even possible.
To name but a few as suggested:
Unlogged tables instead of Redis
Kafka is replaced with
SKIP LOCKED
Fulltext Search fulfills Elastic needs.
Did I mention PostgreSQL is powerful?
➡️ Read more…
You have to know this, SQL-injections are crazy! (Explanation + examples)
#sql #database
My thoughts: Thank goodness for prepared statements and/or ORM methods that help mitigate the risk of SQL injection or I'd be doomed for sure as a developer.
In this article, we see an example and learn about the OR
payload.
A lot of its success boils down to when an OR
operator is involved, only 1 of the conditional tests needs to be TRUE
.
We also learn about the Comment payload in which you can use 2 dashes (--) - which is an SQL code comment - to comment or block out part of a query string.
Plenty to learn in this article with good content.
➡️ Read more…
📰 Get your brand, product, or service the attention it deserves with affordable classified ad placement in the OpenLampTech newsletter.
Interesting Tech News and Articles 📰
🔎 Newsletter writers need a new ethics
🔎 OpnForm is an Open-source Form Builder Made With Laravel
🔎 Presto: A Data Analytics Ecosystem Built on an Open All-SQL Platform
🔎 One day we'll have a fully customisable select
🔎 Stack Overflow: Linux Surpasses macOS Among Developers
🔎 How to use ‘Picture-in-Picture’ on a Mac (Good article discovered in the fantastic
)🔎 MariaDB’s a new generation cloud database company providing products to big and small businesses
🔎How my newsletter went from "aimless hobby" to a media business
[#Classifieds and Click Ads]
🤝 OpenLampTech earns a small commission (or payment in some form) from many of these links. Your support helps keep the weekly OpenLampTech newsletter free for readers.🙏
Subscribe to The Uncommon Solopreneur and learn how soloprenuers grow their businesses without working themselves into the ground.
Get smarter every single day by reading Refind. I read Refind every morning because Refind tailors the content to my interests.
The Selfish Forever newsletter is a must-read if you're even remotely (pun intended) interested in making your own way in this world. The copywriting alone is going to blow your socks off. 🧦
Never miss the most important e-commerce industry news. Free delivery to your Inbox every Monday. Subscribe to the Shopifreaks E-Commerce Newsletter.
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).