OpenLampTech issue #48
MySQL JSON data type; Race conditions in the database; Use a VIEW in Laravel queries; Thank you for reading the OpenLampTech developer newsletter!
Hey hey glad to have you here reading OpenLampTech! 👍
If someone shared this newsletter with you and you are not yet subscribed, please use the Subscribe button below and join:
Recently Published on the Digital Owl’s Prose Developer Blog
Window Functions operate on groups of rows, returning a value for every row in the group, unlike Aggregate Functions which collapse rows into a single value. With the many different Window Functions available, can you combine them at the same level? Learn more in this article.
Recently Published in the OpenLampTech Publication
I published the OpenLampTech WordPress Wednesday #16 for October 12th, 2022. There are many articles for us all to learn something from:
[#Ad]
Get smarter every day.
Every day Refind picks 7 links from around the web for you, tailored to your interests. Loved by 50k+ curious minds.
I read Refind every morning and I bet you will too.
Linux | Apache | MySQL/MariaDB | PHP
I have curated some fantastic reads for you this week. Let’s get to them!
Use a view instead of a complex Eloquent query in your Laravel application
By: Tray2 (discovered shared via PHP Weekly)
#php #laravel #sql
An SQL VIEW
is a named, stored query and is quite handy for those large, gnarly queries that you don't ever want to type again. 😉
Yet, it doesn't seem like many developers talk about VIEW
s much.
In this article, learn how to create and query an VIEW
in Laravel with Eloquent. For the most part, a VIEW
acts as a table.
However, VIEW
s have some caveats when it comes to inserting data so be mindful of that when working with them.
How to Send Emails with CodeIgniter
By: Sofia Tarhonska
#php #codeigniter
CodeIgniter comes with many libraries out of the box and the Email library is one of them.
With Mailtrap, which I've personally not used, you can test sending emails from dev environment setups.
In this article, we see a complete walkthrough of using the CodeIgniter email library to send and manage emails.
Similar: CodeIgniter Form Helper library – at a glance
Transactional Locking to Prevent Race Conditions
By: SQL For Devs
#mysql #sql
I've recently been trying to pay a lot of attention to the SQL For Devs site (and newsletter).
In my opinion, the author uses a SQL-first approach in design and thinking. Which I don't think a lot of devs do, honestly.
Learn about Race Conditions and how to manage them effectively with SQL.
This site and content are a nice breath of fresh air in the backend PHP and SQL dev space.
The MySQL JSON data type
By: Mike Stojan
#mysql
JSON or JavaScript Object Notation is everywhere on the web.
Especially, if you're consuming or creating Rest APIs, then you're working with JSON data.
MySQL supports JSON natively as a data type. This is great because using JSON affords you a more flexible schema.
By supporting these types, JSON is bound to cover just about whatever you wish to store:
strings
numbers
booleans
objects
arrays
null
A Quick Guide to Understanding Your phpMyAdmin Area
By: Bob Buckley
#php #mysql #wordpress
In pretty much any cPanel (or HPanel for my favorite hosting provider - Hostinger) you will find the phpMyAdmin web interface for database management.
I use phpMyAdmin a lot myself so knowing what is where is critical for success and effective use.
This article provides a quick overview of several key screens and areas such as:
SQL tab
Search tab
Export tab
Import tab (one of my favorites that see regular use)
Similar: Export MySQL data to CSV with phpMyAdmin
How to Use Datatables with PHP Server-Side Processing
By: Kenpachi Zaraki
#php #mysql
I know jQuery catches a lot of flack, but there is not a handier set of functionality than Datatables.
I've used jQuery Datatables to present tabular data on many web pages and I really like the fact that you get so much out of the box.
In this step-by-step article, learn how to send your MySQL query results to jQuery Datatables on the front end.
Thank you for reading OpenLampTech. This post is public so feel free to share it. Thanks!
Job Ad Placement
Have a job you need to fill? Tell the OpenLampTech 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.
Interesting Tech News and Articles 📰
🔎 Monetization is No Longer a Dirty Word in Open Source – But it Needs to Be Done Right
🔎 Open Source Communities: You May Not Be Interested in CISA, But CISA is Very Interested in You
🔎 Simform Achieves Amazon RDS Service Delivery Program (SDP) Partnership
🔎 What is a Linux Server Platform, and Why Might Your Business Want One
🔎 NocoDB takes on Airtable with open source no-code platform that connects to production databases
📰 Get your brand, product, or service the attention it deserves with affordable classified ad placement in the OpenLampTech newsletter.
[#Ad]
Insightful business news that respects your time and intelligence.
The Daily Upside is a business newsletter that covers the most important stories in business in a style that's engaging, insightful, and fun. Started by a former investment banker, The Daily Upside delivers quality insights and surfaces unique stories you won't read elsewhere.
Sign up here. Powered by Swapstack
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).
[#Affiliate]
I operate and host my niche bass fishing WordPress website on Hostinger and in my opinion, they are second to none. Plus, they offer free SSL.