I disagree most on the schema victory to NoSQL (due to faster altering). They should instead reward SQL here for actually supporting complex schema. Ones with lots of tables connected by foreign keys to assure consistency.
Hey guys, this is a great overview, ESPECIALLY the MapReduce animation. Very nice. Question... The last slide was this really cool description of Cloud SQL combined with Datastore. BUT no talk about how it could be implemented. Are there any tools around this? How would one do it? Do you have a video on that? Thanks!
the weather api was private and undocumented. it was used by google to power igoogle's weather widget. Google is shuting down igoogle so the api stoped making sense. If you chose to use something that's not yours, not meant to be public and undocumented, it's your bad design decision. Don't blame anyone else.
bottom line is we're in the era of polyglot persistence and this requires both RDBMS and noSQL . Immaturity of noSQL is a concern and so is the hype and lack of standardization. As mentioned, even in multi-master asynch replication, ACID is not guaranteed unless you do 2-phase commit (RDBMS). Also, if your data is looking to grow more than few TB in range, you ought to look at keeping things that absolultely requires ACID and keep them in RDBMS or graph db or else, as explained by one of the cloudant architect, you can consider mutation (encapsulate data access through a REST resource) and consider the penalty for being loosely consisten and it's a business decision.
You might be able to find some open source tools (or use the JDO/JPA support in java to use other tools), but Google mainly provides APIs to both services that are accessible from the same environment (App Engine) on which application specific logic can be built.
Also, we had to export data to a text format (XML, cvs, etc). Again SQL dbs have that out of the box, so again I had to reinvent the wheel. Guess what? I didn't, I'm migrating the app to SQLite and NHibernate. So, NoSQL will not replace SQL (because the opposite has already happened a long time ago), they will work together. End of rant.
SQL vs NoSQL is like asking which do you prefer? Strawberry or Lasagna, I mean they're not mutually exclusive, they serve different purposes. Besides, what did we have between when secondary storage was invented (hard-disks) and SQL (read, relational dbs) was invented? The answer is logical. I say so because at my shop we were developing a database-centric application (CRUD stuff, customers, whatevers, whatever items and so forth) with an OODBMS and it sucked big time. Continues...
I dont understand why at 31:00 in the Greg's List App, they're saying SQL is actually good for In-Memory DBs and No-SQL or Datastore for Archived.. But I've always though its the other way around (MongoDb)
nodejs/express/sql-or-not is also great. I love python, but by running the same language on both ends, I can share share code modules between the server and the client using requirejs.
some of the people asking questions were stupid. "does it work with mysql?" uh, the point of this stuff is to move away from mysql. also the last guy who asked a question "oh i shouldn't mention the name" as if it's so important and anyone actually gives a crap. python/django/nosql(mongo) are the way of the future, folks. get with the times.
They mentioned that metadata queries can send transactions from the Datastore to CloudSQL, but how can they be sent from CloudSQL to the Datastore? Also, is it possible at all to send transactions from other database systems into the Datastore? I have a small local app using PostgreSQL and I want to see if it can be moved to Google App Engine.
My test project couldn't read the db, because it's another application! There was as issue with the namespaces being written to the db file (like appnamespace.classname != testappnamespace.classname), ok that was easy to manage. But there was this issue that there was no GOOD maintenance tool for the db (like Mgmt studio) and a guy said to me, "Well, just develop one and publish on codeproject or codeplex". Sure why not? Lolwut.
Of course they don't view their software as productive. The good thing about Google is that they venture into many things knowing that some will fail and others would work. They know that their "google slides" is not better than "microsoft powerpoint" and they don't demand their staff to religiously stick to it. Their staff can use whatever ways to work as long as they deliver the work. That is why they are one of the best company to work for.
I was being kind of sarcastic, also their main product seems to be ads/services not personal computers and as you well stated, programmers uses whatever makes them the most productive, chromebooks are not development machines, google operating systems are based on linux (android, chromebooks) there is no consumer 100% google os (as far as I know) like windows or osx, iseslc commentary is just non sense, that would make a *bit* sense if a microsoft guy used mac but even so is a matter of tastes and freedom
they use macs because google is about software that runs in any system. that's their moto, so using different platforms in their talks is only natural.
why does Linus use a MacBook Air to install SUSE Linux on it ? I'm not a Mac Fan, but face the truth: today it's quite one of the best hardware out there, so the "best" devs choose the "best" hardware. Nuff said :)
I disagree most on the schema victory to NoSQL (due to faster altering). They should instead reward SQL here for actually supporting complex schema. Ones with lots of tables connected by foreign keys to assure consistency.
SQL vs NoSQL vs That Excel Spreadsheet
Watching it 10 years later. Haven't seen a better explanation on sql vs nosql
Hey guys, this is a great overview, ESPECIALLY the MapReduce animation. Very nice. Question... The last slide was this really cool description of Cloud SQL combined with Datastore. BUT no talk about how it could be implemented. Are there any tools around this? How would one do it? Do you have a video on that? Thanks!
Thank you so much for including subtitles.
the weather api was private and undocumented. it was used by google to power igoogle's weather widget. Google is shuting down igoogle so the api stoped making sense. If you chose to use something that's not yours, not meant to be public and undocumented, it's your bad design decision. Don't blame anyone else.
More like google sql vs google nosql, not really helpful at all for understanding the underlying foundations
bottom line is we're in the era of polyglot persistence and this requires both RDBMS and noSQL . Immaturity of noSQL is a concern and so is the hype and lack of standardization. As mentioned, even in multi-master asynch replication, ACID is not guaranteed unless you do 2-phase commit (RDBMS). Also, if your data is looking to grow more than few TB in range, you ought to look at keeping things that absolultely requires ACID and keep them in RDBMS or graph db or else, as explained by one of the cloudant architect, you can consider mutation (encapsulate data access through a REST resource) and consider the penalty for being loosely consisten and it's a business decision.
working NoSqL solutions will get implement by RDBMS vendors anyway
Guy sounds like Lumpy Space Princess. I just want to hear him say, "No Finn! You just want me for my lumps!"
These guys are fantastic. And the debate is really helpful
You might be able to find some open source tools (or use the JDO/JPA support in java to use other tools), but Google mainly provides APIs to both services that are accessible from the same environment (App Engine) on which application specific logic can be built.
very good disambiguation, also with cloud sql, app engine seems a lot more usable as an PaaS
Also, we had to export data to a text format (XML, cvs, etc). Again SQL dbs have that out of the box, so again I had to reinvent the wheel. Guess what? I didn't, I'm migrating the app to SQLite and NHibernate. So, NoSQL will not replace SQL (because the opposite has already happened a long time ago), they will work together.
End of rant.
great presentation! you made a boring subject more interesting
SQL vs NoSQL is like asking which do you prefer? Strawberry or Lasagna, I mean they're not mutually exclusive, they serve different purposes. Besides, what did we have between when secondary storage was invented (hard-disks) and SQL (read, relational dbs) was invented? The answer is logical. I say so because at my shop we were developing a database-centric application (CRUD stuff, customers, whatevers, whatever items and so forth) with an OODBMS and it sucked big time. Continues...
I dont understand why at 31:00 in the Greg's List App, they're saying SQL is actually good for In-Memory DBs and No-SQL or Datastore for Archived.. But I've always though its the other way around (MongoDb)
Released for java in Version 1.7.0 - June 26, 2012 and in ndb for python a while back
nodejs/express/sql-or-not is also great. I love python, but by running the same language on both ends, I can share share code modules between the server and the client using requirejs.
some of the people asking questions were stupid. "does it work with mysql?" uh, the point of this stuff is to move away from mysql.
also the last guy who asked a question "oh i shouldn't mention the name" as if it's so important and anyone actually gives a crap.
python/django/nosql(mongo) are the way of the future, folks. get with the times.
filming the projector? It gives such a bootleg feel to the presentation and I find it very distracting
They mentioned that metadata queries can send transactions from the Datastore to CloudSQL, but how can they be sent from CloudSQL to the Datastore? Also, is it possible at all to send transactions from other database systems into the Datastore? I have a small local app using PostgreSQL and I want to see if it can be moved to Google App Engine.
"we just added support for OR in both Java and Python" at 6:48 .. are you sure?
Afaik OR operator is still not supported.
Very Nice presentation!
Whats the tool they mentioned that does the autogeneration of materialized views. Dont make me watch it all again..
i like the dark emphasis !
My test project couldn't read the db, because it's another application! There was as issue with the namespaces being written to the db file (like appnamespace.classname != testappnamespace.classname), ok that was easy to manage. But there was this issue that there was no GOOD maintenance tool for the db (like Mgmt studio) and a guy said to me, "Well, just develop one and publish on codeproject or codeplex". Sure why not? Lolwut.
Why did they use Macbook ? Why didn't they use their own Chrome OS device instead of Macbooks ?
A "quarry" language is what stone cutters use while at work.
Very nice lecture!
How can i get data from google app engine datastore in js or php for web application
DAFUQ? Mac on Google I/O?
can we store more than 1000 entities in datastore index in google sdk.....? please reply
where we at now?.. ismile... :)
Time to update!
9:16 Google employee using a Mac with Microsoft Powerpoint LOOOOOOOOOOOOL seriously?
llama99906
why wouldn't google employees use google software?
Wired Project
I don't see that as cool, I see that as evidence that Google doesn't view their own software as productive.
Of course they don't view their software as productive. The good thing about Google is that they venture into many things knowing that some will fail and others would work. They know that their "google slides" is not better than "microsoft powerpoint" and they don't demand their staff to religiously stick to it. Their staff can use whatever ways to work as long as they deliver the work. That is why they are one of the best company to work for.
wait, should they use a search engine to write their code and databases?
I was being kind of sarcastic, also their main product seems to be ads/services not personal computers and as you well stated, programmers uses whatever makes them the most productive, chromebooks are not development machines, google operating systems are based on linux (android, chromebooks) there is no consumer 100% google os (as far as I know) like windows or osx, iseslc commentary is just non sense, that would make a *bit* sense if a microsoft guy used mac but even so is a matter of tastes and freedom
they use macs because google is about software that runs in any system. that's their moto, so using different platforms in their talks is only natural.
is that a macbook I see?
So what about relations and constraints?
nice and useful talk.
why does Linus use a MacBook Air to install SUSE Linux on it ?
I'm not a Mac Fan, but face the truth: today it's quite one of the best hardware out there, so the "best" devs choose the "best" hardware. Nuff said :)
The hammy acting and those ridiculous t-shirts makes me feel like I'm watching a tv show for kid savants.
coincidentally resembles the dilemma of electricity when it had recently discovered. accesible information as bulbs .. ..
Oscar-worthy
The sound is kinda bad ?
Very informative. Thank you!
MySequel, guess it applies to MySQL now its in the Oracle eco-system.
30:40 "Greg's List" I LOLED
Cool story bro.
Thanks FOr the insight....
Corny as hell, but definitely informative and still somehow entertaining.
No records found.
Interesting and informative :D
OKAY WHERE'S MY SITE?
Eff-yea!
too good
Because developer's can't use chromebooks.
Amazingly! these google experts use Apple computers
The thinkpad is sexier
NoSQL , i am not familiar with it.
Sheldon and Leonard ... :D
nice presentation :)
noSQL guy knows stuff
2:28 It's always on. Aaand... Blackscreen.
One uses a thinkpad!
waste of computing power in my opinion, regarding the materialized view
yea! and the .net dude at the end :D *facepalm*
how come people goto a talk on new tech while actually want to stick with their old tech?
HAHA kinda corny but it was very informational. Thanks!
And power point! :-)
lol, great start.
It's echoeyyy!!! ... LOL smooth
lol this is great
Hadoop ftw
More like google sql vs google nosql
mac book? REALLY? B... please!
so what they say is we have a new shiny DB but the old one is better! :P haha good luck!
Steve Jobs laughs at you.
Steve Jobs is dead
use MAC on Google IO @@
Never seen views?
SELECT * FROM youtube WHERE kids_commenting = 0
null
Just cringey.
Hello World
What's Jesus got anything to do with it?! Taking the LORD's name in vain is SIN, do you even realize that?
ahhaha nice macbookpro
googlofiles
hhh
Se pasan de ridiculos , pero la presentacion estubo buena.
Since some kids can be mature, I'd say do something like this:
SELECT * FROM youtube WHERE account_age > 16 AND trolls = 0
hahaha they are using Macbook pro
boring!