PHPnews.io

Overview for 'remysharp'

Words, n'stuff

Written by Remy Sharp / Original link on Feb. 11, 2020

My son once asked me: "who decided house was house?". Was it invented? Why start with a 'h'? What's with the sound? Who came up with that?As a kid I always wondered why the word "women" contained the word "men" and who decided that "men" would some claim over the word "women" (probably a man if I …


How to convert xlsb to csv

Written by Remy Sharp / Original link on Feb. 5, 2020

Converting from Excel formats to csv is something I've had to do many times in my career - usually to get the data into a database-import friendly format. The problem with xlsb is that it's a binary/zip format where support isn't great.JavaScript is my goto language, but there's no library that spe…


Toggle light and dark

Written by Remy Sharp / Original link on Jan. 27, 2020

There's odd excitement around dark themes these days, but I find that being able to switch between a light and dark theme to be really useful for working conditions (i.e. bright light or in the evenings).I've got shortcuts to toggle my: OS, Visual Studio Code and iTerm2.Toggle theme in MacOSThe sim…


Extracting Goodreads metadata

Written by Remy Sharp / Original link on Jan. 6, 2020

This week I posted the list of books and the reviews for 2019, but in addition, I also published the decades the books were published. That information wasn't so easy to extract from Goodreads, so I'm writing up for when I need it again in 12 months.OverviewI'm using a Mac, but all the tools I use …


Books I read in 2019

Written by Remy Sharp / Original link on Jan. 1, 2020

Proudly I've continued to read (if you know my story, this is a big deal for me), this year having read 29 books (28 listed below) and 9,976 pages (just because I had the numbers!).My absolute favourite was Miss Pettigrew Lives for a Day - a beautiful antidote to the world we live in today. I've al…


My 2019

Written by Remy Sharp / Original link on Dec. 30, 2019

Continuing a growing tradition on my blog, and apparently a growing trend on (what's left of) the web, here's my 2019. The most me-me-me post I have for the year.ProfessionalMy professional life continues to tick along, and my business turned 13 years old last September. My clients continue to have …