Why favor PostgreSQL over MariaDB/MySQL?

Re:Why favor PostgreSQL over MariaDB/MySQL? by teddyh on Tuesday September 05, 2017 @04:54AM (#15173498)

EDIT: Never mind, I read too much into what another commenter wrote.

[ Parent | on HN ]

Re:Why favor PostgreSQL over MariaDB/MySQL? by kaamos on Tuesday September 05, 2017 @04:56AM (#15173511)

No, this is all from MySQL Community Edition.

[ Parent | on HN ]

Re:Why favor PostgreSQL over MariaDB/MySQL? by teddyh on Tuesday September 05, 2017 @05:06AM (#15173541)

Then what about (https://news.ycombinator.com/item?id=15172965)?

[ Parent | on HN ]

Re:Why favor PostgreSQL over MariaDB/MySQL? by kaamos on Tuesday September 05, 2017 @05:11AM (#15173572)

Does that comment say I'm listing features only available in MySQL Enterprise Edition?

[ Parent | on HN ]

Re:Why favor PostgreSQL over MariaDB/MySQL? by teddyh on Tuesday September 05, 2017 @05:45AM (#15173721)

It does say that one feature you’re listing is not really sensible to use without the Enterprise Edition, but you’re right, it does not say that. Original comment redacted.

[ Parent | on HN ]

Re:Why favor PostgreSQL over MariaDB/MySQL? by kaamos on Tuesday September 05, 2017 @06:35AM (#15173896)

It is, in fact sensible without Enterprise Edition. The only thing it says is that page-level encryption in Community Edition is not intended as a regulatory compliance solution. Nothing more, nothing less.

Even in case you care about regulatory compliance, there are other options besides Enterprise Edition.

[ Parent | on HN ]

Re:Why favor PostgreSQL over MariaDB/MySQL? by porker on Wednesday September 06, 2017 @06:02AM (#15182396)

What are the other options, and when would page-level encryption in Community Edition be useful?

If I'm understanding it correctly, page-level encryption is to protect against someone gaining access to the DB server and copying the files off it. If the key is stored in a file on this DB server, I might as well not bother encrypting the pages.

[ Parent | on HN ]