The Google Sheets QUERY function uses the Google Visualization API Query Language which offers a syntax similar to Structured Query Language (SQL) and if you have an understanding of SQL it offers a intuitive and familiar method of working with data stored in Google Sheets. In this post, after describing the sample data, the QUERY function […]
If you have not watched Rich Hickey’s talk on Hammock Driven Development you should do so now. I’ll wait right here whilst you do. Great talk wasn’t it? Although delivered ten years ago, many of the problems Rich describes I still encounter today so in this post I will discuss the key points from the […]
Scott Hanselman’s superb video on text editing is a must watch for developers of all levels because it is something that we as developers do on a daily basis, whether it is in a source file, JSON, XML or just a vanilla text file. Here are four keyboard shortcuts I learnt from this video that […]
This was my third year in a row attending NDC London and it remains my favorite conference. You can read about my earlier visits in 2018 and 2019. The Operating System As in previous years, the location for NDC London 2020 was the Queen Elizabeth II Centre which is an excellent venue. It is easy […]
Here’s what I learnt when building two To Do applications. One was built using pure JavaScript and the other used jQuery with a smidgen of JavaScript. Each To Do list had to satisfy several basic functions. The user had to be able to add tasks, remove tasks, save tasks and be able to retrieve them. […]
iancarpenter.dev 
You must be logged in to post a comment.