Category: Dev Stuff
-
Sending Prowl Alerts via Bash
in Dev StuffLearn how to send alerts using Prowl for server scripting, ensuring proper alert notifications, even after struggling with other options like Twilio.
-
Supercharge Your Clipboard with a Shell Function for iTerm2
in Dev StuffDiscover a nifty shell function tailored for iTerm2 on macOS, bridging the gap between your terminal and clipboard, making it seamless to copy content directly to your clipboard, even from remote servers.
-
More Garbage Sysadmin: Reboot Linux Server on Kernel Panic
in Dev StuffFacing kernel panics on your Raspberry Pi? Dive into a less-than-ideal but efficient fix involving an automatic reboot using a startup script, ensuring your server recovers swiftly on kernel panics.
-
Get First Date of Week in Google Sheets, When the Week of the Year is Related to the Row Number
in Dev StuffDiscover how I used ChatGPT to devise a Google Sheets formula that returns the first date of the week based on a row number. This comprehensive guide breaks down each part of the formula, ensuring you can adapt it to your specific needs and track your daily or weekly tasks with ease.
-
Quick Tip: Bash CLI params
in Dev StuffLearn a clean and simple way to add CLI params to a bash script by incorporating short, long, space-separated, and equal-separated arguments for ease. Ideal for quick bash script hacks, this method facilitates efficient handling of CLI parameters.
-
Nano: The One True Editor
in Dev StuffForget about other console editors. Customize Nano in your `.nanorc` to enhance your editing experience. Utilize features like auto-indent, bold text, history log, mouse support, line numbers, tab size adjustment, and syntax highlighting for a smoother workflow.
-
Quick Tip: Export WordPress SQL output via WP-CLI
Learn how to run custom SQL queries on your WordPress database using a small WP-CLI command. The command supports different output formats like table, CSV, JSON, and more. Plus, it includes a dry run option for safety. No need to rely on `wp db query` anymore!
-
phpMyAdmin and MariaDB with Docker
in Dev StuffLearn how to set up MariaDB and phpMyAdmin using Docker on a MacBook Pro. Start containers, configure settings, and connect to databases easily. Useful commands included for managing containers and performing tasks like importing SQL files. Helpful references provided for your Docker journey.
-
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.