1 year ago 🥁 for day 18, 2021 with 269 words.


Days of COVID: 308.
Exercise: Taking out the trash.
Welsh phrase of the day: Dw i'n hoffi dwisgo dillad (I don't like wearing clothes).

If I have to type "Dw i'n ddim yn hoffi" into duolingo I'm going to scream, or even "Dych chi ddim yn hoffi". The first is the I for and the the later is the Do or Are form, as in Do you like chocolate?

Speaking of languages I was resurrecting some old code that we need for a new project involving vaccination clinics - yes I write software to schedule nursing staff, and of course vaccination clinics are the latest need.

Anyway, to get back on topic, I was looking for the code that we previously used - and it turns out still use - but I was having difficulty finding it. I knew it existed and I knew it was in our code base and I knew that we ran it from a cron job, what I had forgotten was that for efficiency instead of writing it in PHP because it's entire purpose was to insert new records in the DB based on certain conditions I wrote the whole thing in SQL instead.

A very long SQL statement with SQL variables and all sorts of clever stuff. That was back in 2016. The new version that I wrote today, was written in PHP so that it would fit inside our auditing and logging infrastructure. Still the guts of the action was a complex SQL statement, but wrapped in PHP.

If you got this far, reward yourself, go play this: 2020 Game

User Photo

By Yorick Phoenix 🥁

Chief WriteTogether Bug Finder & character stringer. Generally, to create computer code, but sometimes actual words and paragraphs. Listens to lots of music, takes lots of photos, & invests in stocks for the long haul.

Get Yorick Phoenix's newsletter

Almost there! Check your inbox and click the link to confirm.

Subscribe to Yorick Phoenix's latest writing to get it right in your inbox.