Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

Use a Google Spreadsheet as your JSON backend

coderwall.com

Post reply on HN
Print view View original

61–69 of 69 posts

Re: Use a Google Spreadsheet as your JSON backend

#61

Post by _nate_ »

BonoboBoner wrote: post #54
nirvanatikku wrote: post #9

..FWIW, for those of you who haven't been enlightened with the power that Google Apps Script[1] offers yet, be sure to check it out: http://script.google.com . Layered on top of Spreadsheets, this pair takes prototyping to a whole new level. [1] https://developers.google.com/apps-script/

VBA in the cloud?

I've actually used an excel doc as a backend, which wrote json to a server for an app to consume. And honestly, I would do it again over using a google doc.

Re: Use a Google Spreadsheet as your JSON backend

#62

Post by theg2 »

I ended up building this into our data warehouse system as managing my own UI for a KVP data store became a nightmare with rapidly changing requirements. It's in PHP but allows reporters and producers to enter their data in a spreadsheet and then allows us to publish it out to JSON for use in D3 or leaflet.

It's greatly sped up our process for visualization.

Re: Use a Google Spreadsheet as your JSON backend

#64

Post by theg2 »

walshemj wrote: post #63

Sorry if you cant put together a basic back end for your app in mysql, Berkly DB or if you need to use json mongodb - you should stick to the day job at MacDonalds

Yes, because why use existing tools that end users are familiar with when you can be a pretentious jerk about it?

Re: Use a Google Spreadsheet as your JSON backend

#65

Post by tsieling »

We used this strategy on a small vendor database for a local nonprofit street newspaper when we built a vendor locater web app for them. The non-technical staff can update vendor names, availability, photos (by URL) and locations, which we then pull from to populate a map-driven search. It worked really well and saved hours of work building a custom CMS.

The app is at http://find.megaphonemagazine.com (best viewed on a smartphone) and the code is open source at https://github.com/denimandsteel/megaphone. Case study is at http://denimandsteel.com/work/megaphone-finder/

Re: Use a Google Spreadsheet as your JSON backend

#67

Post by FromStoneage »

avgp wrote: post #47
FromStoneage wrote: post #39

you're stealing my idea ! http://www.nextofwindows.com/how-to-use-google-doc-spreadshe...

Hey Jonathan, I am the person who wrote the coderwall tip and I am sorry to hear that you feel like this. Especially because I did read your post a while ago, forgot about it and lost the link. I then just searched the GData docs and it's a documented feature. https://developers.google.com/gdata/samples/spreadsheet_samp... so I just spread something lesser known and didn't mean to "steal" anything.

I'd appreciate it if you can provide some credit :) Thanks

Re: Use a Google Spreadsheet as your JSON backend

#68

Post by genericacct »

theg2 wrote: post #66
genericacct wrote: post #58

In this thread: people who don't know they should be using ethercalc =)

How about you explain how this is better than Google docs? Not requiring a Google account is nice but what else does it do better?

It's open source and you can run anywhere from a raspberry pi to sun clusters, for one. For free. And your data remains yours and is not delivered to the NSA..

Re: Use a Google Spreadsheet as your JSON backend

#69

Post by genericacct »

theg2 wrote: post #66
genericacct wrote: post #58

In this thread: people who don't know they should be using ethercalc =)

How about you explain how this is better than Google docs? Not requiring a Google account is nice but what else does it do better?

Oh and it loads 20 megs of CSVs without skipping a beat. try that with google docs..
Post reply on HN