Using Google Spreadsheets as a Database in the Cloud

[buzznaveen]

is there a similar Google Spreadsheet API in java?

[Sylvan012]

I have no idea what Python is. All I want to do is pull specific cells of data from a spreadsheet onto a Web page. HOW DO I DO THIS? Is there a simple tutorial that just says "type this for your jQuery script to pull 'x' data from your spreadsheet"?!

[ohtonytony]

this api is overcomplicated for most cases, check gspread on github, it's simpler.

[xuoa]

Oh yeah! I'll give him enthusiasm containment props!

[VondaFononono]

Spreadsheets could be created as a Database too.

[coatsworthmark]

If you want to see more code for this, do a search for Andreas Kahler's blog (i can't post the url here). He has a great example which includes the authentication code that is not shown here.

[vdasg]

nhbn

[bvllets]

Dude probably gets mad pussy

[woodygar]

Can someone tell me whats in the demo module please

[CompTutts]

php example??

[IrrationalAgent]

"I also see that we got Galahad's favorite color wrong."

Awesome.

[coatsworthmark]

This tutorial is useless without showing what is in the demo module. You'd think the geniuses at Google would figure that out!

[mtoussieh]

The guy is too advanced for me. He goes straight into coding and doing geeky things I have no idea about, and I don't know how to even get started. Actually when I open the p/gdata etc. page I get it slightly different because I don't have all his documents saved up there and he just jumps into the next thing without explaining where I should click to open up his database thingy and it's more... encouraging... than it is teaching... but thanks!

[luinva]

My favorite is when he pauses to swallow :40

I know, I'm just being stupid. I love this.

[ipkeez]

@luinva hahahahahha

[meltray61]

Someone kill me now...I just want a database to track training in the cloud so my clients can access it. I c

ould NEVER do this mess.

[worldtechguru]

I almost fell asleep.. Thumbs up if tiredness came upon you while watching this video! And I'm a geek!

[fsl4faisal]

import demo

this is not working...?

[MrMulti]

Does anyone know how to do this in Ruby?

[josephavaughan]

It would be really nice if you could post the contents of demo, so that we could understand what demo.Client() does

[XxshadowxX132]

awesome!!!

[ashlovemira]

ca n this database link the iphone?

[1000japi]

@ashlovemira if you can get python to run on the iPhone :S

Otherwise youll have to use REST services to call the API from your server, which in turn fetches data from Gdocs.

[hydrofal78]

tnx a lot

[abar40]

is this support indexing?

[thebarak]

Yikes, a green on black command line window and mentions of knights. It's like 1980 all over again. I hope normal people will be able to use Google Spreadsheets as full-blown databases one day soon. I do, but mine are really just Google Spreadsheets with data in them, and everything in your command window looks like Martian to me. Luckily, Google takes care of business and I don't seem to need to do that.

[michaelkariv]

This is a very useful feature. My silver light Gantt editor written 2 years ago works with gdata on the back end using all that complexity that Jeff hides with text db.

Like krislyttle I would like to see SQL features - especially JOIN between "tables" ("worksheets"). Still, current state is very appreciated. Thanks Jeff

[DrewLeSueur2]

can we please see the demo class?

[dawmster]

man, why oh why didn't you show us HOW TO LOGIN.

Now I have to snoop around and try to figure what the hell did you do in the demo object...

Sheeet

[surfzion]

Really cool !!! this can be really useful, a free simple database on the web.

[krislyttle]

Nice. Would a relational-based DB with full SQL features (still built on top of spreadsheets) be next?

[greekmonstervt91]

this is so hard..i'm confused...what the hell is he talking about...

[gli7utubeo]

Why don't you add a rudimentary database offering to join Google docs and spreadsheets?

[beelerb]

Good video. That's a seriously cool and useful trick. I've been using importXML() and importfeed() but the built-in delay has sometimes been an issue. Being able to interactively push and pull data (some of the time) will be much more effect.

Thanks for the work.

[walktothebeach]

for links, please use a url shortener, like tinyurl or shrinkster.

have to give the presenter a K- for enthusiasm in delivery.

[360percent]

How about giving him an "Awesome" for containing his enthusiasm, as he presented an amazing new api. I would have geeked out and crapped my pants!

[utemkes]

3rd