Database abstraction with google apps scriptSome information on performance when using the DataStore back end in
The library reference is Mj61W-201_t_zC9fJg1IzYiz3TLx7pV4j
In Migrate data from scriptDb to Datastore I showed how to copy over data easily from scriptdb to datastore. The good thing about abstracting the database is that code is the same regardless of which database use you are using (once you've got the handle).
In this example I'm copying 1000 records from scriptDB to each of parse.com, datastore and parse.com. Note that each of these drivers using batching, so it's a fair enough comparison. For the purposes of the test, I've switched caching off in all cases. There are 3 operations performed - deleting 1000 records, adding 1000 records and querying them.
Note: since doing this test, I've improved batching on parse.com deletion - see Comparing all back ends performance for the improved parse.com performance numbers.
Here's the code
Although DataStore is quicker at deletion, using its JSON API makes it slower than Parse for both querying and writing. Unless you are planning to use DataStore for its extensive capabilities and scalability outside the simple scope of being a replacement for ScriptDB, it's hard to see why you wouldn't choose parse.com and avoid all those quota problems
Services > Desktop Liberation - the definitive resource for Google Apps Script and Microsoft Office automation > Database abstraction and Google Apps Script > Datastore driver >