Question as the title says. Of course, I already tried searching online, but did not find a definite answer yet. (The sources I checked imply that the terms are interchangeable, but do not state this explicitly.)
Also, if they are not the same, then what is exactly the difference?
Some thoughts from me:
- In theory, we could have a relational database, which is manipulated by some other language than SQL (and probably a couple instances do exist, at least at pet project level), but is there an example which is well-known and widely used in production as of today?
- I can't really imagine how the other way round (non-relational DB manipulated by SQL) would work, but maybe it is also possible? (The closest I can think of is querying a key-value DB with
NULL's for the fields that are missing. But what would happen e.g. to
JOIN's? So maybe a non-relational DB would be possible which works with a subset of SQL; would that still count as an SQL DB though?)