News for hackers. Stuff that matters.
Re:Google Spreadsheets and Python by mixmastamyk on Friday February 17, 2017 @11:29AM (#13669425)
Interesting to choose this over simpler storage, such as sqlite. I suppose you get offsite backups for free.
Re:Google Spreadsheets and Python by gregorymichael on Friday February 17, 2017 @11:31AM (#13669447)
(author here) Main advantage in our usecase is getting the CUD interface for free.
Re:Google Spreadsheets and Python by imcoconut on Friday February 17, 2017 @11:53AM (#13669677)
This is a big advantage. Especially for smaller personal projects. I'm tracking various things I eat and do each day (exercise, art, read, etc.) as well as how I'm feeling (energy levels, sleep quality, etc.) in google spreadsheet. Sheets is great because I can edit from any device anywhere I am.

I like looking at simple things like time series' of what I'm doing, eating, and how I'm feeling and then exploring correlations, and regression betas/t-stats. Stuff that's just a little bit to onerous to do exclusively in sheets. At the moment, I have to download the spreadsheet then open with pandas in a jupyter notebook and then run everything. I'm definitely going to use the python api from now on - thanks a lot for writing this!

Next step is a simple python-based web dashboard to view all the results - but keep sheets for CUD instead of having to build a custom one and use sql/sqlite.

This really is super helpful - thanks again!

Re:Google Spreadsheets and Python by schwarrrtz on Friday February 17, 2017 @11:55AM (#13669706)
This is one of the reasons why I liked working with Parse; the data browser was very handy. This seems like a great alternative.
Re:Google Spreadsheets and Python by jwmoraes on Friday February 17, 2017 @12:12PM (#13669871)
For free ? Where would the python code run ?
Re:Google Spreadsheets and Python by andrewguenther on Friday February 17, 2017 @01:51PM (#13670677)
He said just the CUD part (Create Update Delete). The assumption is that your data can be entered manually through the Sheets UI and your code only needs to do the Read part.
Re:Google Spreadsheets and Python by mixmastamyk on Friday February 17, 2017 @03:10PM (#13671295)
How would the django/flask admin app compare?
Re:Google Spreadsheets and Python by vpribish on Friday February 17, 2017 @12:13PM (#13669885)
multi-user UI, sharing/access control already there, versioning of data, backups. those are all really nice to have