Get all those COVID e-mail test results into a spreadsheet
I’ve open-sourced my first efforts on reading an IMAP mailbox and tabulating the COVID-19 test results found there. The search is done via IMAP and only the matching e-mails are processed. No changes are made to the mailbox. What’s the point? Well, in places like care homes where many tests are done every day, the […]
Read MoreCreating a Scheduled Query in AWS Timestream – you need a role
Timestream is AWS’s stab at creating a scalable data store for time series data. Opinions on the service are mixed to say the least and its performance compared with a single instance of TimescaleDB is surprisingly poor. AWS is very good at enhancing their products in the months and years after release, so if you […]
Read More
Authenticate Matrix homeserver logins against a WordPress database via REST
I’ve open sourced something – the first thing in a while. Matrix WP REST Auth (GitLab) is a very basic way of responding to authentication requests from a Matrix homeserver which has been configured with the Matrix Synapse REST Password Provider. I’m using it to authenticate Riot.im users against a WordPress database, so every user […]
Read MoreSolve for reality
Don’t convert a client problem to match your usual methods. Solve for reality. After years in business in a solutions provider role, we often have tried and tested approaches, and of course, it can often help to have some guidance for how your organisation should provide its offerings, particularly as you grow. But don’t forget: […]
Read MoreWork from where works for you
It’s 2020 and we can dismiss a lot of prescriptive “wisdom” around what effective working patterns look like now. Where we need to be consistent is in our interfaces with others in business. We need to do and deliver what we say we will, in a spirit of “ask once”. But how and importantly, where […]
Read MoreVisiting Google in King’s Cross
Interesting stories start in interesting buildings. It’s always good to come into London to see my cousin Lorna, a proud Googler of some nine years now. She’s a strong advocate for the brand as well as the company as an employer. I’m a heavy user of Google technology in my day-to-day life as many of […]
Read More