DEV Community

Discussion on: How we killed project with NoSQL

Collapse
 
rodiongork profile image
Rodion Gorkovenko

that scalable strong schema graph db offers all the advantages of RDBMS

I'm afraid this is not quite correct. Graph DBs give some specific advantage - "graph" queries. It is hard or impossible to do with normal SQL (popular interview question about some Oracle feature I think).

But there are other types of queries (this is mostly about certain joins) which are really hard to simulate on graph database. We made some simple substitution for some of them and did "manual join" (extracting data and doing this in code) for others.

Regretfully I'm not really sage about Orient - as you probably noticed this situation was over 5 years ago. Orient had turbulent times since then - but recently it somewhat rectified.

As about "schema-less" - note that nowadays RDBMS can store JSON data and operate on their fields. Which really makes them good even without schema :)