Postgres is a fully-relational (in that it simultaneously adheres to all of Codd's rules - something surprisingly rare) multi-paradigm database. It is multi-paradigm because it is also simultaneously a native object database and document database (JSONB support better than MongoDB), plus has ready extensions to be a first class Geodesic Database and Vector Database (ala AI) amongst others.
Just because "object" has become a bad word because of idiots who jump on bandwagons and don't even understand the term does not remove its value. There are still those of us around who used Postgres before it had SQL support and understand how it works internally. Note that all this extensibility is made achievable a great deal because it *is* underneath it all an Object Database. But I agree that we could use better marketing language to express the full potential of this remarkable open source project.
- - Ben Scherrey
On Wed, Dec 27, 2023, 2:11 AM Karl O. Pinc <kop@karlpinc.com> wrote:
Hi,
I don't want to start bikeshedding here but maybe the answer is simple.
The PG home page calls PG "object-relational". I question whether this is useful. Unlike in the 90's, nobody is really interested any more in object-oriented-everything and the typical person reading the home page probably does not know what an object-relational db is anyway.
It may be better to just say "relational".
In my opinion simpler is more clear and therefore better. (If another adjective is necessary I like "advanced". I feel it balances "powerful" and, in a sense, substitutes for the "object" qualifer. Because PG is more than just object-relational.)
I am only asking whether the home page should be changed. Changing the "object-relational" description elsewhere/everywhere is another matter entirely. I suppose I think this because I think the home page has a different, less sophisticated, audience.
FWIW, I know of at least 4 toggles between "relational" and "object-relational" on the wikipedia page. (It's been just "relational" for some time, but recently toggled back and forth. Feel free to explain on the talk page and change it from the current "relational" to "object-relational". I won't undo. I wrote the talk page entry mostly to keep the postgres-ignorant wikipedia enthusiasts from copy-pasting from the PG home page.)
This is not worth spending much time on but I wanted to raise the issue, hoping it can be quickly resolved. There seems to be no discussion in the pgsql-www mailing list archive.
Regards,
Karl <kop@karlpinc.com> Free Software: "You don't pay back, you pay forward." -- Robert A. Heinlein