OpenLampTech No. 151
Free Laravel API course | Suggestions for learning SQL | Drupal Open University | Dynamic method calling in PHP | Repair MySQL InnoDB tables
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:
OpenLampTech has sponsorship opportunities for your brand, product, or service in the weekly newsletter. As an independent publication, collaboration is very affordable.
All commentary, thoughts, and opinions are mine unless otherwise quoted.
A Selection of SQL Suggestions
This article covers several suggestions for learning SQL. Some seem geared more towards [Data] Analyst type roles which is fine too. Once you learn SQL, you can pair it up with other tools/languages/technologies (that's what I did; SQL+ PHP = Backend Web Dev)
I've published some resources in the past here in OpenLampTech that you should visit as well:
Learn about Ben Brumm from the Database Star website.
The book, SQL Antipatterns, by Bill Karwin is one of the best out there.
Check out these 5 SQL Books That Will Make You A Pro.
[Medium]
[#Affiliate]
Like newsletters? Here are some newsletters you may also enjoy.
Single Product Page Custom Fields for WooCommerce
I'm learning and understanding that WP Sites publishes some very useful WooCommerce-related content.
Custom fields are one of the backbone pieces needed for custom data in WordPress and WooCommerce.
Code samples are included in the article and you can use these to add additional and unique content fields to a (simple) product.
[WP Sites]
Drupal Open University: Growing Talent Through Open-Source Education
Open-source initiatives like this and all the WordPress drama lately have me scratching my head and wondering to myself why I am not learning Drupal development.
The source article describes what Drupal Open University is better than I can so I'm quoting it here:
“The Drupal University initiative is a community-driven project focused on integrating Drupal into academic environments. It aims to introduce students, educators, and professionals to the power of Drupal while promoting open-source principles.”
[The Drop Times]
🚀 Build your Shopify store with ZERO time limits – at no upfront cost to you! 🎉
I'm now offering onboarding through my Shopify Partner account for DIYers, self-starters, and those who want to set up their store without time constraints or trial periods.
📩 Hit Reply and ask me all about it to learn more and get started. FREE until you launch!
How to Repair InnoDB Table in MySQL – Step-by-Step Guide
I've never personally had to deal with a corrupt InnoDB table for any site or application I've built or worked on (knock on wood).
Some broad categories covered in this article that would be useful to know about in the case where you are working to fix a corrupt table:
Backup the database
Analyze the MySQL logs
Be sure there is plenty of space on the disc
Utilize the
CHECK TABLEcommand
[Tech Bullion]
This is a new concept to me, but it seems very useful in the correct context. Particularly when processing a large number of CSV files from various resources, as is the case with this article's content.
Dynamic method calling is described very well here as quoted from the source article:
“Dynamic method calls refer to calling a method on an object using a variable containing the method name.”
[Medium]
Why NoSQL Deployments Are Failing at Scale
Great quote from the article:
“If the schema isn’t realized within the database, it has to be instantiated in the query.”
I have no experience with NoSQL on any projects. While schemaless is enticing and appealing, SQL and schema design have been around and used for decades.
And, for good reason too - it works.
[The New Stack]
Steve McDougall from JustSteveKing has released a new, free Laravel API course.
The course includes a great introduction section with build and development environment setup suggestions and instructions.
Overall, this course is a solid option to help you learn or build on your Laravel API knowledge.
And, it's free.
Thanks, Steve for creating and sharing this resource with the community.
Despite best intentions, duplicate rows often end up in the database. At some point, this becomes a problem on several levels.
Leveraging Common Table Expressions (or CTEs) and the ROW_NUMBER() window function, you can remove those duplicates and this article shares examples for both MySQL and PostgreSQL.
SQL For Devs is an incredible resource and I highly recommend you to check out the regular content.
[SQL For Devs]
[#Affiliates and Classifieds] - Your support keeps the OpenLampTech newsletter free for readers
Ultimate Laravel Boilerplate to help other indie hackers deliver their SaaS in hours. Get started with LaraFast today! (affiliate)
Popups, newsletters, and abandoned carts. Use Omnisend with integrated email and SMS campaigns. (affiliate)
Thank you for reading. I hope you have a great rest of your week.
Take care.
Josh Otwell
Some links may be affiliate links from which I earn a small commission at no additional cost.