Seth Proctor for Dr.Dobb’s:
Increasingly, NewSQL systems are showing scale, schema flexibility, and ease
of use. Interestingly, many NoSQL and analytic systems are now putting
limited transactional support or richer query languages into their roadmaps
in a move to fill in the gaps around ACID and declarative programming. What
that means for the evolution of these systems is yet to be seen, but
clearly, the appeal of Codd’s model is as strong as ever 43 years later.
Spend a bit of time reading (really reading) the above paragraph—there are quite a few different concepts put together to make the point of the article.
SQL is indeed getting closer to the NoSQL databases, but mostly to Hadoop. I still stand by my thoughts in The premature return to SQL.
Most NoSQL databases already offer some limited ACID guarantees. And some flavors of transactions are supported or are being added. But only as long as the core principles can still be guaranteed or the trade-offs are made obvious and offered as clear choices to application developers.
The relational model stays with the relational databases. If some of its principles can be applied (e.g. data type integrity, optional schema enforcement), I see nothing wrong with supporting them. Good technical solutions know both what is needed and what is possible.
Original title and link: Do All Roads Lead Back to SQL? | Dr Dobb’s