Live data from Hacker News

Amazon’s Consumer Business Turned Off Final Oracle Database

aws.amazon.com

211–220 of 471 posts

Re: Amazon’s Consumer Business Turned Off Final Oracle Database

#211

Earlier quoted context omitted.

Somebody can build a consulting business from this HN comment.

This is the first time I have wished Hacker News showed upvotes. They have got to be over 100 with that right?

You can model it.

- Get upvote snapshots of all top-level comments' authors in this thread. Take repeated measurements at relatively low time resolution. Also compare this to any other comments they may be making (have a model of the type of comment: follow-ups that are deeply nested probably have a lower upvote velocity)

- Find archive.org snapshots of OP as well as the authors of all other upvoted comment threads. Find the delta from then to now. Some authors will have recent data.

- For a better model, construct historical graphs of all authors using these methods and use it to iteratively adjust.

- Make sure you understand the ranking algorithm and that it is reflected in your model.

Nontrivial, but could be a fun exercise.

Re: Amazon’s Consumer Business Turned Off Final Oracle Database

#212

The developer carrying it out still using 2015 MBP

I'm also on a 2015 model, but it was manufactured in early 2017 so it's not that old. I and several people I know are holding out on the 2015s for as long as they can because of ports, no touch bar, and a better keyboard compared to the newer models.

Re: Amazon’s Consumer Business Turned Off Final Oracle Database

#213
post #191

Earlier quoted context omitted.

1. When did I say that Amazon replaced Oracle with MySQL? I just said that MySQL is an Oracle database. 2. Open Source licenses that Amazon is not violating - a 3rdparty lawyer would be able to ascertain better about the extent of legality on Amazon's changes and its contribution back to open source software than you and I do. 3. Ex-Amazon employee here. My comments are purely based on my observation - and purely my…

1. I assumed it was implied. Why else bring it up? 2. If there was a means to sue Amazon for hosting databases, Oracle would have already done it a LONG time ago with MySQL. The burden is on you to prove your claim. 3. You are free to talk as much as you want, just expect push back when you aren't right, a lot. ;)

1. and 2. Amazon does use a lot of MySQL, and the fact that they still do. Oracle can determine when and how it wants to bill Amazon. You and I can't change any of that.

3. Except when the other person isn't. You just lost me on the last comment.

Re: Amazon’s Consumer Business Turned Off Final Oracle Database

#214
post #200

Amazon is a slightly annoying company that I rarely root for, but Oracle is a predatory company whose customer relations strategy seems to actively involve litigating them as a default assumption. Amazon is considered a paragon of IT, so their expulsion of Oracle is a useful tool at the CIO/CTO level of "nobody ever got fired for IBM" level of reasoning. Unfortunately, AWS is becoming the new IBM in that reasoning. G…

> Amazon is a slightly annoying company that I rarely root for, but Oracle is a predatory company Amazon and Oracle couldn't be more different in this point of view. Amazon's predatory instincts are pointed inwards and downwards, towards employees and vendors, while being mostly great towards the customer. Everything from their warehouse workers with timers, the crying software engineers and all other things I hear a…

>the crying software engineers

Just like to point out that that NYT hit piece didn't actually interview any software engineers IIRC.

Re: Amazon’s Consumer Business Turned Off Final Oracle Database

#215
post #35

Earlier quoted context omitted.

> Microsoft SQL Server Out of the frying pan, into the fire.

MSSQL's really not too bad. Yes, it's a commercial offering, but there's nothing inherently evil about charging money for software, and you do get what you pay for. I've worked in both MSSQL shops and PostgreSQL shops, and, while I wasn't in charge of the budget, I wouldn't be at all surprised to find out that, once you factor paying your programmers and DBAs for their time into the equation, the MSSQL shop ended up…

I'm not sure I follow this logic. Wouldn't both databases require the same amount of care and feeding? Are you suggesting that you need less DBA's per MSSQL database than for a PostgreSQL or Maria database?

Re: Amazon’s Consumer Business Turned Off Final Oracle Database

#216

Here is the meat of the Report: >We migrated 75 petabytes of internal data stored in nearly 7,500 Oracle databases to multiple AWS database services including Amazon DynamoDB,Aurora, RDS, and Redshift. >We kept careful track of the costs and the performance, and realized the following results: >Cost Reduction – We reduced our database costs by over 60% on top of the heavily discounted rate we negotiated based on our…

I read it as saying those discounts had been negotiated over the past 10-15 years.

Re: Amazon’s Consumer Business Turned Off Final Oracle Database

#217
post #167

We've been working on migrating from Oracle to Postgres for a few years now. We are about 2 weeks from being finished. It is not for the faint of heart, but it is totally worth it. The documentation is much much better, performance is equivalent or better, the sql dialect is saner, etc. Other than moving the data itself (ora2pg was invaluable for this), rewriting the queries is what has taken the most amount of time.…

I wonder: How long before someone adds a patch to PostgreSQL as a 'compat' patch, or extension.

There's a company called enterprisedb that does just that.

While they keep their Oracle compatibility stuff proprietary, they do employ several of the postgresql core developers.

Re: Amazon’s Consumer Business Turned Off Final Oracle Database

#218

We've been working on migrating from Oracle to Postgres for a few years now. We are about 2 weeks from being finished. It is not for the faint of heart, but it is totally worth it. The documentation is much much better, performance is equivalent or better, the sql dialect is saner, etc. Other than moving the data itself (ora2pg was invaluable for this), rewriting the queries is what has taken the most amount of time.…

How do you develop and debug triggers?

Re: Amazon’s Consumer Business Turned Off Final Oracle Database

#219
post #200

Earlier quoted context omitted.

> Amazon is a slightly annoying company that I rarely root for, but Oracle is a predatory company Amazon and Oracle couldn't be more different in this point of view. Amazon's predatory instincts are pointed inwards and downwards, towards employees and vendors, while being mostly great towards the customer. Everything from their warehouse workers with timers, the crying software engineers and all other things I hear a…

>the crying software engineers Just like to point out that that NYT hit piece didn't actually interview any software engineers IIRC.

I did leave the company after the article came out because of how it jived with my experience.
Post reply on HN