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…
Oracle vs. PostgreSQL – A Comment
131–140 of 238 posts
Re: Oracle vs. PostgreSQL – A Comment
#132Earlier 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.
Re: Oracle vs. PostgreSQL – A Comment
#133Copying 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…
Re: Oracle vs. PostgreSQL – A Comment
#134Earlier 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.
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
#135Copying 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
#136As 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
#137Earlier 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.
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
#138Earlier 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
This was an Ivy League university with an endowment in the tens of billions.
Re: Oracle vs. PostgreSQL – A Comment
#139Earlier 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.
Re: Oracle vs. PostgreSQL – A Comment
#140Earlier 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.