Oracle has adopted BOOLEAN in 23ai and PostgreSQL had it forever
1–10 of 20 posts
Re: Oracle has adopted BOOLEAN in 23ai and PostgreSQL had it forever
#2It'd be interesting to see what percentage of companies signed up with Larry stick with Larry out of sheer momentum. Sure, proprietary DBMSes can be faster and more efficient, but I can't imagine they'd be so much more efficient as to justify the license fee, so something else would have to be the justification.
Re: Oracle has adopted BOOLEAN in 23ai and PostgreSQL had it forever
#3It'd be interesting to see what percentage of companies signed up with Larry stick with Larry out of sheer momentum. Sure, proprietary DBMSes can be faster and more efficient, but I can't imagine they'd be so much more efficient as to justify the license fee, so something else would have to be the justification.
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.
Re: Oracle has adopted BOOLEAN in 23ai and PostgreSQL had it forever
#4It'd be interesting to see what percentage of companies signed up with Larry stick with Larry out of sheer momentum. Sure, proprietary DBMSes can be faster and more efficient, but I can't imagine they'd be so much more efficient as to justify the license fee, so something else would have to be the justification.
Any one of: the risk of a migration going wrong is too high, application or infrastructure compatibility issues, or the cost of retraining staff who work with the database to work with something else.
It is possible that there are simple solutions to these problems, but the perception that they are serious will turn companies away from a migration.
Re: Oracle has adopted BOOLEAN in 23ai and PostgreSQL had it forever
#5It'd be interesting to see what percentage of companies signed up with Larry stick with Larry out of sheer momentum. Sure, proprietary DBMSes can be faster and more efficient, but I can't imagine they'd be so much more efficient as to justify the license fee, so something else would have to be the justification.
Any one of: the risk of a migration going wrong is too high, application or infrastructure compatibility issues, or the cost of retraining staff who work with the database to work with something else. It is possible that there are simple solutions to these problems, but the perception that they are serious will turn companies away from a migration.
I think everybody has a horror story about code depending on the empty string and NULL being the same, silly stuff like that can trip up migrations.
The main reason I'd say is that there's no functional benefit to ripping out a database and replacing it, so there's always something more important to do that actually drives revenue.
I'd argue that postgres brings with it substantially lower risks in terms of license compliance/audits/price hikes. Not sure if that can drive a migration, but it should be reason enough to select open source for new projects.
Re: Oracle has adopted BOOLEAN in 23ai and PostgreSQL had it forever
#6Meanwhile regarding distributed transactions....
Re: Oracle has adopted BOOLEAN in 23ai and PostgreSQL had it forever
#7It'd be interesting to see what percentage of companies signed up with Larry stick with Larry out of sheer momentum. Sure, proprietary DBMSes can be faster and more efficient, but I can't imagine they'd be so much more efficient as to justify the license fee, so something else would have to be the justification.
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 + Oriole could come sooner.
Re: Oracle has adopted BOOLEAN in 23ai and PostgreSQL had it forever
#8[deleted]
Re: Oracle has adopted BOOLEAN in 23ai and PostgreSQL had it forever
#9This post is mostly an ad for their migration services?.
Re: Oracle has adopted BOOLEAN in 23ai and PostgreSQL had it forever
#10Earlier 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…
Depends on what circles you are in. If you spend time on HN you see a lot of SQLite and Postgres discussion and building. I can't remember the last time I saw an interesting article here about using MySQL/Oracle/MSSQL. You use those because your CIO told you, like COBOL.