scriptDB

Big arrays and scriptDB

Like most Google Services, there are various quotas that apply to scriptDb. One of these is the maximum object size. Here’s how to split up large arrays to help get round that. In this case, I’m not […]

No Picture
Apps Script & Java Script

scriptDb JavaScript api examples

The JavaScript client is very similar to A VBA API for scriptDB, so reading that will give you a more detailed flavor of what can be done. The implementation is very different though, and there are […]

Apps Script & Java Script

Testing the API

This is a ScriptDB API for JavaScript. The tests that are referred to in scriptDB API for JavaScript are implemented in https://storage.googleapis.com/toasty/t/gas/scriptdbapi.html. Code is below <!DOCTYPE html> <html> <head> <meta charset=”utf-8″ /> <title>scriptDB data input – ramblings.mcpher.com</title> <link […]

No Picture
Apps Script & Java Script

scriptdbcom implementation

Here is the javascript implementation for the scriptDB API. It needs jQuery. * methodType = “GET”; */ var dataType = “json”; if(!postData) { u += “&callback=?”; dataType = “jsonp”; } var d = $.Deferred(); var […]

Apps Script & Java Script

Authenticating scriptDb JavaScript API

As per this blog post, Google Apps Script does not support CORS (cross origin resource sharing) to allow access from cross domain client apps. The API uses JSONP for GET requests to get over this, but […]

Parse

cParseCom examples

In parse.com – nosql database for VBA, I described how to use cParseCom to be able to use parse.com directly from VBA. You can find the implementation details here parse.com api class for VBA Here’s a few […]

Apps Script & Java Script

cParseCom implementation

I use scriptDB a lot , both with Google Apps Script and from other sources, including VBA, and in this blog post, I  compare parse.com performance with script DB. One of the things that Parse.com has going […]

Apps Script & Java Script

Some simple examples

Because the GAS API is so similar to parse.com – nosql database for VBA, you may want to read that too, which has similar examples. Note that virtually all methods can be chained leading to pretty […]

Apps Script & Java Script

creating Parse Classes from Google Spreadsheets

Just as in parse.com – nosql database for VBA, you’ll probably want to load up some test data from a Google Spreadsheet to a Parse.com class.  You’ll find some test data in this workbook – it’s same data […]

CockroachDB

Secure CockroachDB and Kubernetes

In Getting cockroachDB running with Kubernetes I covered how to get cockroachdb going on Kubernetes, but that was in insecure mode, which is fine for playing around inside the Kubernetes cluster, but not good enough […]

Parse

Query Limits on parse.com

The first problem we hit is the 1000 object limit on parse queries. Here’s how to get round it using jQuery promises. <!DOCTYPE HTML> <html> <head> <title></title> <link rel=”stylesheet” type=”text/css” href=”css/colortable.css”> <script src=”http://www.parsecdn.com/js/parse-1.2.2.min.js”></script> <script src=”js/colortable.js”></script> […]

Parse

Updating ScriptDB

Writing to parse.com was fairly complex, with all the asynchronicity and limiting. Writing the workbook to scriptDB should be much easier. We’ll use exactly the same approach as for Updating parse.com , namely get the data, get the existing […]

Parse

Updating parse.com

We’ve looked at Query Limits on parse.com and Google Visualization API data to prepare for loading the color table from Playing around with GAS color into parse.com. Now to load the data Using parse.save One of the constraints of parse  is that it’s […]

firebase
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 […]

firebase
Databases

Firebase authentication with react and redux

Firebase authentication is replacing the Google Identity toolkit.  I’m not sure if I really understand the ‘firebasification’ of many of Google’s APIS. I think it’s  confusing whether you should use the Firebase version of things, or the underlying […]

Databases

Firebase auth for graphql clients

This’ll be quite a long post, or maybe a series of them, as auth is always complicated. Lets first of all set the scene. This is a VueJs client that needs access, both authenticated and […]

No Picture
Cloud Functions

Rate limiting – Firestore and Firebase cloud functions

This is one of a series of articles about Going serverless with Firebase. You many want to read about Firebase cloud functions and Custom domains and ssl with Firebase hosting before this article. Rate limiting So you’ve created your cloud […]

firebase
APIS and techniques

Custom domains and ssl with Firebase hosting

This is one of a series of articles about Going serverless with Firebase. You many want to read about Firebase cloud functions before this article.  Using custom domains  2 of the great things you get with Firebase hosting […]

No Picture
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 […]

No Picture
Firebase

Step by Step Guides

This site deals with some complex topics, and if you are trying to get started with something, it can be difficult to separate out the bare bones from the finished projects. In this section I’ll […]

Parse

Query parse.com from GAS

First up we’ll query the colortable  created in Updating parse.com, using the parse REST API. We can’t use the javaScript API in dome way from GAS, because it’s not caja compliant – if it were, we […]

From VBA to Google Apps Script

Generate an auto incrementing key with scriptDB

NOTE: ScriptDB is now deprecated. Please take a look at Database abstraction with google apps script for alternatives. Sometimes you need to create a unique identification for each object. ScriptDB automatically assigns a unique objectId for each object, so […]

Apps Script & Java Script

cScriptdbCom client

Here’s the  arguments to the cScriptDbCom class of A VBA API for scriptDB Here’s the VBA client code for A VBA API for scriptDB And the code for many of the examples mentioned for this topic For […]

From VBA to Google Apps Script

Trying out your new scriptDB environment

If you’ve followed Creating your own scriptDB environment we are ready to start accessing it from VBA. Registering authentication There are 2 things you need to do, both of which are one-off things. You may have done […]

scriptDB

Creating your own scriptDB environment

Here’s what you need. This is written from the perspective of A VBA API for scriptDB, but most of it also applies to scriptDB API for JavaScript Work your way through the material on A VBA API for […]

scriptDB

Handler for cScriptDbCom requests

The VBA API generates REST API requests from your VBA function calls, and needs a Google Apps Script handler to service those requests by communicating with the required scriptDB instance. You can have multiple handlers, […]

No Picture
scriptDB

Getting started with cScriptDbCom

First of all you need to Download cDataSet.xlsm and go to the scriptDBCom module, where you’ll find various examples. Readonly, no oAuth2. To get used to the API we’ll first of all use some of my test […]

scriptDB

Using data from multiple scriptDB

There are a number of examples on this site of one library being used to provide data to another script. You may want to do this for a number of reasons. The limit for a […]

scriptDB

Locking down scriptDB

One of the great strengths of scriptDB is also one of its weaknesses. It is easy to share amongst projects, but it’s hard to detect who is using it since Session.getActiveUser() only works within domains, […]

firebase
Databases

Use firebase instead of socket.io

In Ephemeral Exchange I wanted to create a push notification capability so that subscribing apps could be informed immediately a cache item had changed or expired without having to poll for changes. The back end for cache […]

No Picture
From VBA to Google Apps Script

Tracking activity with ScriptDB

NOTE: ScriptDB is now deprecated. Please take a look at Database abstraction with google apps script for alternatives. I leave this article here for interest.In Using scriptDB, I covered some usages of scriptDB,along with a method of siloing data […]

No Picture
Apps Script & Java Script

Hosting your public scriptdb

You will need a script to host the scriptdb that contains your public data. In the step by step guide, Delegation to Google Apps Script, you should have created a script, pubstuff and added the mcpher library. […]

No Picture
Databases

Graduate to a database

If you followed Do something useful with GAS in 5 minutes, you’ll already know how to use a spreadsheet as a database. You may want to move on to using a real database as a back […]

Apps Script & Java Script

parse.com – noSQL database for GAS

Google Apps Script already has a noSQL database – scriptDB. I use it a lot, and have plenty of examples on this site. When I was developing parse.com api class for VBA , part of the motivation was […]

Microsoft Office & VBA

more complex parse API topics

We’ve dealt with parse.com – nosql database for VBA, cParseCom examples and shown the code at parse.com api class for VBA. Here’s a few selected topics to help you understand a lottle more about how […]

Parse

Common query code

Following on from Query parse.com from GAS,  and Query scriptDB from GAS here’s the common code they each need to construct and compile the queries and results. colorschemer created by GitJsonApi https://github.com/brucemcpherson/colorschemer 0 forks. 4 stars. 0 open […]

No Picture
Apps Script & Java Script

Firebase JSON REST access library for Apps Script

The BigQuiz app uses Firebase for keep track of the question, category and game scores of individual players. In Firebase custom authentication with goa I showed how to use Goa to manage authentication for Firebase. This firebase access library works with […]

No Picture
Apps Script & Java Script

Firebase custom authentication with goa

The BigQuiz app uses Firebase for keep track of the question, category and game scores of individual players. In JSON web tokens I showed an example of how to authenticate and authorize when making a call to the Firebase JSON API. […]

No Picture
Colors

Data from parse.com

Deprecated Parse.com has now become parseplatform.org and i will be investigating it at a later stage. I am however leaving the page as if as you may still find it useful. Contact me if you […]

No Picture
Apps Script & Java Script

Color scheme explorer

In this section, we’ll build an application that pulls together many concepts already covered elsewhere on this site. You can run it standalone at xliberation.com, or below, embedded in this page  The target application Pulling together Playing […]

Microsoft Office & VBA

parse.com – nosql database for VBA

I use scriptDB a lot , both with Google Apps Script and from other sources, including VBA, and in this blog post, I compare parse.com performance with script DB. One of the things that Parse.com […]

Parse

parse.com api class for VBA

parse.com – nosql database for VBA, describes how to use this class to be able to use parse.com directly from VBA. Here’s the details of the implementation. List of functions and properties Can be found […]

Parse

Parse.com

Parse.com is a database in the cloud. Working with Parse, there are some similarities with scriptDB. […]

Microsoft Office & VBA

A VBA API for scriptDB

UPDATE parse.com as now been closed and moved to parseplatform.org. I will update the content of this page an move the back-end to this platformis text. I like scriptDB, but in many ways I prefer […]

scriptDB

Google Apps ScriptDB

NOTE: ScriptDB is now deprecated. Please take a look at Database abstraction with google apps script for alternatives. The versatile scriptDB scriptDB is a javaScript object database for Google Apps Script project. It is a very useful feature to […]

No Picture
Apps Script & Java Script

scriptDB API for JavaScript

We have CRUD natively to scriptDB from Google Apps Script, A VBA API for scriptDB gave us one for Excel – now here’s one for JavaScript. That means you can use the same noSQL database for all […]

No Picture
Databases

Use a spreadsheet as a database in 5 minutes

This tutorial will get you started with Database abstraction with google apps script and show you how to write a small app that uses a sheet as a database. Open do something in 5 with gas-1-use spreadsheet as […]

Cloud Functions

Going Serverless with Firebase

Ephemeral Exchange is a cross platform cache that allows you to share transient data across a range of platforms without the need for authentication, but by sharing access keys between participants. The code is open source, […]

No Picture
scriptDB

using Google Apps ScriptDB as a lockBox

In various posts and articles I’ve been exploring uses of the Google Apps scriptDB datastore. One of the things I’ve been mulling over is how to simplify the whole oAuth experience when dealing with REST queries that need […]

No Picture
Json

Executing SQL from Excel and Data Abstraction

Abstracting an Excel data source. In almost of all of the downloadable examples on the ramblings web site, I use a set of data abstraction classes to separate workbook data from its workbook location, and […]