Categories
WordPress

Quick Tip: Disable WordPress Block Editor Fullscreen Mode

I don’t know why, but any time I edit posts on this site, the block editor always goes into fullscreen mode. Even if I disable it, the next time I edit a post or refresh, it goes right back. My preferences aren’t being saved. Oh well, we can fix that with some PHP! Many thanks […]

Categories
Other Tech Junk

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 […]

Categories
WordPress

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!

Categories
Dev Stuff

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:

Categories
Dev Stuff WordPress

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:

Categories
Dev Stuff

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 […]

Categories
Other Tech Junk

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 […]

Categories
Dev Stuff

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 […]

Categories
Dev Stuff

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 […]

Categories
WordPress

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 […]