Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

Oracle has adopted BOOLEAN in 23ai and PostgreSQL had it forever

hexacluster.ai

Post reply on HN
Print view View original

11–20 of 20 posts

Re: Oracle has adopted BOOLEAN in 23ai and PostgreSQL had it forever

#11

Post by MangoToupe »

ksec wrote: post #7
SoftTalker wrote: post #3

Earlier quoted context omitted.

It's for the support in most cases. But last time I really used Oracle's RDBMS (10g era) it still had capabilities that no open source database had. If you really needed that, there wasn't an easy substitute. I'm sure Postgres has narrowed the gap by now.

In 2010-2015 when HN and Twitter or all social media at the time thought Postgres would take over the DB world in 10 years time. And yet Postgres 2025 ( ignoring extensions ) is still not competing well with Oracle / MSSQL in 2010-2015. And ignoring politics or preference MySQL is still in many ways better than Postgres. I am sure some day it would come. But it will likely take another 10 years. I just hope Neki + Or…

Postgres has mostly taken over the world outside of enterprise.

Enterprise has its own needs largely irrelevant to the rest of us.

Re: Oracle has adopted BOOLEAN in 23ai and PostgreSQL had it forever

#15

Post by Yeroc »

animitronix wrote: post #14

I'm other news, Oracle is hot garbage and always will be.

My experience has been the opposite. Oracle (the database) is actually a really solid product for the most part. Oracle (the company) is a different story. My eyes were really opened to some of the technical shortcomings in Postgres when we migrated from Oracle to Postgres a few years ago at $DAYJOB. Things like: a) global temp tables (there's an open source extension we had to use to fake this out), b) RLS (exists in PG but most functions that you might need to build on top perform badly), c) crashes in PG take out the whole database and a host of other smaller items. I'm not saying it wasn't worth it, but I wouldn't pretend Postgres is the best database either.

Re: Oracle has adopted BOOLEAN in 23ai and PostgreSQL had it forever

#16

Post by animitronix »

Yeroc wrote: post #15
animitronix wrote: post #14

I'm other news, Oracle is hot garbage and always will be.

My experience has been the opposite. Oracle (the database) is actually a really solid product for the most part. Oracle (the company) is a different story. My eyes were really opened to some of the technical shortcomings in Postgres when we migrated from Oracle to Postgres a few years ago at $DAYJOB. Things like: a) global temp tables (there's an open source extension we had to use to fake this out), b) RLS (exists i…

They lost me decades ago over the lack of auto incrementing PKs and having to cobble them together through a sequence and a trigger if I remember right. Seemed like utter nonsense. But I'll take your word that you got value out of the features you mentioned. The company side will forever prevent me from taking any of their products seriously though.

Re: Oracle has adopted BOOLEAN in 23ai and PostgreSQL had it forever

#18

Post by mulmen »

animitronix wrote: post #16
Yeroc wrote: post #15

Earlier quoted context omitted.

My experience has been the opposite. Oracle (the database) is actually a really solid product for the most part. Oracle (the company) is a different story. My eyes were really opened to some of the technical shortcomings in Postgres when we migrated from Oracle to Postgres a few years ago at $DAYJOB. Things like: a) global temp tables (there's an open source extension we had to use to fake this out), b) RLS (exists i…

They lost me decades ago over the lack of auto incrementing PKs and having to cobble them together through a sequence and a trigger if I remember right. Seemed like utter nonsense. But I'll take your word that you got value out of the features you mentioned. The company side will forever prevent me from taking any of their products seriously though.

I love Postgres and it is a shining example of how good software can be. Great job everyone, no notes.

BUT Oracle has some killer features that PG just doesn’t. The first that comes to mind is for-real multi-master. Close second is declaring partitions in the DDL of the table itself.

Re: Oracle has adopted BOOLEAN in 23ai and PostgreSQL had it forever

#19

Post by ranger_danger »

ksec wrote: post #7
SoftTalker wrote: post #3

Earlier quoted context omitted.

It's for the support in most cases. But last time I really used Oracle's RDBMS (10g era) it still had capabilities that no open source database had. If you really needed that, there wasn't an easy substitute. I'm sure Postgres has narrowed the gap by now.

In 2010-2015 when HN and Twitter or all social media at the time thought Postgres would take over the DB world in 10 years time. And yet Postgres 2025 ( ignoring extensions ) is still not competing well with Oracle / MSSQL in 2010-2015. And ignoring politics or preference MySQL is still in many ways better than Postgres. I am sure some day it would come. But it will likely take another 10 years. I just hope Neki + Or…

> MySQL is still in many ways better than Postgres

Source:

Re: Oracle has adopted BOOLEAN in 23ai and PostgreSQL had it forever

#20

Post by hyperman1 »

Yeroc wrote: post #15
animitronix wrote: post #14

I'm other news, Oracle is hot garbage and always will be.

My experience has been the opposite. Oracle (the database) is actually a really solid product for the most part. Oracle (the company) is a different story. My eyes were really opened to some of the technical shortcomings in Postgres when we migrated from Oracle to Postgres a few years ago at $DAYJOB. Things like: a) global temp tables (there's an open source extension we had to use to fake this out), b) RLS (exists i…

Oracle the database is the Apple of Enterprise. They have some best in class aspects, but also a lot of you're holding it wrong. They cost a lot and have a really arrogant culture. They both have a rabid reality-denying fanbase. The support is either fantastic if you ask a known question, or a hellscape of inconsistent answers and denials if you dont.
Post reply on HN