Data abstraction

Relative performance

Some information on performance when using the DataStore back end in Database abstraction with google apps scriptThe library reference is  Mj61W-201_t_zC9fJg1IzYiz3TLx7pV4j   Comparing scriptDB, parse and datastore In Migrate data from scriptDb to Datastore I showed how to copy […]

Data abstraction

Back end performance linearity

Some information on performance of each of the back ends in Database abstraction with google apps script The library reference is   Mj61W-201_t_zC9fJg1IzYiz3TLx7pV4j Comparing linearity In Relative performance I covered performance of scriptDB versus Parse versus DataStore.  Overall, Parse […]

Data abstraction

Comparing all back ends performance

Some information on performance of each of the back ends in Database abstraction with google apps script The library reference is  Mj61W-201_t_zC9fJg1IzYiz3TLx7pV4j   Update – I’ve added Driver MongoLab since these original tests were made. For a more […]

Data abstraction

Get Data From Google Docs

There have been a number of changes to Google Docs over the years each of which has provided more ways to do things. The latest is the new Sheets API V4,which is by far the best […]

Data abstraction

Apps built with data abstraction

In Database abstraction with google apps script I introduced a library for separating data access from the database being used, using Google Apps Script as broker. The access into this was either via a library, or through DataHandler REST […]

Data abstraction

db access to a variety of databases from Excel

Here’s a VBA app that uses Database abstraction with google apps script via the DataHandler library. You need to download the latest version of the dbAbstraction.xlsm workbook from Downloads. Note that a Google Script Webapp is providing the gateway from your VBA […]

Data abstraction

Accessing Google Sheets directly from Excel

Here’s a VBA app that uses Database abstraction with google apps script via the DataHandler library. You need to download the latest version of the cDataSet.xlsm workbook from Downloads It’s made up of these components DataHandler REST API which uses the DataHandler and  the DriverSheet and Database […]

Data abstraction

pollHandler app and library

Here’s an app that uses Database abstraction with google apps script via the DataHandler library.  It’s made up of these components  DataHandler library, plus all of the known drivers. It can support any of these databases to store its data […]