News for hackers. Stuff that matters.

A comment on Visualize data instantly with machine learning in Google Sheets. Parent comment

Re:Visualize data instantly with machine learning in Google ... by jboggan on Friday June 02, 2017 @02:09PM (#14472093)
I never had a problem with the Sheets V4 API that came out last May, how big of a database are you talking here?
[ Parent | on HN ]
Re:Visualize data instantly with machine learning in Google ... by teej on Friday June 02, 2017 @02:15PM (#14472140)
The add on doesn't talk to the reporting database directly, Google's Apps Script JDBC service doesn't support Postgres/Redshift. The add on gets data from a REST API. I then have an etl job that precalculates the aggregates and stashes them in Redis that the API then reads from.
[ Parent | on HN ]
Re:Visualize data instantly with machine learning in Google ... by pkpp1233 on Friday June 02, 2017 @04:41PM (#14473149)
See https://www.blockspring.com. The add-on has prebuilt connectors for both postgres and mysql. Can also build your own connectors https://open.blockspring.com/blocks/new.
[ Parent | on HN ]