Best data source when updating daily?

[Keith Trnka]

I'm generating an html file containing a GeoChart and the data every day.  It works fine when I'm able to copy files onto the webserver directly.

But I may be moving to an environment where I can't just copy files onto the webserver, so I'm thinking of having static code for the chart and pointing it to either Google spreadsheets or externally hosted Json maybe.  I've tried poking around with Python APIs for populating Google spreadsheets but that seems to require a hard-coded password.  I didn't see an OAuth option.  Is there an easier way to update the data from Python and point a static chart to it?

Thanks,

Keith

[asgallant]

Is using a database an option?

[Keith Trnka]

I'll have to check.  Can I use MySQL or similar as a data source?

--
You received this message because you are subscribed to a topic in the Google Groups "Google Visualization API" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/google-visualization-api/fBQY1bP36tw/unsubscribe.
To unsubscribe from this group and all its topics, send an email to google-visualizati...@googlegroups.com.
To post to this group, send email to google-visua...@googlegroups.com.
Visit this group at http://groups.google.com/group/google-visualization-api.
For more options, visit https://groups.google.com/groups/opt_out.

[asgallant]

Yes, you just need to have a server script that queries the database and outputs the data in the appropriate format.

On Tuesday, October 29, 2013 12:38:39 PM UTC-4, Keith Trnka wrote:

I'll have to check.  Can I use MySQL or similar as a data source?

On Tue, Oct 29, 2013 at 9:37 AM, asgallant <drew_g...@abtassoc.com> wrote:

Is using a database an option?

On Tuesday, October 29, 2013 12:31:12 PM UTC-4, Keith Trnka wrote:

I'm generating an html file containing a GeoChart and the data every day.  It works fine when I'm able to copy files onto the webserver directly.

But I may be moving to an environment where I can't just copy files onto the webserver, so I'm thinking of having static code for the chart and pointing it to either Google spreadsheets or externally hosted Json maybe.  I've tried poking around with Python APIs for populating Google spreadsheets but that seems to require a hard-coded password.  I didn't see an OAuth option.  Is there an easier way to update the data from Python and point a static chart to it?

Thanks,

Keith

--
You received this message because you are subscribed to a topic in the Google Groups "Google Visualization API" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/google-visualization-api/fBQY1bP36tw/unsubscribe.

To unsubscribe from this group and all its topics, send an email to google-visualization-api+unsub...@googlegroups.com.

[Keith Trnka]

Is there much difference from using fusion tables?  It seems like those are basically a Google-hosted DB.

To unsubscribe from this group and all its topics, send an email to google-visualizati...@googlegroups.com.

[asgallant]

I've never used Fusion Tables, so I can't comment on how they differ from a database like MySQL.  The Fusion Tables API changed since the Visualization API documentation was last updated, and it no longer offers a compatible data feed.  You can still query FT, but the query process is different and you have to parse the data into an appropriate format.

On Tuesday, October 29, 2013 1:57:52 PM UTC-4, Keith Trnka wrote:

Is there much difference from using fusion tables?  It seems like those are basically a Google-hosted DB.

On Tue, Oct 29, 2013 at 10:26 AM, asgallant <drew_g...@abtassoc.com> wrote:

Yes, you just need to have a server script that queries the database and outputs the data in the appropriate format.

On Tuesday, October 29, 2013 12:38:39 PM UTC-4, Keith Trnka wrote:

I'll have to check.  Can I use MySQL or similar as a data source?

On Tue, Oct 29, 2013 at 9:37 AM, asgallant <drew_g...@abtassoc.com> wrote:

Is using a database an option?

On Tuesday, October 29, 2013 12:31:12 PM UTC-4, Keith Trnka wrote:

I'm generating an html file containing a GeoChart and the data every day.  It works fine when I'm able to copy files onto the webserver directly.

But I may be moving to an environment where I can't just copy files onto the webserver, so I'm thinking of having static code for the chart and pointing it to either Google spreadsheets or externally hosted Json maybe.  I've tried poking around with Python APIs for populating Google spreadsheets but that seems to require a hard-coded password.  I didn't see an OAuth option.  Is there an easier way to update the data from Python and point a static chart to it?

Thanks,

Keith

--
You received this message because you are subscribed to a topic in the Google Groups "Google Visualization API" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/google-visualization-api/fBQY1bP36tw/unsubscribe.

To unsubscribe from this group and all its topics, send an email to google-visualization-api+unsubscr...@googlegroups.com.

To post to this group, send email to google-visua...@googlegroups.com.

Visit this group at http://groups.google.com/group/google-visualization-api.
For more options, visit https://groups.google.com/groups/opt_out.