11–20 of 77 posts
I'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
- http://blog.apps.npr.org/2014/04/23/how-we-built-borderland-...
- http://www.gamasutra.com/blogs/WillHankinson/20150323/239489...
What're the rate limits on Google Spreadsheet on update and read?
I haven't hit a limit yet and tested with 200 queries / minute.
Will update this comment when I find that out.
Where's the free, web based, easy to use database, the web version of MS Access?
I 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
I'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 s…
Where's the free, web based, easy to use database, the web version of MS Access?
I also wonder. It seems like the glaring hole in the Google Apps suite.
Even if I didn't make any money on the deal, at least I'd be able to have something better for tracking the progress of the cub scouts awards. It'd also let my wife and me set up the complex budget that we're trying to do right now in spreadsheets.
I bring this up with people who work for small businesses and they all recognize the pain point. Those that are old enough remember the good old days when you could put an Access file on a network share and then run your entire business out of it.
Earlier quoted context omitted.
I also wonder. It seems like the glaring hole in the Google Apps suite.
I've had this as my startup idea for at least four years now. I'd build a web-based database product that would fit in google apps with the intention of getting bought by google and integrated into google apps. Even if I didn't make any money on the deal, at least I'd be able to have something better for tracking the progress of the cub scouts awards. It'd also let my wife and me set up the complex budget that we're…
Where's the free, web based, easy to use database, the web version of MS Access?
# 1st) Using Google Spreadsheets as a CMS
In this case you'd store data in a Google Spreadsheet and retrieve the content before showing to the user. Probably it makes sense to put some durable caching in place so you can sync the cache offline and worry less about Google Spreadsheets API downtime, quotas or latency. In this scenario the app would only read data from the Spreadsheet and not write. It will probably not support writes consistently for anything more than a toy.
# 2nd) Use Google Drive to store user Data
The main difference here is that in this case it would make more sense to store the spreadsheet in the user account, not yours. You'd fetch the userData once he logs in your application. If this is the use case there are better things than writing spreadsheets to users Google Drive. There's actually a feature in Google Drive to store application data:
Earlier quoted context omitted.
I've had this as my startup idea for at least four years now. I'd build a web-based database product that would fit in google apps with the intention of getting bought by google and integrated into google apps. Even if I didn't make any money on the deal, at least I'd be able to have something better for tracking the progress of the cub scouts awards. It'd also let my wife and me set up the complex budget that we're…
If you're interested, I've wanted to work on this too. In particular, creating an online, PaaS database service so you can store and manipulate data via SQL queries without needing to setup and maintain (and share across machines) your own sql server. It's something I find myself wishing I had.