thda
Every now and then this misconception is found on HN.
I have managed teams of database administrators for roughly 10 years. And I know that using those arcane features or depending too much on those capabilities has cost millions to my company.
Avoid implementing everything in a database.
SQL server has a column store type of storage, and major innovations like 'froid'. Oracle is not such a strong leader there. Also, on a whole lot of workloads clickhouse is much superior.
Who in their right mind would do that ? It's a nightmare on so many levels....
Yeah those architectures were nice in the 90s. We don't do that anymore, for a whole lot of reasons. Being locked in with such a nefarious vendor is such a big risk.
You should reassess your critics before posting, I think. The evolution of postgresql is faster and faster.
You should check the latest commitfest. Improvements are coming, at a steady pace.
It is also in a lots of extremely critical ways inferior. The huge complexity, the huge footprint, the humongous prices are enough to justify staying far away from it.
You have this on postgresql.
> RAC and distributed transactions across a database cluster
Needed only in telcos where galera would be enough
It is not. And I know of several major banks leaving oracle "en masse" because of licensing nightmare. The major decision makers are now endangered by their choice of oracle as a database to consider. Oracle in a new project is now a firm NO.
Regarding HA, active/passive and failover is enough for 99% of the use cases. For the rest you'd need citus or patroni, but it's totally manageable. I'd be quite dismissive of an architect who suggests oracle if there are no extreme availability requirements. I'd also prefer a galera or an innodb cluster for active/active architectures.
Let's face it: oracle database is dying an its niche is shrinking.
Also, the spanish flu has killed between 50M - 100M according to the most recent estimations.
Life is the most important thing.
Also, it's kind of strange that on this forum people do not get the notion of exponential increase. It's twice worst every 72 hours. Time runs out really fast.
I'm french. I have italian friends. I don't care about the economy. It will be back up. As long as there are humans they will need goods.
> there will be no more projects even for IT people.
Sure. But let's put it in balance for France:
- less work for IT people
- 350K deaths
I vote for number one. I can't believe I'm reading that on this forum, where people are supposed to be educated. This is insane.