OpenLampTech issue #57
Best MySQL blogs | WordPress backup file woes | Eloquent API calls | JSON-Based SQLi attacks. Thank you for reading the OpenLampTech developer newsletter!
I’m so grateful you are here reading OpenLampTech! 👍
Thank you!!!
If someone awesome 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
The OpenLampTech publication was busy this week, publishing 2 fantastic pieces. One is a high-level overview with curated resources on a new(er) JSON-Based SQL Injection vulnerability and the other is an epic developer interview.
You don’t want to miss either of them!
📰 Get your brand, product, or service the attention it deserves with affordable classified ad placement in the OpenLampTech newsletter.
Below is the content I am sharing I enjoyed this week:
16 reasons DDEV will be your new favorite development environment
#php #web #development
My thoughts: For local development, I currently use XAMPP at work and MAMP, Local, and occasionally DevKinsta for any personal/side-gig projects. I've just never (for whatever reason) gotten into containers or container-based development.
Here are a few reasons (among many) DDEV might be for you (and me):
Cross-platform
Database snapshots
Installation without dependencies
Popular CMS support
➡️ Read more…
Percentage calculations using SQL Window Functions
#sql
My thoughts: Calling all developers! Don't sleep on Window Functions!
They are quite powerful and provide a simpler means for often complex query requirements.
As demonstrated in the article, one use (among many) for Window Functions is you can apply specific calculations on the data without querying the same table twice - often increasing performance - by avoiding clunky self JOIN
s and correlated subqueries.
I try to use Window Functions every chance I can under the right circumstances simply because they are so powerful.
➡️ Read more…
20 Best MySQL Blogs and Websites
#mysql
My thoughts: I can only hope that one day my Digital Owl’s Prose developer blog makes it on a list like this. Until then, I've got some great inspiration (and motivation) to work towards.
There are some 'heavy hitters' here providing top-notch expert content from the blogs I'm most familiar with.
Just to name a few:
Planet MySQL Blog
Severalnines | Open Source Database Blog & News
Percona Database Performance Blog
➡️ Read more…
Eloquent API Calls
#php #laravel
My thoughts: I know I absolutely should be further along in my knowledge of using an API in PHP. APIs are pretty much table stakes for web developers in particular as there are times your application must integrate with 3rd party libraries/apps/services.
In this article, the author takes us through an example of developing and working with the GitHub API using Laravel and accompanying framework features. One (of many) points I like about this article is the author going through how the code is structured within the application, and why.
➡️ Read more…
JSON-based SQL injection attacks trigger need to update web application firewalls
#sql #json #web
My thoughts: JSON, SQL, and SQL JSON support have all been around long enough as standalone technologies. Most SQL databases support JSON as a datatype itself and have a dedicated suite of JSON functions.
However, here as of late, there is a nefarious side to this JSON SQL support in the form of JSON-Based SQL injection attacks.
I am planning to keep up with this topic going forward.
Related: Read this curated resource article from the OpenLampTech publication.
➡️ Read more…
Job Ad Placement
Have a job you need to fill? Tell the OpenLampTech developer audience about it!
Get your job ad placement in the OpenLampTech newsletter for only 35$ $20 USD/week.
Send me an email at openlamptech@substack.com if you are interested.
How To Create WordPress Custom Post Type
#wordpress #php
My thoughts: Based on my own personal limited development experience with WordPress, it seems that it (development) would be challenging - at best - and quite bland without Custom Post Types (CPT).
It's always a plus to have a simplified means for development with plugins such as Advanced Custom Fields, PODS, and CPT UI, but I am more interested in learning about the PHP code involved in creating a CPT.
You can learn just that - and more - in this great article.
➡️ Read more…
Configuration Probing: Your Backups Might Be Your Greatest Weakness
#php #wordpress #web
My thoughts: Everyone who works with backups and backup files - in particular configuration files - should read this article. I'm guilty of this bad practice myself as I'm sure many are.
We learn as we go and I'm for sure learning as I go.
The long of the short of it is - don't change or add extension names to backup copies of files and leave them in the web directory. There are (still) means that nefarious actors can access the data in these files.
➡️ Read more…
Interesting Tech News and Articles 📰
🔎 The Main Factors That Differentiate Between WooCommerce and Shopify
🔎 Specbee: 7 Drupal Security Strategies you need to implement right away!...
🔎 How To Bulk Upload Files to WordPress Media Library via FTP
🔎 Cassandra 4.1 promises dev guardrails and pluggable storage
🔎 Yugabyte Announces Release of YugabyteDB 2.17 and Major Enhancements to YugabyteDB Managed (Dec, 8th 2022)
🔎 The Tandy Zoomer -- The x86 PDA before the Palm Pilot (Great piece by
of )🔎 ChatGPT Creates a Working WordPress Plugin – On the First Try
🔎 Musk 'Open to the Idea' of Purchasing Substack
🔎 SingleStore Announces Key Innovations for World’s Only Unified Database Built for Real Time
Check out and support any of these services if they fit any of your needs:
http://www.frozenarcticservices.com
[#Classifieds and Click Ads]
🤝 OpenLampTech earns a small commission (in some form) from many of these links. Your support helps keep the weekly OpenLampTech newsletter free for readers.🙏
Subscribe to The Uncommon Solopreneur and learn how solopreneurs grow their businesses without working themselves into the ground.
Get smarter every single day by reading Refind. I read Refind every morning because Refind tailors the content to my interests.
Bond is a members club where you can meet established newsletter creators in your niche who are looking to partner up and help each other grow with free cross-promotions.
Find your next favorite newsletter in the Sample. Start reading more great newsletters today.
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).