OpenLampTech issue #63
WordPress robots.txt file | Large tables in MySQL | Prevent SQL injections | 10 books for PHP devs. Thank you for reading the OpenLampTech developer newsletter!
I’m so grateful you are here reading OpenLampTech! 👍
If someone awesome shared this newsletter with you and you are not yet subscribed, please use the Subscribe button below and join:
Receive a free copy of my eBook, “10 MySQL Tips For Everyone” when you subscribe to the weekly OpenLampTech newsletter!
OpenLampTech has sponsorship opportunities in the weekly newsletter for your brand, product, or service. As a starter publication, collaboration is very budget-friendly. Inquire by email at firstname.lastname@example.org for more information.
Below is the content I am sharing I enjoyed this week:
Where is Robots.txt in WordPress?
My thoughts: Since the robots.txt file helps control how web and search engine bots crawl and index a WordPress site, it is absolutely worth knowing more about it. And, that is where I am failing. I think robots.txt is often overlooked in the grand scheme of things. This article clears up a lot of the questions about the robots.txt file.
Top 10 Books For PHP Developers
My thoughts: Although my personal favorite PHP book is missing from this list (likely because it is geared more toward beginners), there are many promising titles here. While I haven't read or even thumbed through (do people even do that anymore with books?) any of them, there is surely one here for you. My eye - and learning - is (or should be) on domain-driven designs and better architecture practices.
How to Prevent SQL Injections
My thoughts: SQL Injection is such an essential topic in programming and application development, especially in web development where you are likely to have a form of some sort for visitors to fill out with inquiries or other information. There are different types of SQL Injection attacks that range from sniffing for information, to invasive and downright destructive. Thank goodness for Prepared Statements and other similar practices.
2023’s Challenging yet Achievable(?) New Tech Goals for my Symfony-based Sites
#php #symfony drupal
My thoughts: Need some inspiration? Here you go.
Reuben Walker from Symfony Station has all the inspiration you need (and then some). With goals this coming-up year for many web-related projects tackling Symfony, Drupal, and Symfony/Drupal (and vice-versa) mixed. Good luck Reuben! We can't wait to see you smash those goals!
Rather than tech writing, dealing with WordPress
#wordpress #php #web
My thoughts: Here is a look at an older site with a lot of content through the prose of a tech writer. We are talking about a 20-year-old website. Wow.
You know there is a load of articles and pictures in those site folders. Plenty of troubleshooting was explored in this one. FTP, shell access, and the whole shebang here.
📰 Get your brand, product, or service the attention it deserves with affordable classified ad placement in the OpenLampTech newsletter.
Why MySQL Could Be Slow With Large Tables
#mysql #database #sql
My thoughts: MySQL is used on production sites far and wide, both large and small. It's safe to say that MySQL can handle massive amounts of data. In order for MySQL to perform at the optimal level, we can use correct data type choices, establish primary keys, execute performant queries, and other best practices as covered in this article by the experts at Percona.
Interesting Tech News and Articles 📰
🔎 How to Create a Link in Bio WordPress Site That Gives You Total Control
🔎 How to Buy a Domain That Is Taken (5 Steps to Your Ideal Domain Name)
🔎 InetSoft introduces MySQL reporting tool with drilldown capabilities producing great-looking web-based reports & dashboards
🔎 Database Malware Strikes Hundreds of Vulnerable WordPress Sites (01-20-2023)
🔎 Welsh Web Agency Illustrate Digital Secures £2.7m Partnership with WP Engine (01-20-2023)
🔎 If the FAA Database Can Be Corrupted, What About Your Website?
🔎 Awesome Motive Acquires Thrive Themes Growth Tool…
🔎 WordSphere LLC Announces 6.8m Acquisition of DrupalWare
🔎 WordPress VIP Releases Content Matters 2023 Report
[#Classifieds and Click Ads]
🤝 OpenLampTech earns a small commission (or payment in some form) from many of these links. Your support helps keep the weekly OpenLampTech newsletter free for readers.
We make incorporating a company as easy as possible, so you can focus on the important things. Visit IncFile today.
Join thousands of marketers as we explore tactics, ideas, and examples for making good content that builds lasting brands. Read Good Content today.
Get smarter every single day by reading Refind. I read Refind every morning because Refind tailors the content to my interests.
Never miss the essential e-commerce industry news. Free delivery to your Inbox every Monday. Subscribe to the Shopifreaks E-Commerce Newsletter.
Thank you for reading. I hope you have a great rest of your week.
When you are ready, here are more ways I can help...
WordPress Services - Initial website setup, blog management, small WooCommerce customizations
Content creation - Writing, editing, blog management
Email - Newsletters, marketing, copywriting
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).