APIS and techniques
Sharing secrets between Doppler, GCP and Kubernetes
3 secret managers working together. How to use GCP Secret Manager, Kubernetes secrets and Doppler together. […]
Node.js
Apps Script
Finding the scriptId from Apps Script projects on github
In Every Google Apps Script project on Github visualized I demonstrated an app that could be used to explore what every Apps Script developer who has shared their code is working on. One of the features […]
Apps Script
Sharing data between Apps Script and Node using Google Drive back end – 5 minute example
Another quick demo of data sharing Here’s a challenge that shares the data in a spreadsheet with node, set up end to end in less than 5 minutes. This example is almost exactly the same […]
Apps Script
The nodejs Drive API, service account impersonation and async iterators
This is part of the series on sharing data between Apps Script and Node on various backends, Apps script library with plugins for multiple backend cache platforms but the Drive API introduces a number of tricky […]
Apps Script
Sharing data between Apps Script and Node using Google Cloud Storage (GCS) back end – 5 minute example
Another quick demo of data sharing There are many ways to accomplish this of course, but using Caching across multiple Apps Script and Node projects using a selection of back end platforms is pretty fast to […]
Apps Script
Sharing data between Apps Script and Node using Github back end – 5 minute example
Quick demo of data sharing There are many ways to accomplish this of course, but using Caching across multiple Apps Script and Node projects using a selection of back end platforms is pretty fast to set […]
Apps Script
Caching across multiple Apps Script and Node projects using a selection of back end platforms
Motivation I’ve always been interested in ways to get multiple projects in Apps Script sharing data more easily and in a more standard way, independently of whatever platform is being used to host the data […]
Apps Script
Searching and cataloging Apps Script projects on Github
In Every Google Apps Script project on Github visualized I demonstrated an app that could be used to explore what every Apps Script developer who has shared their code is working on. It can be used […]
Google Cloud Platform
FTP server on Kubernetes with cloud storage and pubsub
Getting an FTP server running on Kubernetes is a little tricky. The FTP service uses multiple ports in its negotiation and you need to make sure that the conversation always connects to the same Kubernetes […]
Databases
Using a service account with Firebase in NodeJs
Here’s how to set up a service account to access your firebase data base in admin mode. It’s quite disjointed in the docs, so here it is from start to finish. The console Just as […]
Google Cloud Platform
Getting a simple app running on Kubernetes
This is a part of the series of posts on Getting memcache up and running on Kubernetes which explained how to create your first cluster and Installing memcache with Kubernetes which installed some memcache instances on your cluster and Exposing […]
Google Cloud Platform
Creating a test app for memcache on Kubernetes
This is a part of the series of posts on Getting memcache up and running on Kubernetes which explained how to create your first cluster and Installing memcache with Kubernetes which installed some memcache instances […]
Google Cloud Platform
Building your App ready for Kubernetes deployment
This is a step in Getting an API running in Kubernetes Building your demo app Before getting into the Kubernetes configuration, the first step is to create a demo App, which will run on Node/Express. […]
Google Cloud Platform
Your own free linux VM
Now that Apps Script is opening up with a new CLI tool and API to allow you to use your own development tool change, there’s more reason than ever to start using NodeJs as part of your […]
General JavaScript techniques
Calculating image dimensions in server side apps script
I have a Node project that looks at Google Cloud storage and figures out the dimensions of images stored there. This is handy for an API to be able to serve up the right one […]
General JavaScript techniques
Databases
Firebase service accounts on Node.js
Here’s how to set up a service account to access your firebase data base in admin mode. It’s quite disjointed in the docs, so here it is from start to finish. The console Just as […]
Full Stack
Promise routing in Express
When using the Express router, the usual sequence of events is to detect the route, examine the request, perform some action, then send back the response. It’s quite likely that the action to be performed […]
APIS and techniques
Making sense of OCR – Google Vision
In the project I’m using for illustrating some of the capabilities of GCP, I need to make sense of a variety of documents, some very complex and some less so. The basic problem though is that there […]
Cloud
Service account impersonation for Google APIS with Nodejs client
If you want to write to sheets from a server side Node app, you can use a service account, but it’s a little tricky as you have to authorize that service account to be able […]
Cloud Functions
Firebase cloud functions
This is one of a series of articles about Going serverless with Firebase What are Cloud functions There are both Google and Firebase branded cloud functions. They are probably the same thing under the hood, but […]
APIS and techniques
Apollo graphql backend
This collection of articles deal with getting Graphql/Apollo server up and running on Node Rate limit handling A deep dive into rate-limiting with the Vimeo API
Apps Script & Java Script
Node focus on Blogger posts
In Node focus explorer without excel I showed a d3.js app that could navigate a google site using tags and nodes. This was actually pretty generalized, so it was a minor modification to add blogger post navigation capability also. Again we’ll […]
Microsoft Office & VBA
Regex, scraping and visualizing
Normally I’d want to use the Rest to Excel library to get data into Excel, but sometimes you have to resort to web scraping. My preferred route is to do something in scraperwiki, then use a rest query […]
Apps Script & Java Script
A gigantic pub crawl
I wanted to put together a gigantic demo to show (and test) the push notification capability of Ephemeral Exchange to orchestrate many things across many platforms. We’ll be linking up all these things, with the orchestration […]
Cloud Functions
Using Google Maps API with Google cloud functions
If you are thinking about using Google Cloud functions (and you should), you may be wondering how to use things like Google Maps in the context of cloud functions. Well, cloud functions allow you to run Node.js […]
Docker
Deploying docker containers to appengine
For my Ephemeral Exchange project I wanted to containerize as much as possible, as I wan’t sure where I was eventually going to host it, and containerizing meant it would be easy to put pretty much anywhere. […]
Docker
Docker, appengine and the flexible environment
Appengine When App engine first came out, you were stuck with PHP, Python or Java – none of which are my goto solutions. Then Go came along, but shortly afterwards it was announced that app […]
D3
D3 force from GAS Site
In Site data to sheets i showed how to get basic data from Analyzing site content with GAS into Excel and Google Sheets. To be able to use Excel tables to d3.js Force diagram, we are going to focus on […]
Drive
Visualizing Apps Script dependencies
dependencyForce If you use a lot of libraries, sometimes things get a bit messy. You delete an old version to clean up and suddenly notice a few days later that things stop working because it’s […]
Apps Script & Java Script
d3 concept browser
In Node focus on Blogger posts and Node focus explorer without excel I showed how you might browse sites by connected topic, rather than hierarchically. This used a D3.js force diagram as the navigation tool. I got to thinking […]
Apps Script & Java Script
Node focus explorer without excel
Up till now we’ve been considering a solution for Focus node explorer with d3.js that leverages massaging the data from Analyzing site content with GAS using the stuff we already had from d3.js. That solution also means that you can […]
Full Stack
React, Redux, Redis, Material-UI and Firebase
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 interact.. […]