The video strikes me as an epic troll: https://www.youtube.com/watch?v=9yBP5gnnZi4&feature=youtu.be
That was the actual shutdown. I was there, it was not rehearsed, and there were no retakes.
Amazon’s Consumer Business Turned Off Final Oracle Database
261–270 of 471 posts
Re: Amazon’s Consumer Business Turned Off Final Oracle Database
#262We'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.…
What about pl/sql to pl/pgsql?
Re: Amazon’s Consumer Business Turned Off Final Oracle Database
#263Amazon 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…
Isn't AWS much less prone to customer lock-in? May be I don't have experience with tweaking AWS under heavy high load, but 98% of code I write for backend that I host on Amazon isn't specific to AWS or it's services in any way.
Most people are not using generic services on AWS, preferring the Amazon-proprietary things like CloudFormation to open source things like Kubernetes.
Re: Amazon’s Consumer Business Turned Off Final Oracle Database
#264We'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 have a hard time believing PostgreSQL performance is better than Oracle, can you give an example? How big is your database and how much did migrating cost you?
A decade ago Sun Microsystems published a benchmark showing that PostgreSQL was really close to Oracle performance.
https://www.informationweek.com/open-source-postgresql-trail...
Re: Amazon’s Consumer Business Turned Off Final Oracle Database
#265We'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?
I'm not sure what you mean. Triggers are developed and debugged in Postgres the same as in Oracle.
Re: Amazon’s Consumer Business Turned Off Final Oracle Database
#266Earlier quoted context omitted.
It's the same now, but in previous versions there were important differences. Might be legacy code that's hard to make forward compatible.
AWS is maintaining separate releases of the JDK to help offset the release shenanigans of Oracle. And there are other concerted efforts to keep control from Oracle in releases and the validity of the JDK. As long as a sufficiently large majority (and AWS is helping here a lot, admittedly) maintain such regimented discipline, the JDK will be ok. Oracle mostly wanted it to sue google for billions. That suit is basicall…
Corretto is decent, but AWS just doesn't get non-Amazon devs/tooling, and so e.g. almost a year later, there is still no alpine docker image: https://github.com/corretto/corretto-8-docker/issues/1
Re: Amazon’s Consumer Business Turned Off Final Oracle Database
#267Earlier quoted context omitted.
PostgreSQL does not support the MERGE statement (at least not yet).
IIRC there was a discussion about adding the full ANSI MERGE statement, but in the end they added INSERT ... ON CONFLICT and left it at that: https://www.postgresql.org/docs/12/sql-insert.html#SQL-ON-CO...
Interesting, I can see where some of my confusion comes from if it was discussed but not completed. It's somewhat disappointing as I do think the ANSI MERGE statement is a good tool.
Re: Amazon’s Consumer Business Turned Off Final Oracle Database
#268Earlier quoted context omitted.
Next up: oracle sues Amazon for not using their product.
I wonder if their latency and performance claims in this blog post fall foul of Oracle's "No publishing benchmark results against our competitors".
What? How could that be legal? You can't say "Comparisons with competitors are not allowed" under a free market... right?
Re: Amazon’s Consumer Business Turned Off Final Oracle Database
#269Earlier quoted context omitted.
>the crying software engineers Just like to point out that that NYT hit piece didn't actually interview any software engineers IIRC.
Amazon IT employees are carrot-dangles a rolling set of future stock and other money, but as it stands now almost every new hire won't see that money. Amazon will get what they can out of them, and then mark them underperforming and fire them before it pays out any money. Some of the best people I know that have gone to work there have been subjected to this. After cycles of this, the only way to survive is to backst…
Absolutely incorrect. I worked there for 3 years, saw one person fired, and everybody who joined with me ended up vesting their shares. Most got promoted too.
Re: Amazon’s Consumer Business Turned Off Final Oracle Database
#270We'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.…
A lot of this sounds similar to MS SQL Server - the MERGE one sticks out, does Postgres not have MERGE?