Hacker News new | ask | show | jobs
by tracker1 1748 days ago
There are definitely aspects of MSSQL I don't like... for the most part I don't mind it. I will say, if you're willing to pay the cost, getting advanced features setup and running in MSSQL is easier than any other RDBMS I've ever tried.

That said, still inclined to use PostgreSQL. I do not like MySQL at all, and every single time I've used it, I feel cringes of absolute pain... starting with "utf8" isn't UTF8, "utf8mb4" is. Or that indexing a binary field isn't case-insensitive (ie, binary) by default.

1 comments

isn't case-sensitive/binary... that one got me when migrating data and had converted from older identifiers to a UUID map.