3 ms·
I read object relational? Can someone enlighten me? Entity relational fine but what makes it object relational? Has someone flipped on the buzzword in the years
by oaiey 3y ago
I read object relational? Can someone enlighten me? Entity relational fine but what makes it object relational? Has someone flipped on the buzzword in the years I did not pay attention
- feike 3y agoPostgreSQL has used this term for decades! The oldest I can find is from 1998 (PostgreSQL 6.3), but it was probably in use even before. > Postgres offers substantial additional power by incorporating the following four additional basic concepts in such a way that users can easily extend the system: classes inheritance types functions Other features provide additional power and flexibility: constraints triggers rules transaction integrity These features put Postgres into the category of databases referred to as object-relational https://www.postgresql.org/docs/6.3/c0101.htm https://www.postgresql.org/docs/6.3/c0101.htm
- oaiey 3y agoThanks. Very much a buzzword then.
- brazzy 3y agohttps://stackoverflow.com/questions/45865961/what-does-postgresql-to-be-ordbms-mean https://stackoverflow.com/questions/45865961/what-does-postg...
- grzm 3y agoIt's been object relational (and described as such) going way back. I think the most visible (if infrequently used) object-oriented feature that it has is inheritance: https://www.postgresql.org/docs/current/tutorial-inheritance.html https://www.postgresql.org/docs/current/tutorial-inheritance...
- nieve 3y agoIt's because PostgreSQL has inheritance and has almost certainly used the term object relational since before you heard of it.
- zetalyrae 3y agoI looked this up the other day because I was similarly surprised, I think it refers to Postgres' ability to do table inheritance: https://www.postgresql.org/docs/current/tutorial-inheritance.html https://www.postgresql.org/docs/current/tutorial-inheritance...
- stubish 3y agoObject Databases were once a thing, and PostgreSQL PostgreSQL used the term Object Relational to indicate it could be used as both an Object Database (it supports table inheritance) and/or a Relational Database. Not that you should ever use the feature, being a historical artifact full of historical gotchas and your clever design becomes a maintenance burden.