RE: Q: Comparing PostgreSQL and Oracle

Hi,

With massive development within OSS PosgreSQL over the years, there is plenty of things it can do when compared to
Oracle.The below URLs give you a comprehensive comparison table, I am sure you or your colleagues may have already
stumbledupon these URLs. In addition to that, there is something called "oracle compabilities" for PostgreSQL which
makesit more like Oracle for most of the Oracle's native functionalities like packages and procedures  etc.
 

https://db-engines.com/en/system/Oracle%3BPostgreSQL

https://db-engines.com/en/system/MySQL%3BOracle%3BPostgreSQL




-----Original Message-----
From: Alfonso <achavesco@gmail.com>
Sent: Wednesday, 20 May 2020 7:56 AM
To: pgsql-general@lists.postgresql.org
Subject: Q: Comparing PostgreSQL and Oracle

Hi colleagues.


I'm working in a Java application with some colleagues and we are in doubt wether to use Oracle or PostgreSQL as the
datastore. It will be a OLTP mainly application.
 

Beside of license terms/costs  which is a clear point in favor of PostgreSQL, could you please help me to get some more
detailsregarding what you can do in PostgreSQL and you can't in Oracle oand viceversa, and what can be done using both
butit is better done by PostgreSQL vs Oracle and so on?
 

I mean, about functionalities, performance, support costs if any and qualtity, etc.


Many thanks.

Best Regards.





IMPORTANT NOTE: Fuji Xerox email transmission, including any attachments, is private and confidential and may contain
legallyprivileged information. It is for the addressee's attention only. If you are not the intended recipient and have
receivedthis transmission, you must not use, edit, print, copy or disclose its contents to any person or disseminate
theinformation contained herein or hereto attached, and you must notify sender immediately by return email and delete
thistransmission from your system. Any confidentiality, privilege or copyright is not waived or lost because this
e-mailhas been sent to you in error. We have used reasonable efforts to protect this transmission from computer viruses
andother malicious software, but no warranty is made and the sender takes no responsibility for any loss or damage
incurredfrom using this email or the information contained in this email.