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

Oracle vs. PostgreSQL – A Comment

postgresql.org

Post reply on HN
Print view View original

21–30 of 238 posts

Re: Oracle vs. PostgreSQL – A Comment

#21

Post by phoe-krk »

justinvh wrote: post #18
craigkerstiens wrote: post #4

I'm a big fan of Postgres, and it's got plenty going for it. That's not to say Oracle isn't a good database in its own right. The knocks against Oracle tend to be lock-in, complexity, price, but rather than go in a checklist comparison I'd rather say what's unique about Postgres: - Based on its license it's very hard for any one company or individual to "own" Postgres, this makes risk of a company as a bad actor bein…

> Its geospatial capabilities put it as the most advanced geospatial database, only ESRI software really stands to beat it here Where does PostGIS stand in comparison?

Likely the OP means PostGIS where they say Postgres. PostGIS is the set of geospatial extensions for Postgres.

Re: Oracle vs. PostgreSQL – A Comment

#22

Post by GordonS »

phoe-krk wrote: 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?

Re: Oracle vs. PostgreSQL – A Comment

#23

Post by jcriddle4 »

Justsignedup wrote: post #7

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…

Obviously you don't have experience with Oracle or you would have written hundreds of thousands of dollars in license fees... /s

Re: Oracle vs. PostgreSQL – A Comment

#24

Post by phoe-krk »

GordonS wrote: post #22
phoe-krk wrote: 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?

In one of the Star Wars movies, there was a hooded and cloaked figure who, in response to that very same question, said, "I will make it legal."

There's no proof that figure wasn't Larry Ellison.

/s

Re: Oracle vs. PostgreSQL – A Comment

#25

Post by craigkerstiens »

phoe-krk wrote: post #21
justinvh wrote: post #18

Earlier quoted context omitted.

> Its geospatial capabilities put it as the most advanced geospatial database, only ESRI software really stands to beat it here Where does PostGIS stand in comparison?

Likely the OP means PostGIS where they say Postgres. PostGIS is the set of geospatial extensions for Postgres.

Correct, my intention was fully PostGIS == Postgres geospatial.

Re: Oracle vs. PostgreSQL – A Comment

#26

Post by kumarvvr »

With the amount of hype and mind share micro-services attract, I hope the era of large database clusters like Oracle comes to an end.

At the system level, even Oracle has to do some sort of message passing stuff to be able to distributed databases.

With the availability of streaming services, resilient distributed computation and data storage architectures, I hope companies like Oracle die a slow, but graceful death.

PostgreSQL and advanced database systems like FoundationDB, with help of stream / event processing systems, should be able to replace large Oracle clusters.

The problem of "lock-in" is a business problem and ought to be solved my the MBA's in my view.

Re: Oracle vs. PostgreSQL – A Comment

#27

Post by GordonS »

phoe-krk wrote: post #24
GordonS wrote: post #22

Earlier quoted context omitted.

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

In one of the Star Wars movies, there was a hooded and cloaked figure who, in response to that very same question, said, "I will make it legal." There's no proof that figure wasn't Larry Ellison. /s

I can't argue with that. I suppose regardless of how ridiculous it is, Oracle has very deep pockets and is infamously litigious, and the US legal system doesn't help - given that, I doubt legality really matters...

Re: Oracle vs. PostgreSQL – A Comment

#28

Post by asldkfja_skdlf »

Honest question, what is that with former Oracle clients and SUSE LInux?

Did the Novell ownership make it similar/alternative to Oracle stuff? Or is it just that it was the first linux with a paid support option and those folks likely used it earlier because of this?

Asking for people that actually use openSUSE today, not other pundits with baseless hypothesis like myself :)

Re: Oracle vs. PostgreSQL – A Comment

#29

Post by NOGDP »

vbezhenar wrote: post #15

That's not a very useful comparison. Databases are made to execute queries, not to install them. The only useful metric is performance and features (and price, of course). Sure, Oracle is bloated and pain to manage, but if it works faster, provides unique features and costs less in the end, people will use it.

> Sure, Oracle is bloated and pain to manage, but if it works faster, provides unique features and costs less in the end, people will use it.

_if_

Of course, those aren't the only reasons, and probably not the the main reasons, why big orgs use bloated proprietary crapware.

Post reply on HN