Parse
cParseCom examples
In parse.com – nosql database for VBA, I described how to use cParseCom to be able to use parse.com directly from VBA. You can find the implementation details here parse.com api class for VBA Here’s a few […]
parse
Apps Script & Java Script
cParseCom implementation
I use scriptDB a lot , both with Google Apps Script and from other sources, including VBA, and in this blog post, I compare parse.com performance with script DB. One of the things that Parse.com has going […]
Apps Script & Java Script
Some simple examples
Because the GAS API is so similar to parse.com – nosql database for VBA, you may want to read that too, which has similar examples. Note that virtually all methods can be chained leading to pretty […]
Apps Script & Java Script
creating Parse Classes from Google Spreadsheets
Just as in parse.com – nosql database for VBA, you’ll probably want to load up some test data from a Google Spreadsheet to a Parse.com class. You’ll find some test data in this workbook – it’s same data […]
Apps Script & Java Script
Google Visualization API data
The source data colorTable we want to load to our parse.com database is currently in a Google Spreadsheet. With scriptDB, we can access it directly. However, to load data into parse we need to use the google visualization query […]
Parse
Query Limits on parse.com
The first problem we hit is the 1000 object limit on parse queries. Here’s how to get round it using jQuery promises. <!DOCTYPE HTML> <html> <head> <title></title> <link rel=”stylesheet” type=”text/css” href=”css/colortable.css”> <script src=”http://www.parsecdn.com/js/parse-1.2.2.min.js”></script> <script src=”js/colortable.js”></script> […]
Parse
Updating ScriptDB
Writing to parse.com was fairly complex, with all the asynchronicity and limiting. Writing the workbook to scriptDB should be much easier. We’ll use exactly the same approach as for Updating parse.com , namely get the data, get the existing […]
Parse
Updating parse.com
We’ve looked at Query Limits on parse.com and Google Visualization API data to prepare for loading the color table from Playing around with GAS color into parse.com. Now to load the data Using parse.save One of the constraints of parse is that it’s […]
Apps Script & Java Script
parse.com – noSQL database for GAS
Google Apps Script already has a noSQL database – scriptDB. I use it a lot, and have plenty of examples on this site. When I was developing parse.com api class for VBA , part of the motivation was […]
Microsoft Office & VBA
more complex parse API topics
We’ve dealt with parse.com – nosql database for VBA, cParseCom examples and shown the code at parse.com api class for VBA. Here’s a few selected topics to help you understand a lottle more about how […]
Parse
Common query code
Following on from Query parse.com from GAS, and Query scriptDB from GAS here’s the common code they each need to construct and compile the queries and results. colorschemer created by GitJsonApi https://github.com/brucemcpherson/colorschemer 0 forks. 4 stars. 0 open […]
Colors
Data from parse.com
Deprecated Parse.com has now become parseplatform.org and i will be investigating it at a later stage. I am however leaving the page as if as you may still find it useful. Contact me if you […]
Apps Script & Java Script
Color scheme explorer
In this section, we’ll build an application that pulls together many concepts already covered elsewhere on this site. You can run it standalone at xliberation.com, or below, embedded in this page The target application Pulling together Playing […]
Apps Script & Java Script
d3.js and parse mashup
This is an interesting d3.js and parse.com mashup of a number of topics covered on this site. The target is to build an app that Retrieves color scheme data from a parse.com database, much like […]
Cloud
Colorschemer API
Now that the data from Query parse.com from GAS, and Query scriptDB from GAS is populated in both parse.com and scriptDb, and we have the capability to Query parse.com from GAS and Query scriptDB from GAS, we can now pull […]
Microsoft Office & VBA
parse.com – nosql database for VBA
I use scriptDB a lot , both with Google Apps Script and from other sources, including VBA, and in this blog post, I compare parse.com performance with script DB. One of the things that Parse.com […]
Parse
parse.com api class for VBA
parse.com – nosql database for VBA, describes how to use this class to be able to use parse.com directly from VBA. Here’s the details of the implementation. List of functions and properties Can be found […]
Parse