Re: Q: Comparing PostgreSQL and Oracle

For what it's worth, I used Oracle daily as a DBA and developer for my job
from 1983 until around 3 years ago when Postgres was chosen for a project I
was assigned to. I became pretty familiar with the workings of Oracle and
was somewhat skeptical when told we would be using Postgres, however it has
honestly been like a breath of fresh air. It has all the transactional
behaviour of a 'proper' RDBMS (even transactional DDL which as far as I'm
aware is still not supported in Oracle), and has all the features a
developer actually cares about. Postgres runs beautifully either locally on
a laptop, or in a Docker container using a tiny fraction of the resources
Oracle would need to do the same thing, so makes true local full-stack
development a delight. As someone familiar with both, I can honestly say go
with Postgres. You won't regret it.

Steve

On Wed, May 20, 2020 at 6:08 PM Ahmed, Nawaz (Fuji Xerox Australia) <
Nawaz(dot)Ahmed(at)aus(dot)fujixerox(dot)com> wrote:

> 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 stumbled upon these URLs. In addition to that, there is something
> called "oracle compabilities" for PostgreSQL which makes it 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(at)gmail(dot)com>
> Sent: Wednesday, 20 May 2020 7:56 AM
> To: pgsql-general(at)lists(dot)postgresql(dot)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 data store. 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 details regarding
> what you can do in PostgreSQL and you can't in Oracle oand viceversa, and
> what can be done using both but it 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 legally privileged information.
> It is for the addressee's attention only. If you are not the intended
> recipient and have received this transmission, you must not use, edit,
> print, copy or disclose its contents to any person or disseminate the
> information contained herein or hereto attached, and you must notify sender
> immediately by return email and delete this transmission from your system.
> Any confidentiality, privilege or copyright is not waived or lost because
> this e-mail has been sent to you in error. We have used reasonable efforts
> to protect this transmission from computer viruses and other malicious
> software, but no warranty is made and the sender takes no responsibility
> for any loss or damage incurred from using this email or the information
> contained in this email.
>