Live data from Hacker News

Oracle vs. PostgreSQL – A Comment

postgresql.org

51–60 of 238 posts

Re: Oracle vs. PostgreSQL – A Comment

#51

Earlier quoted context omitted.

> any program benchmark tests Don't think installation size or length of time taken to set up the program really qualify as a "program benchmark test", so he should be fine

Why not? Installation time and disk size are two values that may be important for some customers, and measuring those might therefore be considered benchmarks.

He did not run a "program benchmark test". Terms are meant to be specific

Re: Oracle vs. PostgreSQL – A Comment

#52

As a developer: - No license fees is huge. My company saves tens of thousands on license fees when we can't really afford it. - The ability to set up environments super quickly is amazing. - Rollback of DDLs is huge for testing migrations - The backup features aren't broken by default. I've spent hours researching how to back up an oracle db and transfer it to another. And at that point versions matter. With postures…

> Rollback of DDLs

Oracle can't roll back these (create table/drop index etc)? That really surprises me. Pretty certain MSSQL can, because I've used it. Amazed, actually, that oracle can't.

Re: Oracle vs. PostgreSQL – A Comment

#53
post #49

Earlier quoted context omitted.

Oracle may very well want to litigate it. I doubt they care about the optics. This is the well-known DeWitt clause, so named because Oracle crafted it to squelch database research being performed by Dr. David DeWitt. I believe these clauses should be clearly ruled as illegal, but to my knowledge they still persist. Details here: https://dwheeler.com/essays/dewitt-clause.html

If they decide to litigate, they might learn what a Streisand effect[0] is. [0] http://en.wikipedia.org/wiki/Streisand_effect

> I doubt they care about the optics.

I’ve never dealt with Oracle myself, yet even I’ve known about their reputation since before I joined the software industry.

Re: Oracle vs. PostgreSQL – A Comment

#54
post #45

Earlier quoted context omitted.

Chances are, he lives in a country where essentially saying "by purchasing our product you agree not to tell anyone how bad it is" is unenforceable. That might even include US.

The fact that something is unenforceable is a poor way of stopping rich lawyer-based companies, such as Oracle, from attempting to enforce it nonetheless.

Not all countries allow the "sue to bankruptcy" litigation model. I'd truly love to see this unfold in Germany, for example. They typically award costs to the winner too.

Re: Oracle vs. PostgreSQL – A Comment

#55

>” create stand alone database: ~30m” Something is oddly wrong in his tests if it took him 30 minutes to create an oracle database.

It can really take that long. Initial bootstrapping of the Oracle database docker containers can take upwards of an hour.

Re: Oracle vs. PostgreSQL – A Comment

#56
post #45

Earlier quoted context omitted.

Chances are, he lives in a country where essentially saying "by purchasing our product you agree not to tell anyone how bad it is" is unenforceable. That might even include US.

The fact that something is unenforceable is a poor way of stopping rich lawyer-based companies, such as Oracle, from attempting to enforce it nonetheless.

You can do like what Videolan is doing for VLC: the president reply to the lawyers that they have no power there.

Re: Oracle vs. PostgreSQL – A Comment

#57
post #22
post #3

Copying from https://stackoverflow.com/questions/12115397/is-it-against-l... : The standard license ( http://www.oracle.com/technetwork/licenses/standard-license-... ) you agree to when you download software from the Oracle Technology Network (OTN) does state that you're not allowed to disclose benchmarks. You may not: > - disclose results of any program benchmark tests without our prior consent. I sadly suspect that…

> You may not: > I mean... does anyone here think this is in any way reasonable? Is this even legal?

It's not about making it reasonable, it's an open threat to punish anyone who does decide to benchmark Oracle. Nobody's going to win the case, but whoever violates the term will surely wind up bankrupt defending themselves.

Re: Oracle vs. PostgreSQL – A Comment

#58

Earlier quoted context omitted.

There will always be a lot of use for large databases. PostgreSQL does provide some under-the-hood features for doing distributed db's (such as the PREPARE TRANSACTION extension) but the actual implementation work is left to the user - there's no such thing as a "one size fits all" solution in this domain.

Exactly, so, what use cases is Oracle best suited for, situations where Postgres cannot be a good fit?

When you have a sore back from lugging around your wallet, and it needs lightening for your own good.

Not that MSSQL isn't heading that way, and getting more weird and buggy all the time.

Re: Oracle vs. PostgreSQL – A Comment

#59

As a developer: - No license fees is huge. My company saves tens of thousands on license fees when we can't really afford it. - The ability to set up environments super quickly is amazing. - Rollback of DDLs is huge for testing migrations - The backup features aren't broken by default. I've spent hours researching how to back up an oracle db and transfer it to another. And at that point versions matter. With postures…

> Rollback of DDLs Oracle can't roll back these (create table/drop index etc)? That really surprises me. Pretty certain MSSQL can, because I've used it. Amazed, actually, that oracle can't.

MSSQL can roll back DDL. But the DDL changes are not fully transactional, as other trans sacri one can see new columns and tables before the DDL transacrion commits.

Postgres gets it right. DDL is contained in the transacrion until commit.

Re: Oracle vs. PostgreSQL – A Comment

#60
post #3

Copying from https://stackoverflow.com/questions/12115397/is-it-against-l... : The standard license ( http://www.oracle.com/technetwork/licenses/standard-license-... ) you agree to when you download software from the Oracle Technology Network (OTN) does state that you're not allowed to disclose benchmarks. You may not: > - disclose results of any program benchmark tests without our prior consent. I sadly suspect that…

SQL Server has the same thing if I’m not mistaken. There’s a big reddit benchmark post that goes out of its way not to say SQL Server in the benchmark just for that reason.
Post reply on HN