Why favor PostgreSQL over MariaDB/MySQL?

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

There is one point I need to add it here. Note that I'm not DB expert, but I need to say why I prefer Postgres over Mysql.

Create a table like the following:

create table user (name varchar(4));

MySql:

insert into user (name) values ('antoaravinth');

The above statement works even though I have given the size of my varchar as 4! And retrieving gives me `anto`!!

Postgres:

insert into user (name) values ('antoaravinth');

Stops me there with the relevant exception! That shows how Postgresql is doing small things right.

After seeing this, I never used MySql!

[ Parent | on HN ]

Re:Why favor PostgreSQL over MariaDB/MySQL? by sigi45 on Tuesday September 05, 2017 @07:37AM (#15174175)

As said in many other comments: This is because you used MySQL in non strict mode. You don't run MySQL on Production in non strict mode.

[ Parent | on HN ]

Re:Why favor PostgreSQL over MariaDB/MySQL? by thehardsphere on Tuesday September 05, 2017 @10:59AM (#15175850)

As said in many other comments, the idea that there is even a "strict mode" which was not on by default for many years is itself a problem and a red flag for other problems.

[ Parent | on HN ]

Re:Why favor PostgreSQL over MariaDB/MySQL? by koffiezet on Friday September 08, 2017 @09:45AM (#15200071)

Tell that to developers who develop with the default config and then expect that to work in "Production".

[ Parent | on HN ]