Re:Google Spreadsheets and Python
by rickcnagy on Friday February 17, 2017 @11:17AM
(#13669309)
Having run an (internal) app that is deeply integrated with Google Sheets for about a year, I think that Sheets is good and bad. It's _extremely_ powerful for allowing business users to easily get access to and manipulate data manually. Downside is that it really struggles past a few thousand rows when you've got more than 20 or so columns. Definitely good for a quick and dirty way to expose data to internal users, but it essentially can't scale. Engineers need to be ready to move off of it if the system works.
[ Parent
| on HN ]
Re:Google Spreadsheets and Python
by startupdiscuss on Friday February 17, 2017 @11:30AM
(#13669439)
If anyone from Google is reading this: please add a database (yes, like a cloud version of MS ACCESS) in the Google Docs/Drive suite.
Has anyone looked at "Fusion Tables?"
A google search reveals that is what it is supposed to be.
Check out airtable.com for something like this. Great product, lots of use cases.
Re:Google Spreadsheets and Python
by micah_chatt on Friday February 17, 2017 @03:05PM
(#13671262)
Isn't that what Firebase is for?
They already have one its called CloudSQL
https://cloud.google.com/sql/
That's not part of the drive/docs suite.
Yep, this should be accessible to users. Someone needs to bridge that gap from spreadsheets to real apps. One click to convert your Spreadsheet into a database. Or hell, just silently migrate it when (NUMROWS + NUMCOLUMNS) > BIGNUMBER .
Honestly, if clippy suggested to excel users something similar, I'd be extremely happy.
Sheets integrates with BigQuery!
There's also ODBC in AppScript (although I haven't tested it to tell you how well it works).
(work on Google Cloud)
Something a la Microsoft Access? (but obviously integrated in their online suite)
I've found that it also chokes when you throw Google Apps Scripts at it; or at least it did when I was developing a mail merge app for a Real Estate friend. By "chokes" I mean the application frequently locked up, cells would stop responding and I had to constantly reload the page, in a spreadsheet with only a couple of hundred rows, and maybe 12 columns.
Re:Google Spreadsheets and Python
by domfletcher on Friday February 17, 2017 @11:46AM
(#13669592)
I had a lot of mileage avoiding row count actually in the sheet buy using an API to retrieve data directly when a user is interested in a particular record. Then the only think you need to keep in the sheet is an index which is lighter because (as far as I can tell) it's cell count that really affects performance.
I had the same experience. I had to write a layer to slice my data up and submit no more than 50 rows, and retry on connection timeouts. Very frustrating, and so weird that a global giant like Google releases an API that's so mediocre.
Re:Google Spreadsheets and Python
by DontGiveTwoFlux on Friday February 17, 2017 @12:32PM
(#13670042)
One issue I ran into quite a bit was timeouts.
I had a spreadsheet with a few hundred rows I was using to create Docs and send emails. I was running from scripts.google.com. Any operation running for longer than about five minutes would time out so I had to batch my work into smaller buckets and hit run a bunch of times.
hear hear! this was my experience too. I was ready to switch to using gsheets as my entire application UI layer when the scaling problems and desyncing started hitting me.
still fantastic for quick-and-dirty tools and prototypes though.