Lately I’ve been doing a lot of posts to do with messing around with color. I’m using a selection of technologies such as scriptDB, Parse.com, jQuery promises, Google Apps Script, Google Spreadsheets, Google Visualization API and VBA to create a series of colorscheming apis and apps.
I found that neither parse.com nor scriptdb were ideal for bulk loading of data. I hit many problems to do with execution time, throttling and so on, but once the data was loaded, I wanted to compare how they performed for data retrieval.
There are a few things that are different that I have had to normalize to be able to abstract away the database layer. A few of them are
- Different query limits – I batch up queries to the same limit so that the number of actual accesses are comparable.
- Throttling – You need to throttle parse when using the API for write. However for this retrieval test, it doesn’t seem to cause any issues.
- You extend the parse object with your own class definition, but scriptDB doesn’t have that concept. Instead I use siloing to partition the scriptDB. I also write control information such as timestamps, in the same way as parse.com does.
More color schemes
I’m looking for more color schemes. If you would like to contribute a color scheme, all I need is the link to a Google Document with the scheme in it, like the colortable tab in this spreadsheet.
Here’s a live app built using many of the techniques described in this post. Enter a color code, try a different scheme or click on one of the palette colors to cause interaction with parse.com.
po.src = ‘https://apis.google.com/js/plusone.js’;
var s = document.getElementsByTagName(‘script’); s.parentNode.insertBefore(po, s);