2 ms·
> PG has weird behaviour sometimes too. Perhaps, but I'd argue that the "weird" behavior of postgres just tends to be clearly thought out design decisions that
by hn_throwaway_99 5y ago
> PG has weird behaviour sometimes too.
Perhaps, but I'd argue that the "weird" behavior of postgres just tends to be clearly thought out design decisions that they made for a valid reason that may cause you some pain with how you use it (e.g. their process-per-connection model).
MySQL's "weird" behavior, on the other hand, just tends to be completely invalid footguns like this. Despite what some people are arguing in this thread, a 3-byte version of UTF-8 was never in any spec anywhere and was an invalid shortcut from day 1.
- ipaddr 5y agoOracle, Postgres, MySql, mSql, sqlite all make weird behaviour in different situation. You pick your poison. I hated how postgres forced you to create a system user to connect I wonder if it still requires this.