Re: Oracle vs. PostgreSQL - a comment

From: Ravi Krishna <srkrishna(at)outlook(dot)com>
To: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Oracle vs. PostgreSQL - a comment
Date: 2020-06-05 12:33:59
Message-ID: AE48003F-310B-419B-AEFA-AD9E1968289F@outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

>> Plus PG does not directly support cross database queries using 3 part name, something
>> sqlserver excels at.

>Maybe because SQL server does not have real databases but schemas instead ?
>This sucks security wise.

SQLServer has real databases with its own transaction log files. You can restore individual databases in a cluster.
They also have schemas which are not same as users (Oracle treats users and schemas same).

For security, there is grant connect to the DB and further filtering based on schema.

I find SQLServer implementation pretty strong in this.

The only time this can be a problem is when few databases failover in a mirrored environment (streaming replication in PG speak).
Then suddenly 3 part names would fail if the remote DB is no longer primary. My experience with SQLServer is badly dated. Last
time I worked was SS2008. I believe in later versions they solved this problem by the failover group concept which failovers all
inter-related databases at one go.

BTW Mysql treats databases and schemas as same (that's what it was few years ago)

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Achilleas Mantzios 2020-06-05 12:48:55 Re: Oracle vs. PostgreSQL - a comment
Previous Message Achilleas Mantzios 2020-06-05 12:05:34 Re: Oracle vs. PostgreSQL - a comment