How to use a Google Spreadsheet as a database
api.blockspring.com
How to use a Google Spreadsheet as a database
1–10 of 77 posts
Re: How to use a Google Spreadsheet as a database
#2I beat my head on APIs from Google spreadsheets, so good on ya!
How does blockspring deal with Google Spreadsheet availability issues? I remember the spreadsheet not always being available.
Re: How to use a Google Spreadsheet as a database
#3I beat my head on APIs from Google spreadsheets, so good on ya! How does blockspring deal with Google Spreadsheet availability issues? I remember the spreadsheet not always being available.
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
#4[deleted]
Re: How to use a Google Spreadsheet as a database
#5I've been wanting to use Drive as a db recently on an app I'm working on as cheaper/free data storage. That is, instead of hosting a db and storing user data there, I would store it on each user's google drive. I see it as a way to save costs by not worrying about the security of my databases, cost of space/uptime/traffic, etc. What are issues am I not thinking of?
Re: How to use a Google Spreadsheet as a database
#6What're the rate limits on Google Spreadsheet on update and read?
Re: How to use a Google Spreadsheet as a database
#7I'm shocked that using something like https://github.com/gimite/google-spreadsheet-ruby to, at the very least, let Google Spreadsheets as a proxy for a bare-bones CMS hasn't been more widespread
Re: How to use a Google Spreadsheet as a database
#8I've been wanting to use Drive as a db recently on an app I'm working on as cheaper/free data storage. That is, instead of hosting a db and storing user data there, I would store it on each user's google drive. I see it as a way to save costs by not worrying about the security of my databases, cost of space/uptime/traffic, etc. What are issues am I not thinking of?
It's an interesting idea - here are some issues to consider:
1. Joining data will be very slow. If you need to access 500 database to get the "comments" on a "post", you're going to have issues.
2. How will you change the database structure as you iterate?
3. Storage cost of data is so low, that by the time you would start paying for data, you would have greatly exceeded the capabilities of Google Sheets.
4. Google sheets are slower than databases - there are no indexes, keys, the data is not stored in a way meant for most db operations (selections, etc)
I'm sure theres more but these seem to be the biggest ones for me.
That said, you should definitely try it - it's an interesting project at the very least.
Re: How to use a Google Spreadsheet as a database
#9I'm shocked that using something like https://github.com/gimite/google-spreadsheet-ruby to, at the very least, let Google Spreadsheets as a proxy for a bare-bones CMS hasn't been more widespread
Yea seriously...
I thought of it since a buddy has some Tiki Bar that he wanted a site for, and I really didn't want to drop into WordPress or anything serious. Knew he could handle a spreadsheet.
Checkout http://www.tarbell.io/ - It's a CMS designed around google sheets. I think it's a bit of setup, but might be a solid solution.
Re: How to use a Google Spreadsheet as a database
#10Where's the free, web based, easy to use database, the web version of MS Access?