RSSAmplifier

Blog

James Crisp

Software dev, tech, mind hacks and the occasional personal bit

jamescrisp.orgRSS feed ↗10 posts

Latest posts

Ubuntu on old iMac: Fixing screen dim/sleep

My old iMac (late 2015, retina 27 inch) sadly reached end of support on OSX a while back. It still has a beautiful screen and enough processor power to do most daily task. I brought it back out of storage to be a Claude co-work box. After a little dalliance with OpenCore (not bad as [ ]

AirTag 2nd Generation incompatibility

To see the location of an AirTag second generation, you need to have an Apple device running the latest OS. For some reason, Find My online (website) does not show AirTags. Furthermore, older Apple devices won t even help you. Sequoia on Mac is unable to see the AirTag second generation location despite it still [ ]

The window.beforeUnload event – a sad tale

Well now, gather around children Once upon a time, the good developers wanted to save their users from losing changes if they left a form before submitting it. And as sometimes happens, Browsers looked kindly on the world, and provided the beforeUnload event, which could be hooked in Javascript so that changes could be automatically [ ]

Todays take on the BEST AI for a task…

Coding: Claude 3.7 for front-end work, especially with the help of Claude Projects to upload supporting files, and Extended Thinking turned on. Remember to always ask Claude to explain its plan before doing anything as it can get carried away. Claude 3.7 paid responds much faster than the free version. Mobile App Voice: I [ ]

Web Fonts built into all browsers (for sans-serif)

The fonts built into modern browsers are varied it is hard to avoid loading your own fonts. Arial is the rare exception it is well supported across all old and modern browsers. It looks a little different between Windows and Mac / iOS especially as a larger bold heading. On Android, it is [ ]

“The Obstacle is the Way” by Ryan Holiday

After reading an interview with DHH where he mentioned this book, and to assuage a latent interest in stoicism, I decided to check out The Obstacle is the Way . I found it an invigorating read. It is in the usual self-help style with stories supporting the ideas and approaches proposed. Here are my notes on [ ]

“Predicably Irrational” by Dan Ariely

A friend several jobs ago recommended I read Predicably Irrational by Dan Ariely. I bought it with all the best intentions, but somehow it sat on my bookshelf for a long time. Having finally read it, I was impressed. It has some well researched and backed up lessons on human behaviour, plus an engaging style. [ ]

Solving mysterious null values in Mysql date columns, stored by a Rails app

A few months ago, when I was doing some detailed database backup and restore testing, I discovered there were, out of millions of records which had user-entered dates, a handful that had null dates in a database column. I scratched my head for a while and couldn t work out how this had happened, as the [ ]

Testing performance before upgrading from Mysql 5.7 to Mysql 8

Mysql 5.7 is reaching end of life in October, so it is becoming important to upgrade. I am using Percona Mysql and the upgrade process with Apt and the Percona repositories is simple. Mysql automatically upgrades files and tables to suit the new version too. There are config file changes required, and quite a lot [ ]

Percona MySQL: Collecting All Queries with the Slow Query Log

If you want to collect all queries running on your database for a period of time, for analysis or replay, the simplest way to do this is using the Slow Query Log. To start collecting: To stop collecting and revert setting changes: The statements will be logged to: The performance degradation from logging all queries [ ]