OpenLamp.tech issue #6
Symfony Station; MySQL BETWEEN; Laravel CRUD; MySQL 8 Document Store; CodeIgniter File Attachments; WordPress Header Sent Error;
Hey glad to have you here! 👍
If someone shared this newsletter with you and you are not yet subscribed, please use the Subscribe button below and join:
Subscriber Note: I won’t be publishing an issue of OpenLamp.tech on Friday, December 24th in observance of the Christmas Eve/Christmas Day holiday. However, I will have an epic issue coming on December 31st that you do not want to miss.
I have curated some fantastic reads for you this week. Let’s get to them!
This Week’s Picks
✔️ MySQL 8.0 Document Store – How to deal with date & time
#mysql
I really should use the MySQL Document Store and X DevAPI more as this schema-less design offers additional flexibility over that found in relational design.
I've used MySQL Shell in Python mode quite a bit for exploratory learning and really like the option of switching to/from SQL when desired.
This post covers how to efficiently work with temporal data (date, time, datetime) in documents.
We go on to learn how to create indexes (using JS mode) on date columns for better performance and use simple CRUD to retrieve documents based on WHERE
clause date value filtering.
✔️ Use MySQL Window Functions to Get More out of Your Data
#mysql
SQL Window Functions are definitely one of those powerful features that don’t get enough love from us web developers, as we tend to be lost in the world of CRUD or REST most of the time (which are important). I read a meaty blog post from the Arctype newsletter that has plenty of detail about the powerful SQL analytic functions.
Take your time and dig into this one...
✔️ How to Fix the “Cannot Modify Header Information – Headers Already Sent By” Error
#wordpress #php
Indeed this specific error has bitten me many times as I've learned (and continue to learn) PHP development. I'm always debugging this one it seems like when redirecting to another route or page using the header()
function in a Controller method.
Although this particular error is not specific to only WordPress, the Kinsta team focuses on solutions in a WordPress environment in this blog post.
✔️ Laravel 8 CRUD Tutorial
#laravel #php
This CRUD tutorial covers provisioning a Homestead Vagrant box for your project. Then takes you step-by-step through creating the CRUD methods in Laravel.
While I'm not (yet) a Laravel developer, this tutorial is well-written with clear explanations and accompanying screenshots.
✔️ Enable File Attachment with CodeIgniter 4 form helper
#codeigniter #php
The CodeIgniter 4 PHP framework has many built-in helper libraries. One of them I use a great deal is the form helper. In this post, I cover using specific form helper library methods for file attachment uploads…
✔️ How Symfony Station was built: an adventurous exploration of layout solutions
#php #symfony #drupal
Behind-the-scenes stories are always the best. Authentic and upfront, they reveal all the details that standard coverage articles just don't provide.
Here is one such behind-the-scenes post that is flat-out interesting.
Covering the number of PHP-related technologies used together to create the Symfony Station site, the author discusses why certain technologies were used.
I find it very interesting how each of the many technologies was used for a specific task that makes up the overall whole.
✔️ Are MySQL BETWEEN Operator Queries Inclusive?
#mysql
A good while back while prototyping out a MySQL query using the BETWEEN
operator and filtering by a DATE
value on a DATETIME
datatype column, I noticed that some rows were missing from the query results. I knew these rows should be present and started exploring why. After all, isn't BETWEEN
inclusive?
Learn about my findings in this article I originally published on Medium.
I tell you for sure, nothing ever beats real-world experience in programming in my opinion.
Just for laughs…
Y’all know you debug your CodeIgniter as I do lol. 🤣🤣🤣
⭐⭐⭐ Many of the posts I curate and share in this newsletter, I read and enjoyed on Medium. If you are not yet and member and wish to join the platform, I would be more than grateful if you would use my sign-up link. At no extra cost to you, I will receive a small portion of your membership fee when you sign up. Thank you! 🙏
Extra stuff…
I'm listening to WordPress | Post Status Podcasts | Post Status Excerpt (No. 36) — Help Needed: WordPress Docs Team on Podbean, check it out! 👂
Did you enjoy this issue of OpenLamp.tech? Please share it with others so that they can enjoy the content as well. Thank you!!!
“Reply” or comment and let me know what you think of this issue of OpenLamp.tech.
What do you want to see more of?!?
What do you want to see less of?!?
I’d love to know!
Also, share with me links to your published blogs and articles so that I can read them and possibly include them here in the newsletter!
Thank you for reading. I hope you have a great rest of your week.
Take care.
Joshua Otwell
Visit my blog Digital Owl’s Prose, where I write regularly on CodeIgniter, PHP, and SQL. I’m also active on Medium, LinkedIn, Twitter, and Instagram.
How can I help you?
Are you thinking of starting up a blog? I use WordPress for my blog, Digital Owl’s Prose. Let’s both save money on the plans offered. 💸
Grab a Gmail HTML Email Signature template from my Etsy shop and make your emails pop and stand out. ✉️
Need hosting for your next web application or WordPress site? I use and highly recommend Hostinger. They have great pricing and service.
I enjoy reading Refind: The essence of the web, every morning in your inbox. Subscribe for free. Help me get a premium subscription by signing up yourself with my referral link.
Want to support this newsletter and my work? Drop some spare change in my Tip Jar.💰
Disclosure: Some of the services and products links in this email are affiliate links. At no additional cost to you, should you make a purchase by clicking through one of them, I will receive a commission.
Cover photo creds: Image by Pete Linforth from Pixabay