The LockService is sometimes misunderstood. It says this in the documentation: Does the lock apply to code fragments or the entire library ? I’ve noticed some discussions on Stackoverflow and elsewhere that the lock applies to a […]
Some information on quotas when using the DataStore back end in Database abstraction with google apps scriptThe library reference is Mj61W-201_t_zC9fJg1IzYiz3TLx7pV4j Dashboard If you are using the free tier for DataStore, you’ll run out of quota […]
It may be that I haven’t yet written a driver for a back end you want to use. I’m encouraging others to write a back end and submit it for others to use. It’s not […]
This is the the driver for DB.DATASTORE described in Database abstraction with google apps script The library reference is MPZF_EC6nOZFAjMRqCxEaUyz3TLx7pV4j This is a little more complicated that the other drivers, and in fact is made up […]
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 […]
Each driver typically has its own way of dealing with query constraints. A example of a constraint would be f1 < 2 and f2 >= 3. Since the data handler uses a query by example syntax, it’s […]
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 […]
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 […]
This is the the driver for DB.DATASTORE described in Database abstraction with google apps scriptThe library reference is MPZF_EC6nOZFAjMRqCxEaUyz3TLx7pV4j This tutorial references the the cDataHandler and cEzyOauth2, both of which have been superseded by cDbAbstraction and cGoa which are easier to […]
Why abstract anyway? In a number of articles on this site and elsewhere, I have covered topics such as Getting data from Outlook Address Lists into Excel , Serializing Excel data for input to any Google visualization, Excel Generate High […]
If you are abstracting the database provider, you can move up caching to the handler level. This will mean that we can use Google CacheService to cache queries before we even worry about which flavor of database […]
This is the abstraction to the specific drivers and to cache described in Database abstraction with google apps script The library reference is Mj61W-201_t_zC9fJg1IzYiz3TLx7pV4j Reference … under way The Code cDataHandler created by GitJsonApi https://github.com/brucemcpherson/cDataHandler 0 forks. […]
Parse.com When I wrote this, i made use of Parse.com that has now disappeared and become parseplatform. As such, my codes don’t work anymore. If you are familiar with parseplatform get in touch. × Dismiss […]
Parse.com 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 platform × Dismiss alert All code here is unprotected and free to […]
bruce mcpherson is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License. Based on a work at http://www.mcpher.com. Permissions beyond the scope of this license may be available at code use guidelines