4 ms·
I don't think there's a SQL versus NoSQL battle, whatever that means. SQL refers to relational databases, which are databases using the "relational model" of r
by bad_user 15y ago
I don't think there's a SQL versus NoSQL battle, whatever that means.
SQL refers to relational databases, which are databases using the "relational model" of representing data: http://en.wikipedia.org/wiki/Relational_model http://en.wikipedia.org/wiki/Relational_model
This means that any SQL database is very flexible in regards to what you can store in it, not to mention that it is based on proved theory and battle-tested implementations of various features, like ACID.
But the relational model also breaks heavily when wanting to work with data structures that don't blend well -- like graph data. It also breaks down heavily when you want to spread your data across many servers. It is also not well suited to storing and querying billions of records -- sooner or later, your indexes are going to go beyond whatever storage / RAM capacity your servers have.
Btw, MySQL is a real RDBMS. Even if it lacks some features, it doesn't lack anything essential to calling it "relational" and talk about advantages or disadvantages of RDBMSs versus key-value stores or other NoSQL types.
- Devilboy 15y agoFacebook seems to be doing just fine with their graph data on SQL
- jjm 15y agoThere has been talk for sometime that they're MySql issues are crippling progress and development due to complexity of management and upkeep. http://gigaom.com/cloud/facebook-trapped-in-mysql-fate-worse-than-death/ http://gigaom.com/cloud/facebook-trapped-in-mysql-fate-worse...