-
Raspberry Pi: February 2021
I often feel like I don’t get enough use out of my Raspberry Pi devices. I have a Raspberry Pi Model B Revision 2.0 (512MB) and a Raspberry Pi 4 (4GB). Their current uses are as follows Raspberry Pi Model B: Pi-Hole Node-RED (Still haven’t done anything with it) Raspberry Pi 4: Radarr/Sonarr/Sabnzbd ZNC PiVPN […]
-
Getting WordPress Database Size via WP-CLI
One WP-CLI command that I’ve found handy is this db-size command. It allows you to output a site’s registered database tables along with the data and index size in any format that WP-CLI natively supports, with multiple sort options: Here’s some example output from one of my test sites: Enjoy!
-
Nano: The One True Editor
Forget about vi/vim/edlin. Nano is the only editor that you need in the console. Sure, it may not be perfect, but with a few extra steps in .nanorc it can really be a great experience. Here’s my .nanorc with some comments showing what’s changed:
-
Quick Tip: Export WordPress SQL output via WP-CLI
If for some reason you can’t run wp db query, but need to export SQL output to a CSV or other file, then have a look at this small WP-CLI command I whipped up that should allow this: I’d add an example here, but I don’t have any right now that I can share 😐 […]
-
phpMyAdmin and MariaDB with Docker
I used to run a MariaDB server on an old Linux machine for working with database dumps and other things, but after moving all of that to a new Raspberry Pi 4, I never really set it back up. So instead I thought I’d play with this fancy new Docker stuff all the cool kids […]
-
Pi-hole, Google Wifi, and Device Names
One of the things that bothered me for quite some time with my Pi-Hole was that using it with Google Wifi (first gen), it wouldn’t automatically detect device hostnames. I’d done a lot of googling and never could get it to work even after a lot of different trials with multiple settings. Eventually I gave […]
-
Converting CSV to SQL
I was recently working on an issue that required me to dig through gigabytes of CSV files to look for patterns and data points. I had no intention of bringing all of this data in to Excel, because there’s not enough RAM on earth for that to work. Instead I thought it would be easier […]
-
Quick Tip: Looping a command in bash
I recently came across the need to watch my disk space while running a slow program to make sure I didn’t run out. If I did, the command would fail silently and I’d have to start over again. This can easily be done with this short snippet: The important part here is disk1s5, which is […]
-
Half-Baked Plugins: Embeds for Twitch and Gutenberg
In my forever attempt to learn and understand Gutenberg, React, and ES6 (which I am failing at horribly) I sometimes build WordPress plugins just for the learning experience. I don’t have any full intent on releasing these to the WordPress.org Plugin Repository because I honestly don’t feel like dealing with end users and support. I’m […]
-
Deleting Old Post Revisions in WordPress with WP-CLI
Recently I’ve been working with a client who’s site we’re going to soon be migrating. To help with any downtime, we’ve been looking at reducing their database size, which is something around 50-60 gigabytes. After looking through the database, one easy win would be to purge as many post revisions as possible, since their wp_posts […]