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 […]
scriptDB
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 […]
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
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 […]
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, […]
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, […]
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 […]
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. […]
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 […]
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 […]
Apps Script & Java Script
Parse.com as a substitute for ScriptDB in Google Apps Script
As you will know by now, ScriptDB is now deprecated. A year or so ago, I published some articles on alternatives to ScriptDB on the desktop liberation site, one of which was Parse.com. This has turned […]
Apps Script & Java Script
More cool stuff you can do with Google Apps ScriptDb
If you are a regular on this blog or on the Excel Liberation site you’ll know that I’m a great fan of scriptDb – the cloud base noSql database for Google Apps Script – and like […]
Databases
Accessing parse.com and scriptDB noSQL databases from Excel
I figured it would be pretty nice to be able use one of the cloud based noSQL databases directly from VBA, so that I could share data easily between various platforms. On Excel Liberation , I […]
scriptDB
Validation and lookups using shared scriptDB lists
When the scriptable data validation feature in Google Apps Script came out recently, I started thinking about how we don’t really use the cloud based nature of Google Docs to its potential in a number […]
Databases
Using ScriptDB as a noSQL database for non-Google Apps Script clients
A long time back now, I showed how to publish and prettify source code and scriptdb contents using Google Apps Script. This allows you to embed code or data samples in blog posts and so […]
Google Authentication
Client oAuth calls using a Google Apps scriptDB lockbox
oAuth arghhh.. When I was looking around for a way to easily implement oAuth, and be able to use it from multiple scripts, or even languages (I was originally trying to figure out how to […]
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 […]
scriptDB
Using Google Apps ScriptDB to track activity
In messing around with scriptDB, I covered some usages of scriptDB when it first came out, along with a method of siloing data to keep it organized. Here’s a usage that might be useful for […]
scriptDB
Using Google Apps ScriptDB and the ContentService as an REST server
What no server? That’s right – you can serve up data from your Google Apps Script directly. In my post the other day, I showed how to use the Google Apps ScriptDB as a place to store […]
scriptDB
Playing around with the new Google Apps ScriptDB
I’m taking a break from d3.js and playing around with the new Apps Script DB. Those of you who read these posts or follow the rambling site may know that I have been building up a library […]