OpenLampTech issue #112
Manage MySQL databases with PHP | MailerGlue | MySQL health checks | Drupal microsites | JavaScript support in MySQL.
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:
And now, a message from this week’s sponsor. Thank you, Backpack for sponsoring the OpenLampTech newsletter!
Backpack is one of the most popular admin panels for Laravel. Their simple stack and many many features make it a good choice for both devs who are now getting started and devs who plan to maintain a project for years to come - they've been doing this since 2016 and their track record speaks for itself.
If you're building a Laravel app, try Backpack, their free version is enough for most projects. Even better - if your project becomes complex, they have paid 1st party add-ons for the most common needs. Same vendor, all features you need.
OpenLampTech has sponsorship opportunities for your brand, product, or service in the weekly newsletter. As an independent publication, collaboration is very affordable.
Davor Minchorov shared a great developer interview in OpenLampTech this week.
Read it here:
How to create and manage MySQL databases with PHP
This article is a good introduction to the concept of working with databases using PHP. No ORM here. There are examples of setup configurations utilizing both mysqli
and PDO
. I've always leaned more towards PDO
in those vanilla applications in all my time using PHP. However, mysqli
is valid and offers many convenient methods and functions as well.
[Medium]
Keeping an Eye on MySQL with Health Checks
Database health and performance are crucial in online operations. Oftentimes, it is the database that is the problem. The most optimized and eloquent code doesn't mean a thing if the database isn't performant. Releem has taken MySQL database health and optimization to the next level with database tuning. Learn more about MySQL performance tuning expert and Releem founder Roman Agabekov in this OpenLampTech interview.
[Releem]
MailerGlue – An easy and cheap way to build and send emails in WordPress
I saw this on X and had to share it here. This is made by the same team that built Newsletter Glue. I've never used either one but from what I see and hear on the web, Newsletter Glue has a pretty good user base. As someone who runs an email newsletter on WordPress (I have a bass fishing site and newsletter), I always look for a better alternative. Currently, I'm using MailPoet (begrudgingly), but looking for other options.
[mailerglue.com]
This article is a case study of sorts exploring Drupal microsites. Three established options that are evaluated are:
Drupal standard multisite approach
Domain module approach
A custom solution
While I don't have any Drupal experience, these solutions all have their cons and I've even encountered similar issues and situations on the multiple client sites I have developed and maintained in my day job using vanilla PHP. The Drupal Context module is also explored for a final solution in this particular use case.
[Medium]
Lol. It's so funny (and silly) that people think PHP is dead or dying out. I have to wonder, have they looked at the web lately? Do they realize that a massive portion of the web is running (our world) in this programming language they so hate? At this point, most valid claims of PHP being a bad programming language are outdated anyway and PHP improves more and more with each new release. Let them hate I say.
[Medium]
Deciphering the Inner Workings of Transaction Processing in MySQL
Transaction Isolation is still one of those areas I need to study and learn more about. Yes, START TRANSACTION
, ROLLBACK
, and COMMIT
keywords and their matching ORM counterparts are easy enough to use. However, the inner workings and details are where the magic is IMO.
MySQL utilizes Multi-Version Concurrency Control (MVCC) for transaction isolation and the 4 levels are: Read Uncommitted, Read Committed, Repeatable Read, and Serializable.
[Medium]
MySQL Introduces Javascript Support in Preview
At the time of publication, this is only supported in MySQL Enterprise Edition and MySQL HeatWave. I won't even begin to wonder if this is a good idea or not. Chances are, unless you're using one of these premium versions of MySQL, you probably won't either. MySQL isn't the first database to integrate foreign programming language support in its stored procedures SQL programming. PostgreSQL and Oracle SQL(to my knowledge) support multiple programming languages within their stored function and procedure structure.
[InfoQ]
Thank you for reading. I hope you have a great rest of your week.
Take care.
Josh Otwell
When you are ready, here are more ways I can help...
Content, E-commerce Development, and Email/Newsletter Services - Photography services; Shopify and WooCommerce customizations, development, and setup; Email and Newsletter setup and management.
Interested? Great!
Just hit Reply and ask for more information about any of these services.
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.