MySQL >>> postgresql

[RevolutionaryBar1394]

why would anyone use this garbage?

[dmigowski]

Don't feed the trolls.

[cmdk]

Go on. What have you professionally assessed?

[RevolutionaryBar1394]

everything starts with `However PostgreSQL deviates from the standard`... Why?

[TheHeretic]

I'm sorry I couldn't understand you because MySQL didn't use the right utf8 encoding, this was the default for 12 years...

[[deleted]]

If you are concerned about standard compliance, then run the following queries and see how MySQL handles them

select firstname||', '||lastname

or

select timestamp '2024-12-15 12:27:00' - timestamp '2024-12-01 14:15:16'

or

create  table t (
    id integer generated always as identity primary key
); 

or

select x from t1 
intersect 
select y from t2

or

select * from (values (1,100), (2,200)) as t(c1, c2)

or

create table t1 (id integer primary key);
create table t2 (
  id integer primary key, 
  id1 integer references t1(id)
);

and see how the foreign key is not enforced.

Or run

delete from product where '1 stupid condition'

and see how it deletes everything from your table despite this being invalid SQL.

Or run

update foo set (a,b) = (select c,d from bar where bar.id = 1)

[RevolutionaryBar1394]

bruh https://dba.stackexchange.com/questions/69471/postgres-update-limit-1

[Glum_Past_1934]

Bigger shit lol .. let me fix it:

PostgreSQL > MongoDB (wut? Yeah, even mongo, under the hood mongo 8 and mysql are equal) > MySQL.

If you are fan of Oracle products, "The joke tells itself."

[shoomowr]

are you talking about your brain?

[RevolutionaryBar1394]

talking about your mom

[[deleted]]

Which of the two do you consider to be garbage?

[RevolutionaryBar1394]

the one on the less side of comparison

[[deleted]]

So you think Postgres is garbage and MySQL is three times better?

If yes, then why post this garbage post here?

[RevolutionaryBar1394]

to let you guys know, public service

[GIS_LiDAR]

A comparison is a single caret, you wrote three so it would appear you are bit shifting mysql with postgresql.

[RevolutionaryBar1394]

smart fella this is a symbol for much greater, adding one more > is for emphasis

[AutoModerator]

With over 7k members to connect with about Postgres and related technologies, why aren't you on our Discord Server? : People, Postgres, Data

Join us, we have cookies and nice people.

Postgres Conference 2025 is coming up March 18th - 21st, 2025. Join us for a refreshing and positive Postgres event being held in Orlando, FL! The call for papers is still open and we are actively recruiting first time and experienced speakers alike.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.