Re:PostgreSQL: No More Vacuum, No More Bloat
by oaiey on Saturday July 15, 2023 @06:13PM
(#36741419)
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
[ Parent
| on HN ]
Re:PostgreSQL: No More Vacuum, No More Bloat
by feike on Saturday July 15, 2023 @06:18PM
(#36741450)
PostgreSQL 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
Thanks. Very much a buzzword then.
It'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...
Re:PostgreSQL: No More Vacuum, No More Bloat
by zetalyrae on Saturday July 15, 2023 @06:15PM
(#36741431)
I 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...
Re:PostgreSQL: No More Vacuum, No More Bloat
by nieve on Saturday July 15, 2023 @06:19PM
(#36741459)
It's because PostgreSQL has inheritance and has almost certainly used the term object relational since before you heard of it.
Re:PostgreSQL: No More Vacuum, No More Bloat
by stubish on Saturday July 15, 2023 @07:56PM
(#36742035)
Object 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.