There's plenty of questions on SO about the differences between OO databases like MongoDB vs relational databases, but I can't find anything about the differences between a relational database like MySQL vs an object-relational database like PostgreSQL at a high level. I understand that these two particular databases have differing functionality respectively, but I don't really understand why something like MySQL that claims to be simply relational doesn't return the same formed data as an object-relational database like PostgreSQL. Some of what I read on other sources say it's what they return when queried that is different; is this true?
4
-
This a very general question. Why should different database be required to return the same formed data? Not sure of the context. For the most part SQL queries that don't deviate from the SQL standard will will return the same result.danblack– danblack2018-11-20 02:13:56 +00:00Commented Nov 20, 2018 at 2:13
-
Can you try to clarify the purpose of this differentiation? If you want comments on the accuracy of differences, be precise and quote references.danblack– danblack2018-11-20 02:15:30 +00:00Commented Nov 20, 2018 at 2:15
-
Who says that Postgres is an object relational database, and MySQL is not? Is there any real meaning here?Tim Biegeleisen– Tim Biegeleisen2018-11-20 02:20:22 +00:00Commented Nov 20, 2018 at 2:20
-
@TimBiegeleisen "PostgreSQL is a powerful, open source object-relational database system.." from the postgresl website. I want to know how that's different from just a relational database.Yeysides– Yeysides2018-11-20 02:30:58 +00:00Commented Nov 20, 2018 at 2:30
Add a comment
|
1 Answer
Maybe this entry from DBA Stackexchange would be helpful:
https://dba.stackexchange.com/questions/77340/how-to-understand-object-relational
In particular, this answer: https://dba.stackexchange.com/a/77344/111252
Essentially it describes built-in inheritance features of Postgres that are outside of the SQL standard. That seems to be the key difference.
