CODEWITHSUNDEEP
mysqlpostgresql
Yeysides
Yeysides

Reputation: 1292

Relational database vs object-relational database

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?

Upvotes: 4

Views: 3064

Answers (1)

Matt Morgan
Matt Morgan

Reputation: 5303

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.

Upvotes: 4

Related Questions