News for hackers. Stuff that matters.

thda

https://en.wikipedia.org/wiki/Oberon_(operating_system)

Every now and then this misconception is found on HN.

Re:Oracle vs. PostgreSQL: First Glance on Wednesday May 06, 2020 @04:12AM (#23088903)
I thought that by large datasets you meant TB of data that we see in analytics. And in this area clickhouse is growing and coming to the big companies I work for, one way or another. postgresql handles the OLTP decently enough. That leaves only niches for oracle.
Re:Oracle vs. PostgreSQL: First Glance on Wednesday May 06, 2020 @04:07AM (#23088870)
As answered, pgadmin is first class and supports debugging.
Re:Oracle vs. PostgreSQL: First Glance on Wednesday May 06, 2020 @04:06AM (#23088865)
Indeed and the last two years in postgresql history have been very rich feature wise.

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.

Re:Oracle vs. PostgreSQL: First Glance on Monday May 04, 2020 @03:56PM (#23072555)
> Oracle DB also has been the leader performance wise for complex queries and large datasets

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.

Re:Oracle vs. PostgreSQL: First Glance on Monday May 04, 2020 @03:54PM (#23072533)
> Also Oracle was the first RDMS to support stored procedures in Java.

Who in their right mind would do that ? It's a nightmare on so many levels....

Re:Oracle vs. PostgreSQL: First Glance on Monday May 04, 2020 @03:52PM (#23072518)
> However, the killer feature for me is that it has application Express (or APEX) included, which is a complete web application development framework, as well as Oracle restful data services (ORDS). With built-in application development and deployment, it is the only complete, full-stack data management platform I am aware of (enterprise level).

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.

Re:Oracle vs. PostgreSQL: First Glance on Monday May 04, 2020 @03:40PM (#23072388)
I am. 13 release is planned in the 3rd quarter. The next commitfest is in july.
Re:Oracle vs. PostgreSQL: First Glance on Monday May 04, 2020 @03:34PM (#23072332)
Plugin_debugger is availlable on postgresql.org's repo. And supported by our postgresql support provider. You can of course use pgadmin, the official tool, with this plugin.

You should reassess your critics before posting, I think. The evolution of postgresql is faster and faster.

Re:Oracle vs. PostgreSQL: First Glance on Monday May 04, 2020 @01:44PM (#23071027)
> as far as I know no work has been done on it on 13 either.

You should check the latest commitfest. Improvements are coming, at a steady pace.

Re:Oracle vs. PostgreSQL: First Glance on Monday May 04, 2020 @01:35PM (#23070925)
> Oracle RDBMS is not an inferior product to open source competitors, in most ways superior

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.

Re:Oracle vs. PostgreSQL: First Glance on Monday May 04, 2020 @01:33PM (#23070909)
dbeaver and plugin_debugger. For distributed transactions, it all depends on why you need them in the first place but there are multiple solutions in postgres to handle them.
Re:Oracle vs. PostgreSQL: First Glance on Monday May 04, 2020 @12:42PM (#23070214)
> compilation to native code, graphical debugger.

You have this on postgresql.

> RAC and distributed transactions across a database cluster

Needed only in telcos where galera would be enough

Re:Oracle vs. PostgreSQL: First Glance on Monday May 04, 2020 @12:40PM (#23070187)
> This trope started reaching fever pitch during the first wave of OSS commercialization hype/fervor in 98. It wasn’t true then and I see no evidence it is any more true today.

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.

I has ravaged my country. However the bad situation of germany at that is to be blamed on the French for being too soft on this country after first world war. They should have been kept under control.

Also, the spanish flu has killed between 50M - 100M according to the most recent estimations.

Of course the spanish flu. The most deadly event in recorder history. Killed more than the two great wars.

Life is the most important thing.

Not true. France is hit, eastern France's hospitals are at full capacity. Doctors are starting to consider letting people over 70 die without access to an ICU.

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 afraid that on the long term, the social unrest and the economic consequences will far outweigh the damage done by the virus.

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.