desktop liberation
Follow
Find
16.6K views | +0 today
desktop liberation
Your new post is loading...
Your new post is loading...
Scooped by brucemcpherson
Scoop.it!

Parse.com as a substitute for ScriptDB in Google Apps Script

Parse.com as a substitute for ScriptDB in Google Apps Script | desktop liberation | Scoop.it
brucemcpherson's insight:

As you will know by now, ScriptDB is now deprecated. A year or so ago, I published some articles on alternatives to ScriptDB on the desktop liberation site, one of which was Parse.com. This has turned out to be one of the most popular topics. Here's how to get started and get your data off scriptDB.

more...
No comment yet.
Scooped by brucemcpherson
Scoop.it!

Rasenball World Cup 2014 Visualization

Rasenball World Cup 2014 Visualization | desktop liberation | Scoop.it
Visualization for the World Championship (Amazing #html5 #D3.js web/mobile application - Everything you need to know about the #2014 #FIFA World Cup http://t.co/jv7HRTzw2X)...
brucemcpherson's insight:

I'm not interested in football, but this is a great viz.

more...
No comment yet.
Scooped by brucemcpherson
Scoop.it!

Flattening and unflattening objects to spreadsheets - Desktop Liberation

Flattening and unflattening objects to spreadsheets - Desktop Liberation | desktop liberation | Scoop.it

here's how to flatten and unflatten JavaScript objects so they fit in a Google Spreadsheet

more...
No comment yet.
Scooped by brucemcpherson
Scoop.it!

Comment on Hacking the Google Trends API by curious

Comment on Hacking the Google Trends API by curious | desktop liberation | Scoop.it
Hi There.
Great article.
I am looking to analyze as much details I can get for the hot trending topics on the internet (google, Twitter, FB, Bing) etc. As much analytics as I can get would be awesome.
more...
No comment yet.
Scooped by brucemcpherson
Scoop.it!

Using crossfilter with Google Apps Script - Desktop Liberation

Using crossfilter with Google Apps Script - Desktop Liberation | desktop liberation | Scoop.it

crossfilter.js is a great library for playing around with big lumps of data. Here's a GAS library with crossfilter

brucemcpherson's insight:

if you like d3.js, you'll like crossfilter

more...
No comment yet.
Rescooped by brucemcpherson from Search engine optimization : SEO
Scoop.it!

Onsite SEO Cheat Sheet

Onsite SEO Cheat Sheet | desktop liberation | Scoop.it
Onsite SEO Cheat Sheet from colinbancmedia. For web designers, developers and SEOs that want to check if a website is search engine friendly.

Via Veille digitale
more...
No comment yet.
Scooped by brucemcpherson
Scoop.it!

Google Releases Updated Standalone Apps for Docs, Sheets, and Slides - Droid Life

Google Releases Updated Standalone Apps for Docs, Sheets, and Slides - Droid Life | desktop liberation | Scoop.it
Google Releases Updated Standalone Apps for Docs, Sheets, and Slides Droid Life While Google Drive is a centralized hub for storing and editing your documents in the cloud, Google wanted to make it easier for users to access specific types of...
brucemcpherson's insight:

at last...

more...
No comment yet.
Scooped by brucemcpherson
Scoop.it!

db access to a variety of databases from Excel - Desktop Liberation

db access to a variety of databases from Excel - Desktop Liberation | desktop liberation | Scoop.it

google apps script can act as a router to various databases. Here's how to use it directly from Excel. 

brucemcpherson's insight:

Here's how to create/read/write/quiery/update/delete a variety of cloud based datastores directly from Excel via Google Apps Script. So far implemented Fusion, Orchestrate.io, Google ScriptDb, Google Sheets, Parse.com, Google Drive (stored as a JSON file). Let me know any others of interest.

more...
No comment yet.
Scooped by brucemcpherson
Scoop.it!

Copying data between various drivers - Desktop Liberation

Copying data between various drivers - Desktop Liberation | desktop liberation | Scoop.it
Liberate Excel data from the desktop
brucemcpherson's insight:

Here's how to copy tables between various backend databases in Google Apps Script in a few lines of code.

more...
No comment yet.
Scooped by brucemcpherson
Scoop.it!

pollHandler app and library - Desktop Liberation

pollHandler app and library - Desktop Liberation | desktop liberation | Scoop.it

Polling app based on Google Apps Script

brucemcpherson's insight:

Here's the all you need for a simple Poll app based on a Google Apps Script webapp handling a parse.com database, Google Charts and a javascript client.

more...
No comment yet.
Scooped by brucemcpherson
Scoop.it!

Database caching with Google Apps Script

Database caching with Google Apps Script | desktop liberation | Scoop.it

Using Google CacheService can make a great difference in perceived database performance. Here's an underlying database independent library you can use to make keys data driven and systematic

more...
No comment yet.
Scooped by brucemcpherson
Scoop.it!

SunCalc - Apps Script library and web apps version

SunCalc -  Apps Script library and web apps version | desktop liberation | Scoop.it

Suncalc Google Apps Script library and webapp.

brucemcpherson's insight:

Here's a Google Apps Script version of SunCalc. There's a  library to include in projects, and a  webapp to provide rest query responses. It calculates things like sunrise, sunset and so on given a location and a date. Created from Vladimir Agafonkin's https://github.com/mourner/suncalc.

more...
No comment yet.
Scooped by brucemcpherson
Scoop.it!

More Apps Script APIs and Features - Google Apps Developer Blog

More Apps Script APIs and Features - Google Apps Developer Blog | desktop liberation | Scoop.it
brucemcpherson's insight:

lots of new cool stuff in google apps script...

more...
No comment yet.
Scooped by brucemcpherson
Scoop.it!

Google's Quantum Computing Playground turns your PC into a quantum computer - ExtremeTech

Google's Quantum Computing Playground turns your PC into a quantum computer - ExtremeTech | desktop liberation | Scoop.it
ExtremeTech
Google's Quantum Computing Playground turns your PC into a quantum computer
ExtremeTech
... not quite: You can simulate a quantum computer on your PC by running the Quantum Computing Playground web app for Chrome.
more...
No comment yet.
Scooped by brucemcpherson
Scoop.it!

APIs.io and APIs.json Launched at Gluecon to Make API Discoverability More Like Search

APIs.io and APIs.json Launched at Gluecon to Make API Discoverability More Like Search | desktop liberation | Scoop.it
A new API Discoverability search engine and a robots.txt type-format have been launched today at Gluecon.
brucemcpherson's insight:

I hope this takes off .. discoverable APIS will be a defining feature of the future web.

more...
No comment yet.
Rescooped by brucemcpherson from Google Apps Script
Scoop.it!

Integrating import.io with Google Apps Script

An introduction into how Google Apps Script can be used with the import.io web data extraction service.


Via Martin Hawksey
more...
Martin Hawksey's curator insight, May 22, 2014 9:23 AM

This post has resulted in a importio client library opening the way for more easy integrations http://support.import.io/knowledgebase/articles/367423

Scooped by brucemcpherson
Scoop.it!

Eurovision results with d3.js, crossfilter and dc.js - interactively explore the voting behavior

Eurovision results with d3.js, crossfilter and dc.js - interactively explore the voting behavior | desktop liberation | Scoop.it

Here's an interactive visualization mixing up various technologies, using the historical voting data from Eurovision

brucemcpherson's insight:

Explore the political voting behavior between countries participating in the Eurovision Song contest over the years with this interactive visualization

more...
No comment yet.
Scooped by brucemcpherson
Scoop.it!

Get Data From Google Docs - Desktop Liberation

Get Data From Google Docs - Desktop Liberation | desktop liberation | Scoop.it

I had to revamp Google Sheets to Excel importing since the new Sheets schema has changed a bit. If you use this, take a look at the new version

more...
No comment yet.
Scooped by brucemcpherson
Scoop.it!

Universal analytics for checking co-operating processes - Desktop Liberation

Universal analytics for checking co-operating processes - Desktop Liberation | desktop liberation | Scoop.it

This shows how to use real time analytics to track the progress of a VBA process and the Google Apps Script libraries it kicks off to update a series of back end databases on its behalf.

brucemcpherson's insight:

 The short video is extremely boring, but the capability to track things happening in real time is really nice when developing these kind of distributed integrations.

more...
No comment yet.
Scooped by brucemcpherson
Scoop.it!

Dbabstraction

Here's how to abstract database access in Google Apps Script so you can use multiple back ends with the same code.
brucemcpherson's insight:

Backends supported so far - Sheets, Fusion, Orchestrate.io, ScriptDb, parse.com, Drive

more...
No comment yet.
Scooped by brucemcpherson
Scoop.it!

Accessing Google Sheets directly from Excel - Desktop Liberation

Accessing Google Sheets directly from Excel - Desktop Liberation | desktop liberation | Scoop.it
Here's another app built with the DataHandler. This time it's actually a VBA app that accesses Google Sheets (and any other database for which there is a driver) via the DataHandler REST API Using this you can read, write and query Google Sheets directly from your VBA code.  
brucemcpherson's insight:

Using this you can read, write and query Google Sheets directly from your VBA code.  

more...
No comment yet.
Scooped by brucemcpherson
Scoop.it!

Database abstraction with google apps script - Desktop Liberation

Database abstraction with google apps script - Desktop Liberation | desktop liberation | Scoop.it

with drivers for parse.com, scriptdb and sheets - more on the way.

brucemcpherson's insight:

Sometimes you start with a particular database, or a spreadsheet, then you decide to use something else, and you have to refactor all your code. This is an early version of a Google Apps Script handler for database abstraction (with of course a heavy focus on Google options), to try to avoid some of that pain. 

more...
No comment yet.
Scooped by brucemcpherson
Scoop.it!

Tutorials — Scott Murray — alignedleft

Data visualization, generative art, and tutorials by Scott Murray, code artist.
brucemcpherson's insight:

if you are just getting started with d3.js, or even checking it out, this is a very accessible few pages.

more...
No comment yet.
Scooped by brucemcpherson
Scoop.it!

I've just been recognised as a Google Developer Expert

 learned last week that I had been bestowed the honor of membership of the Google Developer Experts (GDE) program.


It's a great feeling to have your work recognised in this way, even though I do feel a little out of place in the company of the august group who make up the current GDE community. GDEs are a small, but enthusiastic group who share a passion for the family of Google APIs and products, and give generously of their time to share their knowledge and ideas with others.

When I started toying with Google Apps Script a couple of years ago I never imagined it would develop such great capability - if you are not familiar with the new add-ons, for example, take a look to see just how far it has come.

I'm planning to continue to search out interesting (and even useful) things to do with Apps Script and other APIS, and I hope you will continue to find this blog and related site, and the various other channels of some help in your journey to the cloud.

more...
No comment yet.