Live data from Hacker News

Oracle vs. PostgreSQL – A Comment

postgresql.org

131–140 of 238 posts

Re: Oracle vs. PostgreSQL – A Comment

#131
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…

Because benchmarks are largely worthless and just serve as internet forum arguments or mailing list fodder.

Re: Oracle vs. PostgreSQL – A Comment

#132
post #95

Earlier quoted context omitted.

Right but by that metric Oracle is archaic. Just look at Postgres[0] supported column data types and then look at Oracle[1]. Better data types means more tightly defined columns, which means fewer bugs/less defensive programming/reduced maintenance/reduced code complexity. No doubt someone will be along shortly to tell me "you don't NEED it!" and then tell me how to hack constraints into making it act like something…

You should store dates with timezone or you can't make calculations like how old is this post. You could base it off system time, but then the calculation have to take into account summer/winter time.

Everything in the DB should be UTC. Anything else is crazy.

Re: Oracle vs. PostgreSQL – A Comment

#133
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…

Remember kids: Oracle has no customers, only hostages!

Re: Oracle vs. PostgreSQL – A Comment

#134
post #96

Earlier quoted context omitted.

People are scared of corporations, but they don't really have much ability to damage you. They can't cause physical harm to your body. They can't take away your loved ones. All they can do is take some money. You started life with $0, so you can probably make it all back. It would be inconvenient, but not an existential crisis. The likeliest outcome is that nothing will happen. The second most likely outcome is that…

> It would be inconvenient, but not an existential crisis. Don't generalise from your life; you only have to take care of yourself and Ayaya. A majority of people are deeply committed to a relationship/family/tribe, where losing all one's money definitely constitutes a crisis.

Hey now, leave my Ayaya out of this.

Here is my point -- the potential losses are bounded. They can't unteach you what you've learned in 30 years of work, so you can probably earn income even after losing the biggest lawsuit EvilCorp can muster. Or go work at Starbucks if you are somehow banned from using computers, which is not really something that can happen for violating a software EULA. Compare this to driving to work -- you could get in a car accident that leaves you with a permanent brain injury. You'd never work again. You'd never recognize your family again. It's a big downside! And yet we drive.

Furthermore, I would be a little surprised to be reading "Extreme Car News" and seeing the first comment say "wow, you shouldn't modify your car to have that kind of acceleration, you could die!" People are aware of the risk, as they are experts in the field, and we are here to learn what we can from their experience without taking the risk ourselves. It therefore surprises me that everyone on a forum called "Hacker News" is speculating about the worst case outcome for writing a single mailing list post. The discussion has devolved into a trainwreck of "look at what could happen to that guy, I'm glad that's not me," which I think is pretty nasty to the author of the mailing list post, and kind of against the hacker spirit. He took a risk. Let's learn what we can.

Re: Oracle vs. PostgreSQL – A Comment

#135
post #131
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…

Because benchmarks are largely worthless and just serve as internet forum arguments or mailing list fodder.

Normally I would agree... But 27 seconds to 30 minutes to create an empty database?!

Re: Oracle vs. PostgreSQL – A Comment

#136

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

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

Re: Oracle vs. PostgreSQL – A Comment

#137
post #95

Earlier quoted context omitted.

You should store dates with timezone or you can't make calculations like how old is this post. You could base it off system time, but then the calculation have to take into account summer/winter time.

Everything in the DB should be UTC. Anything else is crazy.

This isn't true.

For example: If a user schedules an event to happen at 15:35 on July 29th 2021 IST, you cannot know with certainty what the equivalent UTC value is. You know what it would be assuming the relationship between IST and UTC stays the same between now and next year. If India suddenly decides to implement some sort of DST, or make any other changes to the definition to IST, the UTC value you stored is now wrong.

Timezones are political, but they're also how people organise their lives. The user's local timezone is context that you can't just discard.

Re: Oracle vs. PostgreSQL – A Comment

#138

Earlier quoted context omitted.

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

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

Funny story: I worked at a place which spent millions annually with Oracle. They had a couple hours downtime every day because they couldn’t afford the online backup product.

This was an Ivy League university with an endowment in the tens of billions.

Re: Oracle vs. PostgreSQL – A Comment

#139
post #41

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?

The original comment was about how few packages and how little space Postgres takes. PostGIS is good but it pulls in a lot of extra packages. I hate Oracle as much as anyone but this is no longer a fair comparison. If you’re bragging about how good PostGIS is, you’re no longer anywhere near a 66MB install. More like (IIRC) 5 to 10 times that.

But even assuming the high end of your estimate, Postgres + PostGIS would still be less than 1/10 of the size of a baseline Oracle installation.

Re: Oracle vs. PostgreSQL – A Comment

#140
post #95

Earlier quoted context omitted.

You should store dates with timezone or you can't make calculations like how old is this post. You could base it off system time, but then the calculation have to take into account summer/winter time.

Everything in the DB should be UTC. Anything else is crazy.

Some parts of Brasil decided to not observe daylight savings this year. I had to file a bug with Chrome which was converting dates in JS off by one hour for some Brazilian cities. Firefox got it right. If a couple of years ago you had stored my future appointment in your db using UTC, your db would now have the wrong time for my Brasil appointment.
Post reply on HN