Random blog posts

Desktop Liberation and its related blog and G+ community aims to help you use cloud based APIS and services without being constrained by your desktop software. There’s a particular emphasis on Google APIs and JavaScript, but there’s also plenty of Microsoft and other stuff here too. All code here is unprotected and free to re-use

To support my site, and if you find the material useful, you can buy my Google Apps Script and VBA titles published by O’Reilly media.

Latest articles

  • One of the challenges with Apps Script V8 compared to Rhino is that you can’t be sure of the order of global variable initialization. Personally, this is not an issue for me, as I avoid [...]
  • Qottle If you are using an API you often need to queue tasks that are asynchronous and constrained by other factors such as rate limits of the API. Qottle is a general purpose queue manager [...]
  • The coronavirus is with us, and naturally, there’s much interest in data on its mortality, reach and spread, and of course much discussion on lockdowns, health capacity, social distancing and how they might affect those [...]
  • Apps script now supports JavaScript ES6 Apps Script V8 now supports the same modern JavaScript you can use when writing for the browser. Up until now, you had to write in a dialect of JavaScript-based [...]
  • var, const and let One of the key things that V8 has sorted out is the scope of variables. Using var to declare variables meant that anything declared within the scope of a function could [...]
  • This is a new section to collate various snippets related to GraphQL both from and back ends. For the purposes of these articles, I’ll be concentrating on the integration of this collection of platforms with [...]
  • The data that comes back from GraphQL is not ideal for input to Elastic Search which is designed for full-text searching, which means it loses context when searching arrays. Consider this response from some fictional [...]
  • This section is all about using Elastic Search with Cockroach DB and GraphQL. Sometimes SQL just doesn’t cut it for the kind of searching that’s required nowadays, and you need to use something that’s designed [...]

The most geeky things

  • Orchestration of asynchronicty in ExcelCompared to languages such as javaScript, VBA lacks the syntax to effectively deal with asynchonicity. Javascript is all about starting something and getting a callback when done. VBA has limited, and [...]
  • A whole bunch of front end platform libraries that go together really well, but that are hard to grasp and get started with. Here’s a bunch of snippets to help show how all these things [...]
  • There are lots of references to color on this site, and it seems to be a subject second only to jSon  in popularity. In this section I’ll bring together some new and some older color related topics.Note [...]
  • Here’s a way to automatically publish documentation about every VBA project, module, procedure and class in the currently open Workbook. There are four options for output, each directly from Excel.Google interactive tableStatic html web pagejSonA [...]

The most popular topics

  • This collection of articles deal with various Google Cloud Platform APIS. The full content is below. It is part of a project that I will document at a later stage The next section is a [...]
  • JSON and Excel using VBA classes that emulate JavaScript objects, parsing and stringifying JSON and dealing with data from external services. Includes a data driven REST-EXCEL library, and implementation of Google oAuth2 authentication […]
  • Geocoding, Mapping and creating data driven applications straight out of Excel get it now This article will cover 3 main topics. I wrote all this stuff a few years ago, and some of the services may [...]
  • What is d3.jsd3.js is a javaScript library that provides a ‘declarative framework’ for DOM manipulation and simplified access to SVG. d3 is the work of Mike Bostok and you should spend some time taking a look at the [...]
  • Migrating from VBA to Google Apps Script, or using them simultaneously can be hard to get started with. Although this material has been largely superceded by Going Gas, there’s stll some useful stuff here. […]

Choose a categorie

Or select a Tag in the below cloud

Your browser doesn't support the HTML5 CANVAS tag.

My YouTube Channel

My Publications

Google developers expert program

Full Site map

The content of the entire site is viualised here

All categories