OpenLampTech issue #47
Laravel blog back-end; MySQL LOCKS; Linux command-line operators; MySQL Spatial types; Thank you for reading OpenLampTech!!!
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 in the OpenLampTech Publication
I’m starting to publish more reporting and news-related content on the LAMP stack ecosystems and shared this article earlier in the week on Tuesday:
OpenLampTech WordPress Wednesday #15 was jam-packed full of relevant WordPress-related links I curated this week:
[#Ad]
Every day Refind picks 7 links from around the web for you, tailored to your interests. Loved by 50k+ curious minds.
Linux | Apache | MySQL/MariaDB | PHP
I have curated some fantastic reads for you this week. Let’s get to them!
Creating the back-end of a Laravel 9 blog using MySQL database
By: Ranieri Valenca (discovered shared via PHP Weekly)
#php #laravel #mysql
It's no secret that a blog needs to store data in the database. MySQL is used in so many web applications where data CRUD is required.
In this article, learn step-by-step how to create a blog with Laravel 9.
From modeling the necessary entities into actual Laravel Models to creating migrations and relationships, the overall backend architecture is covered here.
MySQL Locks — for Update or Read?
By: .com software
#mysql
In order to effectively use either of the 2 locking types in MySQL (for InnoDB tables) - LOCK IN SHARE MODE
or FOR UPDATE
- your code must be within a TRANSACTION
.
LOCK IN SHARE MODE
- You can read the row while it is locked but prohibits other processing from editing the row.FOR UPDATE
- You cannot modify or read the row.
Fortunately, I've not faced too many instances where I've had to deal with locks. But I know it's always a possibility and this article is a great resource overview.
10 Linux Command-Line Operators and What They Do
By: DEBARSHI DAS
#linux
The Linux command-line is a powerful and tricky place. Many commands can save you tons of time and typing. But the real strength comes when you use command-specific operators.
Combining the appropriate ones, even more so.
Some most interesting ones to me covered here are:
The Ampersand (
&
) - is used to execute the command in the background.The semicolon (
;
) - chaining several different commands to run one after the other.Redirection operator (
>
) - This is just 1 of 3. Handy in redirecting a command's output to a file. (I use this one often when needed)
Give Me Some Latitude… and Longitude
By: Matthew Boehm
#mysql
MySQL integrated better spatial data types in v8.
With geospatial data types, you can store and manipulate location-based data.
In other words, coordinate data of some form.
You must use a Spatial Reference System (SRS) and accompanying Spatial Reference ID (SRID), in order for this type of data to be correctly 'located' in the world.
Learn more about the POINT
spatial data type, spatial indexes, and other useful information in this well-written piece from the Percona blog.
MySQL GUI Tools: The Ultimate Solution for All Your SQL and Database Work
By: Brady Cotton
#mysql
If you don't want to use the command line to manage or interact with your MySQL database, there are many Graphical User Interface (GUI) software - such as an Integrated Development Environment (IDE) - available.
Most of my experience is with both MySQL Workbench and phpMyAdmin.
This article shares highlights and information mainly about MySQL Workbench with notable mentions of a couple of other popular pieces in the SQL GUI space.
Writing to the Database with Eloquent
By: Steve McDougall
#php #laravel #sql
As explained in this article, you can make database writes in many different areas of your application.
Eloquent, Laravel's powerful ORM, provides several options for database writing and this article explores some of them with clear and concise examples.
There is plenty of knowledge here for beginners and veterans alike and I really enjoyed this read even though I'm not (yet) a Laravel developer.
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 all about it.
Get your job ad in the OpenLampTech newsletter for only 35$ USD/week.
Send me an email at openlamptech@substack.com if you are interested in a job ad placement.
Some devs are like:
“SQL isn’t hard.”
Interesting Tech News and Articles 📰
🔎 Cruise.co.uk Sets Sail with MariaDB SkySQL Cloud Database and SkyDBA
🔎 With $17M in funding, Immerok launches cloud service for real-time streaming data
📰 Get your brand, product, or service the attention it deserves with affordable classified ad placement in the OpenLampTech 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).
[#Affiliate]
I operate 2 niche WordPress websites and 1 CodeIgniter application, all proudly hosted on Hostinger. I couldn’t be happier with their product and support. Plus, they offer free SSLs.