Re:How to use a Google Spreadsheet as a database
by donpinkus on Tuesday March 24, 2015 @03:23PM
(#9258828)
Thanks! Yea I was trying to use Google Spreadsheet, getting annoyed with the JSONP and the goofy way they returned their JSON, so figured I'd just wrap it in something easier to use...
What "availability issues" did you run into? I haven't noticed any with my sheets yet
Re:How to use a Google Spreadsheet as a database
by justincormack on Tuesday March 24, 2015 @04:23PM
(#9259208)
I run a cache in front of mine. It is usually available, but can be slow.
Re:How to use a Google Spreadsheet as a database
by mooreds on Tuesday March 24, 2015 @05:06PM
(#9259496)
Just the spreadsheet data being intermittently down, and of course, impossible to troubleshoot. We ran processes against it fairly often, and even had it proxied to some mobile devices.
Re:How to use a Google Spreadsheet as a database
by bduerst on Tuesday March 24, 2015 @05:20PM
(#9259586)
Same here!
We went from using Spreadsheets to using our own flat files on Drive, but the API service would throw random rejection errors for both.
Long story short, we learned that you should not try to use Drive or Google docs as a program database. It's designed first and foremost for users.
Re:How to use a Google Spreadsheet as a database
by jontro on Tuesday March 24, 2015 @05:56PM
(#9259781)
I was looking for the google spreadsheets api earlier today and I noticed it has not been migrated away from GData yet. I wonder why this is not getting any love
https://code.google.com/p/gdata-java-client/ <--- Spreadsheets api is one of the three apis still alive out of all gdata apis
Re:How to use a Google Spreadsheet as a database
by eddyparkinson on Thursday March 26, 2015 @03:38AM
(#9268221)
availability:
you need a retry. See http://stackoverflow.com/questions/22099780/unable-to-comple...
How does blockspring deal with Google Spreadsheet availability issues? I remember the spreadsheet not always being available.