Derrick.Blarg

Blog

derrick.blog/

Profile

derrick.blog/author/emrikol/

  • Getting WordPress Database Size via WP-CLI

    A WordPress WP-CLI command `db-size` allows fetching database tables, their data, and index size in various formats. The command offers sorting options like total, table, data size, and index size. Use `–format` to adjust the output format (`table`, `csv`, `json`, `count`, `yaml`), and `–raw` for full byte size.

  • Nano: The One True Editor

    Forget 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

    Learn 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.

  • Pi-hole, Google Wifi, and Device Names

    Using a custom script with `nmap` to find device hostnames on a Google Wifi network. The script outputs to `/etc/pihole/custom.list` with manual MAC to hostname mappings. It can be slow, especially on a Raspberry Pi 1.

  • Converting CSV to SQL

    Learn 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: Looping a command in bash

    Discover how to monitor disk space usage efficiently while running slow programs to prevent sudden command failures. Use `watch -n10 bash -c “df -h | ack disk1s5″` for real-time updates, where `disk1s5` represents the desired partition. Run `df` to find the correct device file.

  • Half-Baked Plugins: Embeds for Twitch and Gutenberg

    Learn about Embeds for Twitch and Gutenberg, a WordPress plugin for embedding Twitch channels, videos, and clips as Gutenberg blocks. No plans for release, just for learning. Note: Clip functionality may be faulty. Explore Half-Baked Plugins for more experimental projects.

  • Deleting Old Post Revisions in WordPress with WP-CLI

    Working with a client’s large database, I crafted a custom WP-CLI command to purge post revisions based on specific criteria, saving backups of those deleted. This script efficiently prunes revisions older than a year and prior to post publication, reducing the overall database size prior to a site migration.

Close

Ad-Blocker Not Detected 🛑

Consider installing a browser extension that blocks ads and other malicious scripts in your browser to protect your privacy and security, conserve your expensive data plan, and cut your online carbon footprint. Learn more.