3 ms·
SQL = structured query language. That's all it is, a language to access and manipulate data and data structures. It comes in several variations, standards and d
by manigandham 9y ago
SQL = structured query language. That's all it is, a language to access and manipulate data and data structures. It comes in several variations, standards and dialects. Any system can implement (a form of) SQL as an interface, just as any system can also implement ACID guarantees around data access, but these are completely separate concepts. ACID isn't even mentioned on the SQL wiki page. [1]
Relational databases have a history of offering both in a single package, but there is no "true" SQL. There are also plenty of non-relational data stores that offer SQL and/or ACID guarantees so this limited generalization isn't accurate or useful.
"NoSQL" has no meaning other than originally describing systems that did not have any SQL access at all, usually due to different storage layers, distributed architectures, custom access protocols, and general immaturity around usage. A decade later, all of these systems have evolved and there's both convergence and specialization everywhere.
It would be far better to just talk about the actual type of database, and the interfaces and guarantees it provides, rather than marketing jargon like nosql.
1. https://en.wikipedia.org/wiki/SQL https://en.wikipedia.org/wiki/SQL