Parse offers some additional cool stuff including
- Multiple platform API
- REST API
- Async, promises based methods.
- Cloud based coding
- Dashboard and data viewer
There are some complications though, especially with the free plan.
- Rate limited .. you need to throttle requests or they will fail
- Limit to query responses .. you have to work round it
Of course Parse.com makes an ideal cloud based nosql database for Excel. Here’s a VBA API, parse.com – nosql database for VBA
You may want to read about these other related database APIs implemented on this site before deciding if parse.com is right for you.
The data I’m going to use here is the one used in Looking up color table. This is about 10,000 rows so it should give us a decent base to play with. The application will look up the table for matching colors from a given color scheme.
First step is to take the data currently on Google Docs Spreadsheet and load it to both scriptDB and Parse.com
Querying the data
Now we can move on to the app itself. We are going to allow querying of data based on various parameters, return what we found in the DB and calculate the color properties of each item returned.
The color schemer explorer
Here’s a finished app that uses parse.com as its data repository
I’ve written a couple of APIS you can use to access Parse
- Color scheme explorer
- Colorschemer API
- Common query code
- d3.js and parse mashup
- Google Visualization API data
- parse.com - noSQL database for GAS
- parse.com - nosql database for VBA
- Query Limits on parse.com
- Query parse.com from GAS
- Query scriptDB from GAS
- Updating parse.com
- Updating ScriptDB