Category: WordPress

New Year’s Day 2025

Well, I made it through another year, I guess, so here’s my usual New Year’s Day blog post! I went to bed around 9:30 PM last night, after watching the first two Thin Man movies on TCM. I got out of bed around 6:15 AM this morning. My days of staying up late on New Year’s Eve are pretty much done, apparently.

WordPress stats

I like to use these posts for both useful self-reflection and pointless (but fun) stats. I’m going to start with some pointless stats related to this blog. I ran a quick SQL statement to get my posts per year, over the life of this blog, and got the following:

blog posts per year chart
blog posts per year

So that’s 49 posts in 2024. My most active year was 2005, with over 200 posts. The least active full year was 2013, with 33 posts. I don’t know if any of that is super-interesting to anyone but me, but there it is.

I was trying to think of why 2013 would be a low point, and I guess it probably had something to do with starting a new job that year. And that’s still my current job (SHI), almost 12 years later. (More about that later.)

I also looked at traffic stats on the blog. Nothing interesting to report there, except that December 2024 was my most active month ever, by a long shot, with more than 3000 views. All of that traffic was on one day though: December 9. And I’m pretty sure it was all search bots or AI training bots or whatever.

Health

I’ve been fighting a low-level cold since Thanksgiving (or thereabouts), so my health situation is pretty much business as usual. I remember having a pretty good run of “not being sick” at some point this year though. Maybe in the spring? I thought I’d made a note of it in Day One or somewhere, but I can’t quite pinpoint when it was or how long it was.

As for my weight: I started 2024 at around 160, and ended it at 165. I’ve been fairly stable at 165, plus or minus two, for the last three months. So I’m hoping that I’ve stopped gaining weight and have hit a stable point. (In 2023, I went from 150 to 160, so my gain this year was half of last year’s gain.) And I’m still logging all of my meals/snacks with LoseIt, as I have been doing since 2013.

I think I still need to do some work on getting my snacking under control. I need to cut down on cookies and pastries form the various bakeries and coffee shops here in town. (Having a good French bakery almost directly below my apartment, in the same building, has turned out to be a bit of a problem…)

On the exercise front, I’m doing good. I was going to look for some summary stats to support that, but I’ve just realized that Apple’s Fitness app doesn’t have any kind of “year in review” thing, similar to Apple Music Replay or any of the other end-of-year things that have gotten big over the last few years. Odd, since that would likely be really popular. You can get some yearly graphs in the Health app though. So, from that, I see that I’ve averaged about 45 minutes per day exercise and 550 calories per day on the “move” ring. That’s pretty good, and I see that it’s been pretty consistent over the whole year.

And, having written all this, I realized that I hadn’t gone for a walk yet, so I did that just now. Here’s a photo!

New Year's Day morning walk
New Year’s Day morning walk
Work

Wow, I could write a lot about work this year. My old boss retired at the end of 2023, so I’ve just finished out my first year under the new boss. I had a pretty solid relationship with the old boss, but I’m still working on building one with the new guy.

I had gotten used to near-perfect performance reviews from the old boss, so I was a bit surprised to get an average review from the new one. (Basically, a rating of 3 out of 5 on everything, and a lower raise than I usually get.) I have a feeling that he didn’t put that much thought into the review, since he doesn’t actually know that much about me or what I do. So I’m not too worried about him just clicking “3” down the row of questions on the review form; it’s not that I did anything wrong, he just doesn’t have much to go on. But I think I do need to try to build up some kind of relationship with him in 2025, if I can. It’s hard, since he’s in Texas and I’m in NJ, and since he has a fairly large number of direct reports, and responsibility for three main groups (AX, CRM, and ServiceNow). So I guess I need to just keep trying to be a good employee and make sure to do the stuff he wants me to do.

In terms of systems and projects this year: We’re still on AX 2012, and haven’t made any real progress towards moving to D365 F&O. Maybe that’s too simplistic a view. Some stuff is going on behind the scenes, I guess, but there’s really no concrete progress on the real work of moving off AX 2012 and getting to F&O. For 2025, we’re planning on upgrading our SQL environment and getting on the latest CU for AX, so that’s something, and likely a necessary start. At the start of 2024, we were saying that getting to F&O was a three-year project. I think it’s still at least a three-year project, and I’m not sure if 2025 is going to count as year one, or if 2025 will be more like “year zero” with the real project starting in 2026.

We’ve been going through what they call an “agile transition” over the last year.  We’ve been using something like scrum since 2022, but the new boss (and new IT management in general) has been trying to really formalize that. We now have a scrum master, daily stand-ups, and multiple standard meetings (the usual stuff). And our group has been broken up into two separate “feature teams.” Also, we’ve stopped doing weekly deployments, and now only do one deployment per sprint (every two weeks). So that’s been a lot to get used to. And for 2025, we’re switching from using Azure DevOps to Jira for our agile/scrum management. So, just when things are getting smooth, we’re going to upend it all again.

Learning and other fun Stuff

OK, that’s enough of the serious stuff. Now let’s go through some more fun stuff. Let’s start with my Goodreads year in books. Just 27 books for 2024, though some of the Wheel of Time books were pretty long (Lord of Chaos was 1049 pages.) I had set a goal for myself of finishing the WOT series in 2024, but I’m not quite done with the final book. So maybe I’ll finish it by the end of January 2025. I’m not quite sure what I’ll tackle next; WOT has been eating up a lot of my reading time. I have a bunch of Dresden Files and Laundry Files books in my TBR pile, so maybe some of those. Or Discworld? And I have so many comics piled up too!

In terms of professional learning, I only see three books on my list that count towards that, and they’re all fairly general books. I don’t seem to have learned any new programming languages in 2024, or anything else big.

Looking at my Pluralsight history, I see that I completed around 15 courses there in 2024. Some of those were work-specific, as part of Pluralsight “challenges.” Some were just stuff I wanted to learn on my own. So there’s a mix of agile/scrum stuff, C# stuff, AI stuff, and miscellaneous “soft skill” stuff.

At some point during the year, I started looking at maybe getting an AZ-204 certification. But I didn’t get very far with that, and I’ve pretty much dropped the idea now. Back in 2013, I also started thinking about a D365 F&O certification of some kind, but I’m not going forward with that either, at least not yet.

During my performance review, my boss said that he wants me to pursue a SAFe certification for 2025, so I’m starting to work on that. Honestly, I’m not too enthusiastic about it, but it’ll probably help my career, and I’m open-minded enough to give it a try, I guess. I’ve started a leaning path in Pluralsight, and a video series on O’Reilly. I might also try to read the SAFe Distilled book at some point too. I don’t know. This plan may fizzle out, honestly, but I’m going to give it a try.

Okay, back to fun stuff. Here’s my 2024 year in film, from Letterboxd. I watched a little over 100 movies this year. I started and ended the year with After the Thin Man. My five-star ratings for the year went to The Thin Man, Casablanca, When Marnie Was There, and 10 Years with Hayao Miyazaki. The only film on that list that was new to me was When Marnie Was There.

My Apple Music Replay is kind of weird. My top song for the year is Hell of a Ride, by Nourished by Time. My top album is Songs of Surrender, by U2. And my top artist is Bombay Bicycle Club. I guess those all kinda make sense, though they’re all a little surprising. I guess the U2 album being on the top is mostly because it’s a four-disc set, and I added it in January. Looking at albums that I added to my library this year, none of them really stand out. There are some really good ones, but nothing that really stuck enough for me to listen to a lot, or that really blew my mind. At the moment, I’m pretty enthusiastic about the new Joan Armatrading album.

Ten Years Ago

I’ve been doing this so long that I can now look at my post from ten years ago (and even twenty years ago) and try to think about some big picture stuff. (The post from 20 years ago is just a one-liner about a song, so that one’s not too valuable.)

So, ten years ago:

  • I noted that I’d gone from 200 pounds to 165 over the course of 2014. So I’m starting 2025 at the same weight at which I started 2015. I’m not sure how I feel about that, but it is what it is!
  • 2014 was my first full year at SHI. I’ve been there since, so overall that’s gone well, I think.
  • I talked a little about consulting and volunteering in that post. I haven’t done any consulting in a long time, and I’m not planning to. I think those days are done, unless I decide to do that part-time after I’m retired. And I haven’t done any volunteering either. I’d like to do some of that, but I’m getting to the point where I’m too tired to do much of anything outside of my normal salaried work. (And I’m OK with that.)
  • I finished 30 books in 2014, so that’s pretty similar to this year’s total.
  • I moved this blog to WordPress in 2014, so I guess I should have celebrated my ten-year WordPress anniversary in 2024. I’m still OK with WordPress (even with Matt Mullenweg’s shenanigans).

WordPress, business books, and some health stuff

It’s Sunday morning. I’ve made it through another week. I’m going to start writing this post as a stream of consciousness thing, and see where it goes. I have a bunch of thoughts in my head, as usual. Maybe this will come together into something coherent. Maybe not.

WordPress

There is a bunch of crazy stuff going on right now between WordPress / Matt Mullenweg and WPEngine. I’m not going to try to summarize it or link to any of the many articles and blog posts about it. I went down a hole this morning reading some of them, and I don’t think I came out of it with any useful knowledge about which side I should take (if any) and what (if anything) I should be doing. I guess I’ll be sticking with WordPress for the time being. This doesn’t seem to have devolved into something like the Twitter situation, where the whole thing has been turned into a nazi bar, and the only option was bailing out.

Maybe I should think about switching to Drupal! I haven’t touched Drupal in more than a decade, but it’s probably still fine, right? I haven’t read anything about Dries Buytaert going off the deep end. (Though, now that I’m looking at his Wikipedia page, I’m reminded of the Larry Garfield thing from several years back. Again, no clue who’s right and who’s wrong on that… Sigh.)

Business Books

In between Wheel of Time books, I’ve been reading a few relatively short business books. I mentioned Thinking in Systems a couple of weeks ago. I’ve since also read a couple of books from Seth Godin’s Domino Project, from several years back. Honestly, I don’t remember why I was engaging with that stuff back when it was first coming out. I guess I had some kind of self-improvement thing going… maybe this was concurrent with my David Allen / GTD thing? I don’t know. Anyway, I have several of those books in my Kindle library but never got around to reading them.

I read Do the Work By Steven Pressfield last week, and I’m most of the way through Read This Before Our Next Meeting by Al Pittampalli. Neither or these really seems like something I needed to read right now. I was hoping the latter book might help me figure out how to deal with the barrage of meetings I’ve been dealing with recently, but it wasn’t that helpful.

I’m not happy with the number of meetings I have to attend at work these days, and sometimes it seems almost comic (like the one meeting on Thursday that required two separate prep meetings for it, on Tuesday and Wednesday). But there’s not much I can do about any of that other than grin and bear it.

To get back to my reading, I guess I’m about done with business books for now. I should probably start reading Towers of Midnight today, and see if I can get through the prologue. Reading these books is bringing me so much joy. I’m almost embarrassed to admit it, given that I kind of looked down on them for so many years.

My Health

I had a move streak going on my Apple Watch for quite some time. I gave up on it this week. It lasted for 52 days, which is pretty good. And the most interesting thing about it, to me, is that this means I haven’t been sick for almost two whole months! I even went to see a movie a couple of weeks back, and didn’t get sick. (Though this was a niche Paul McCartney movie, and there were maybe a dozen people in the theater, so not a typical crowded theater thing.) I need to watch myself though: I just noticed that it’s the one year anniversary of my bout with COVID last year. So I’m still going to play it safe and skip NYCC next weekend.

a little more WordPress, and some bookmarking notes

OK, so this is probably my last post on my WordPress issues for a while. The last thing I did with the sites, over the weekend, was to move my databases from MySQL 5.7 to MariaDB 10.11, and to switch the sites from PHP 8.1 to 8.2. Both of those things worked out fine, and I haven’t had any trouble. So I guess I’m OK for now, and I’m going to leave the sites alone for a bit.

One related thing: I’ve started looking at WP-CLI again. I first starting using it… exactly ten years ago! Weird coincidence. Anyway, I stopped using it, since I was having some trouble with it on my IONOS account, due to some PHP thing. I could probably have figured it out, but I gave up, and have just done WordPress updates from the admin GUi since then. But I think it might be time to try WP-CLI again.

Next subject: bookmarking services. I’ve stuck with Pinboard for years, and it’s mostly worked fine, and I just take it for granted. Every once in a while, though, there’s an outage of some sort, and that always gets me thinking about maybe switching. And there was an API outage this morning that got me looking at social media to see if there was any info on it, which surfaced some stuff about the Pinboard guy tweeting something kinda anti-trans, related to the Olympics. So of course that’s got me looking at alternatives again.

Raindrop.io seems to be the most popular choice. But they block it at work, for some reason, so I’d only be able to use it at home. There’s a new one I saw a reference to today called Linkwarden, and that looks promising. $3/month, it’s not blocked at work, and it’s got an import function, so I’m assuming I could import my Pinboard data. I might sign up for a trial account this weekend.

Honestly, I don’t know if any of the alternatives to Pinboard are likely to be more reliable than Pinboard. They mostly seem to be side-projects from small developers. (And I don’t really know who’s behind any of them, so I can’t really say if their opinions are more or less acceptable than the Pinboard guy’s opinions.)

WordPress woes, and more San Diego stuff

Since my last post, I’ve continued to have some WordPress issues. I called IONOS support, and they were not super-helpful, but there probably wasn’t much they could do. I did as much clean-up on my sites as I could. I deleted a bunch of unused plugins and templates, and disabled a few plugins that I probably didn’t need. The site went down for about an hour, two days ago, but has been fine since. So maybe I’m OK. It’s frustrating when you’re troubleshooting something like this, and there’s no “aha!” moment, just “eh, maybe that helped?” and a shrug.

This has got me considering moving to a simpler hosting arrangement again. IONOS is pretty cheap for me right now, only $9 per month. (I’m not even sure why it’s that cheap. It used to be $14. There was some confusion with the billing a while back, and it landed at $9 somehow.) IONOS has dedicated WordPress hosting that’s not expensive, and would give me more resources, I think, but a little less flexibility. I’ve also considered moving to WordPress.com. They’re kinda expensive, but they do have an $8/month that would probably work for me.

Back on the topic of San Diego Comic-Con: Here’s an article about all the folks who got COVID at the con. And here’s an article from The Beat about “winners and losers” at the con. I’ve seen a few interesting things coming out of the con. Stuff that makes me think “yeah, that’s cool,” but not “yeah, that’s so cool it would have been worth the grief of cross-country travel, COVID, and the cost of travel and lodging”.

I do need to take a vacation this year, at some point, somehow. And I still haven’t figured out what to do about that. But that’s a topic for another day.

Not at SDCC, 2024 edition, and WordPress issues

It’s become kind of a thing for me to write a “not at SDCC” post every year, during SDCC. I’m probably not going back to SDCC ever again, honestly. The pandemic really created a “hard stop” for me on a bunch of stuff, and I’m thinking now that I’m not likely to go back, ever, on a lot of that stuff.

I haven’t been following the news out of the con too closely. Most of it isn’t that interesting to me, honestly. I haven’t read a lot of comics lately, since I’ve been concentrating on getting through the Wheel Of Time books. And I’m not too interested in any of the upcoming nerd-related TV or movie stuff. I still haven’t watched the latest Star Wars, Marvel, or Star Trek streaming shows. And I only just watched Ghostbusters: Frozen Empire, since it just came out on Netflix. I might go see Deadpool & Wolverine in a theater, but probably not. So all this talk about the next big thing doesn’t matter to me, when I still haven’t seen the last big thing.

Anyway, I wanted to see if I could recapture some of the old “con spirit” this weekend, so I decided to watch Alan Tudyk’s Con Man series yesterday. I watched the whole first season. (Which isn’t hard, since the episodes are just 10 minutes long.) I watched some of those previously, when they were on Comic-Con HQ, which I subscribed to, during its brief existence. The show is now available on Amazon Prime, so that’s convenient. I laughed out loud a few times, which is pretty rare for me, these days.

On an unrelated topic: My blog has been kind of flaky this week. I got notices that it was up and down all last night. That doesn’t really matter much, of course, since nobody really reads this blog, and there’s nothing much important on it. But it annoys me. So it sent me down a rabbit hole of WordPress troubleshooting. I don’t think I have much to say about that, though. No big revelations that would be worth sharing, or documenting so I remember them next time. Just a bunch of stabs in the dark, then a shrug, and an “eh, good enough for now.” Everything is working, but still kind of slow, so I’ll just have to see if it gets better on Monday.

I haven’t been sleeping well the past few days, so my energy level is pretty low. I got some exercise this morning, and now I’m likely to spend the rest of the day reading, watching random bits of the Olympics, and maybe watching Con Man season two later.

Grammar checking – Grammarly and alternatives

I have a bunch of stuff to blog about today, and I sat down expecting to write a long rambling post, but then I got sidetracked into some grammar checking stuff, so now I’m writing a post about grammar checking.

As part of my general mucking around with AI stuff, I decided to finally give in and sign up for a Grammarly account. I’ve always avoided Grammarly, mostly because I’d heard very bad things about their privacy policy and practices, back in their early days. I guess that’s gotten better, and they have a page on their site with many assurances about how they don’t sell your data, and so on, so maybe they’re not so bad now. We recently acquired some kind of site license for Grammarly at work, but that’s only available to salespeople, I think. But the fact that we’re paying for it at work indicates that they are likely taking privacy pretty seriously, otherwise they wouldn’t have gotten past our InfoSec folks.

I briefly installed the Grammarly app on my Mac, but that quickly got to be more of a pain than a help. Most of my writing on my Mac is in Evernote, and Grammarly works there, but I’m not generally writing in complete sentences in Evernote, so most of Grammarly’s advice there is more of a hindrance than a help. So I removed that. It occurred to me that the only place where I really need Grammarly, in my personal life, is on these blog posts. This is really the only long-form writing I do where I’m trying to write in complete, grammatically correct, sentences. So, for now, I’m experimenting with copying & pasting my posts into the editor on the Grammarly web site, making any corrections there, then copying back into WordPress. Overall, that’s helped me catch a few minor errors, but nothing worth paying a lot of money for. And I’ve found that I can’t copy the whole text from Grammarly back into WordPress, since it’ll muck up the HTML, so I have to see what Grammarly wants me to fix, then fix it myself in WordPress, which is time-consuming. There’s probably a way around that, but I’m not sure what it is.

So I can keep using the free version of Grammarly, I guess, but I don’t know if I will. It’s a little aggressive about trying to get you to upgrade to the paid version, and it’s not that much help, really.

I’ve started to look around at alternatives to Grammarly too. There seem to be two primary ones: Ginger and Hemingway. Ginger is much like Grammarly: similar tools, similar pricing. I didn’t spend too much time on it. Hemingway is a bit different. It does an analysis of your writing style, focusing on several things, but it doesn’t seem to do the simpler checks that you get from Grammarly and Ginger. For instance, it doesn’t seem to catch simple homonym errors, which is honestly the most frequent error I make that isn’t caught by spellcheck.

I was curious about comparing the privacy policies of these three products, so I asked Bing Chat to compare them. It came back and told me that all three products had similar policies, but the sources it cited all came from Grammarly’s policy, so it was obviously hallucinating the info for Ginger and Hemingway. (And, as is normal with these things, you’d never know that without checking sources.) I asked the same question of the web search assistant in Poe, and that did a little better, though I suspect that it was also bullshitting somewhat (which is probably a better word for it than “hallucinating”). In short, Hemingway seems to have a slightly better privacy policy than Grammarly or Ginger.

The Poe results referenced a couple of useful comparison articles that I checked out. One of them was WordPress-specific, so I read that one. It mentioned a Jetpack grammar module, which sounded like exactly what I need, so that was exciting, but it turns out it was discontinued in 2019, so that’s not an option, unfortunately.

So I guess the end result here is that I still don’t know what to do. I don’t really want to pay $100+ per year for Grammarly or Ginger, so I’ll stick with the free Grammarly account for now and see how it goes. Maybe I’ll just keep proofreading my posts myself.

 

WordPress backlinks, self-pings, and more

My WordPress install has mostly been on auto-pilot lately. But a few things have cropped up recently that have got me looking at it again.

First is a minor issue that I’ve been meaning to look at for a while. My site used to do “self pingbacks” but those stopped working a while back. A self pingback is essentially a backlink within the blog, so if you write a new post (A) and link to an old post (B), then that old post (B) shows the pingback from post (A).

I’ve been thinking about these recently, since both Evernote and Obsidian support backlinks within your notes. Evernote added the functionality earlier this year. In Obsidian, I’m not sure when it was added, but it’s available in a core plugin. I find it useful, both in note-taking and on the blog. So I put a little effort into trying to get it working again today.

It’s not easy to track down information on this subject. If you search for “WordPress self pingbacks,” you’ll mostly get info on how to stop them rather than how to fix them. I guess a lot of people don’t like them. And if you search for “WordPress backlinks,” that mostly gets you SEO stuff about how to get other people to link to your blog and drive traffic to it. In blog terms, “backlinks” usually refer to links to your blog from other blogs, not from your own blog. So that’s mostly useless. My best guess at this point is that either my host (IONOS) is blocking them, or my current theme doesn’t support them. It seems like most people aren’t too enthusiastic about them.

So looking for alternatives, I thought about turning on the related posts functionality in Jetpack. That might not always surface back-linked posts, but it would be a good start. Well, long story short, I can turn that on in Jetpack, but then it doesn’t stick. Not sure if that’s something simple, or some bigger issue. (There are other plugins that can do related posts, but I haven’t tried playing around with any of them yet.)

That all led me down the path of thinking about what I’m doing with Jetpack, vs. what I’m doing with my install on IONOS, and whether or not it was time to switch to a managed site. Every time in the past that I’d looked at managed sites, they were more expensive than just doing my own thing on IONOS. And, in some cases, offered less flexibility.

In theory, I could switch over to my host’s official WordPress hosting, rather than my current generic hosting, and maybe that would get me something. I’m not sure though. Or, I could give up and switch to WordPress.com, which would certainly simplify things, but I’d be giving up some stuff too. Sigh. I guess I’ll stick with what I’ve got for a while longer. It’s mostly working the way I want it to.

new WordPress theme and PHP version

My second pointless project today, after spending the morning messing with bookmarks and browsers, was to find a new theme for this blog, and update the version of PHP that I’m using.

I’ve been using the Stargazer theme for a long time, and I’ve been really happy with it. But it hasn’t been updated since 2018. And I’ve started getting PHP errors on this site. I also noticed that I was running PHP 7.4, and should probably switch to 8.0. Doing a little testing with that revealed that Stargazer definitely would not work with 8.0. So I decided it was time to upgrade to a newer theme.

I tried out a few free themes from wordpress.org and wordpress.com. I didn’t find anything that was quite what I wanted. After trying a bunch of stuff, I’ve settled (for now) on the Twenty Sixteen theme. Twenty Sixteen is, of course, the default WordPress theme for 2016. I tried out a couple of the newer ones, but they weren’t right for me. Twenty Sixteen has a right sidebar, a header that doesn’t look too bad, and a fairly clean layout. I don’t know if I’m going to stick with it, but it’s good enough for now.

After installing it, I upgraded my PHP install to 8.0. That seems to be working fine. So at least now I’m running a recent PHP, a recently-updated theme, and a fully up-to-date WordPress.

I’d really like to switch to something a little more customized, but this is good enough for now.

Blogging vs. blog setups

I saw this comic on Twitter this morning, and immediately started thinking about where I fit on it. The comic is from rakhim.org, and I hope he doesn’t mind me pasting it in here. (His blog is worth a look, by the way.)

This site started out under Blogger in 2001, so it kind of fits the “old-ass Blogger.com site” description, but I moved it to WordPress in 2014, so it kind of almost fits the “WordPress setup from 2004” description too, though a decade later. (And before Blogger, I was doing some proto-blogging on my old GeoCities site, which would definitely have fit the “weird dude who writes raw HTML” category. I’d like to have some claim to the “cool MIT professor” data point, but I’m nowhere near that one.)

On the “number of posts about elaborate blog setups” axis, I like to think I don’t spend too much time blogging about blogging, though of course that’s what I’m doing right now. Looking at my stats, I have 62 posts tagged “Blogger”, 52 posts tagged “WordPress”, and 2,442 posts total here. So, yeah, not too much meta-blogging.

Of course, for me, initially, part of the point of blogging was to learn about HTML, web hosting, the UNIX command line, and stuff like that. And when I switched to WordPress, part of the point there was just to learn more about WordPress, for professional reasons. But my work now doesn’t really involve any of that stuff, so now the blog is just a blog and I don’t fiddle with the setup that much. I’ve even thought of moving it to WordPress.com, so I don’t have to worry about the setup at all.

Content-wise, I wish my blog was more interesting/useful and less navel-gazing, but I’m kind of okay with navel-gazing right now, since it’s been a rough year and the blog is one of my only outlets for getting stuff out of my head now. I could go see a therapist, I guess, but my blog hosting is only $14/month, and I’m pretty sure therapy would cost a lot more.

tinkering with WordPress

Just for the sake of doing something useful today, I decided to tinker with my WordPress setup a bit. I’d upgraded to WordPress 5.5 in mid-August, then updated my version of PHP from 7.3.21 to 7.4.9. And, a little later, I switched to a new syntax highlighting plugin. I had one more major thing on my to-do list: upgrading to a newer version of MySQL.

My host, IONOS, makes it easy to switch PHP versions; you can do that right in their control panel. But you can’t just switch to a new MySQL version. You have to create a new database, export you data, import it to the new database, then edit your WordPress config file to point to the new database. So I did that first on my test database, and it worked fine, so I went ahead and did it with my production database too.

It had been a long time since I’d done anything even vaguely low-level with MySQL. The IONOS control panel lists your MySQL databases and gives you a link to get to a phpMyAdmin site for each of them. From there, you can backup, restore, run queries, and so on. On my first try, I forgot that you need to edit the backup SQL to remove the “create database” command, and edit the “use” command to point to the new database. But once I figured that out, I didn’t have any problems.

My old test WordPress install takes up 19 MB in the old database and 35 MB in the new one. I’m not sure why the new version is bigger than the old version. I could probably figure that out, but it’s not really important. The max size on a MySQL database in IONOS is 1000 MB, so I’m fine there. The production blog is 60 MB in the old database and 87 MB in the new one. So if you ever wondered how much space 20 years of blog entries takes up, it’s apparently 87 MB.

I did all this on my PC, rather than my Mac, and it turns out that I didn’t have an SFTP client installed. On my Mac, I generally use Commander One for SFTP file management. On the PC, I’ve recently started using Directory Opus as an Explorer replacement. Opus includes SFTP support, but it’s an add-on purchase, and I hadn’t bothered with it when I paid for my license a few months ago. I went ahead and enabled a trial of the FTP functionality today, and it worked fine. So I’ll probably pay for it when the trial expires. It’s only $10.

The first thing I did after switching to the new database was to run a WordPress site backup with UpdraftPlus. I’ve been using UpdraftPlus for a long time. I’ve stuck with the free version, which is good enough for me. The paid version is $70, plus $42/year after the first year. That’s not bad, I guess, but I don’t really need it.

The next thing on my WordPress “rainy day” list is to maybe look into switching to a new theme. The Stargazer theme that I’ve been using since 2014 hasn’t been updated in a couple of years and is being “phased out” by its developer. He’s replacing it with something called Exhale, for which he’s charging $50/year. I don’t have a problem with that, but I’d like to stick to a free theme, if I can. (If I was actually making money off this blog, I’d be more willing to spend money on subscription themes and backup services, but this is really just a little personal blog with no revenue stream, so I like to keep things simple.)