News for hackers. Stuff that matters.
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
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

https://www.postgresql.org/docs/6.3/c0101.htm

Re:PostgreSQL: No More Vacuum, No More Bloat by oaiey on Sunday July 16, 2023 @05:34AM (#36745116)
Thanks. Very much a buzzword then.
Re:PostgreSQL: No More Vacuum, No More Bloat by grzm on Saturday July 15, 2023 @06:19PM (#36741455)
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 brazzy on Saturday July 15, 2023 @06:18PM (#36741453)
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.