Tag: automation
-
Converting CSV to SQL
in Dev StuffLearn how to convert CSV files into SQL statements using PHP. Avoid directly inserting data into a live database; follow a safer approach. See a PHP script example for converting CSV files into SQL inserts, with an output demonstration for an “airtravel.csv” sample. Use this script cautiously or as a starting point for similar tasks.
-
Quick Tip: HyperDock as a Service
in MacOSA macOS tool called HyperDock has been causing issues on macOS Catalina, with random stops requiring manual re-enabling. A script has been created to restart the HyperDock Helper automatically using a Login Item. This script monitors and restarts the Helper when it crashes, providing a workaround for the problem.
-
Disabling WordPress Faux Cron
in WordPressLearn about the WordPress WP-Cron system, its flaws, and how to fix them. Disable the default cron behavior and switch to a system cron for better performance. Improve site speed by managing cron events efficiently to avoid slowdowns on frontend requests. Let a system cron handle periodic tasks effectively for optimal site maintenance.
-
Quick Tip: Force Enable Auto-Updates in WordPress
in WordPressEnable auto-updates for WordPress core, plugins, themes, and translations using an mu-plugin with PHP code. Embrace auto-updates for smoother maintenance.
-
Windows, SFTP, and the Registry
in WindowsEasily handle dynamically generated SFTP IPs and ports by creating a wrapper script in Windows, allowing you to efficiently manage connections with additional data like private keys and proxy information. Register a handler for SFTP URIs with a Windows Registry file to streamline the process of connecting to SFTP directories.
-
Let’s Encrypt SSL on SABnzbd+
Let’s Encrypt and SABnzbd+ are easy to pair together, if everything works right and you’re lucky.