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 contents of the DB, update with any additions or modifications, delete nothing.

Using ScriptDB

I already have a silo class  for scriptDB partitioning - which would be kind of analogous to the parse Class, and caching  to abstract getting data from sheets- like the Google visualization data fetching , so the structure can be more or less the same. 

Here's the whole application - a whole lot simpler than the parse version. But it takes so long to run. I'll do some benchmarks of all the variations at the end of this, but as usual, I hit the dreaded "execution time exceeded", so I have to run it a couple of times to get all the rows done.


load data from Google Apps to scriptdb


Batching

I am using the batching built in to the silo class for scriptDB , and buffering to the same level as in the parse version. I haven't bothered throttling as it's not required for scriptDB.

For more on parse.com see Parse.com


For help and more information join our forum,follow the blog or follow me on twitter .

You want to learn Google Apps Script?

Learning Apps Script, (and transitioning from VBA) are covered comprehensively in my my book, Going Gas - from VBA to Apps script, All formats are available from O'ReillyAmazon and all good bookshops. You can also read a preview on O'Reilly

If you prefer Video style learning I also have two courses available. also published by O'Reilly.
Google Apps Script for Developers and Google Apps Script for Beginners.


For help and more information join our forumfollow the blogfollow me on twitter

Comments