tech and other interesting stuff
Playing roles With the lockdown in full swing, my friends and I have returned to playing RPGs. We have done mash-ups over the years, where everyone suggests a couple of genres and a location; and we randomly choose two genres and run that combination in a randomly-chosen location. It makes for some interesting combinations — […]
Continue Reading
Making the video editing workload much lighter Shotcut is a Free (GPLv3) cross-platform video editor. I’ve been using it a couple of times lately to put some simple clips together (like sorting the Take 2 copyright claim GTA Online video). I figured I’d use it to take a clip of my friends and I getting […]
Continue Reading
Jack Howitzer as Jack Howitzer in ‘Jack Howitzer’ I played some GTA V: Online the other night — my three word review: ‘fun but clunky’ — and uploaded the footage of it as I usually do, leaving it as a draft to be later updated with my automation tools. Later on I saw I had […]
Continue ReadingCold but bright It may have been down at around -2°C that morning, but the walk in Falkirk was great. The Kepies are really impressive!
Continue ReadingEvery day is a school day We set out to use OCR to extract metadata from frames of the loading and ending screens of Deep Rock Galactic to use to fill in details of videos destined for YouTube. In other words we went from: To: Why? It’s always good to reflect when you’ve done something. […]
Continue ReadingWe’re using OCR to extract game metadata from Deep Rock Galactic videos. We’re now at the point where if we give our script two images – one of the loading screen, one of the end screen – it does a pretty good job of pulling out the information. Now we need a way to pull […]
Continue ReadingMy path in the woods diverged, and I took them all We’ve been seeing if we can apply OCR to the loading screen of Deep Rock Galactic to generate metadata for YouTube uploads for automation. Last time, we got a quick-and-dirty script that would pull out the various parts of one image successfully. Now we’d […]
Continue Reading
What a tangled web we weave… I was confused. Staring at a console window, wondering how I’d installed a program†. The system package manager knew nothing about it, pip pretended like it never heard of it, and I hadn’t downloaded and compiled the source. I’ve never really had what anyone would call a sane management […]
Continue Readingtl;dr If you’re seeing this and the table does exist- check (and fix) permissions! I was searching my backups for a database file which contained the entries for an old ranty blog I used to have before I cancelled the domain. Lo and behold I had a named, dated .tgz file. Unusually, it contained a […]
Continue Readingtl;dr: run myisamchk on the problematic table I’ve run into the following error in my Apache error.log recently: Table ‘database.tablename’ is marked as crashed and last (automatic?) repair failed Fortunately the fix is simple: run myisamchk on the table which is marked as crashed: $ sudo su # service mysql stop # cd /var/lib/mysql/databasename # […]
Continue Reading