Hacker News Reader

Comment by markdog12 | Hacker News Reader

Anything similar for MySQL?

Yes, don't use MySQL, use Postgres.

Why?

It's a well established fact that PostgreSQL is superior to MySQL in just about every category that appears in any comparison. Sometimes MySQL is just plain broken, e.g. that schema changes cannot be rolled back in a transaction.

One would be: Never use "utf8" character set, only "utf8mb4". "utf8" is limited to those characters that only use four bytes, and everything else will be truncated. "utf8mb4" is what you want when you think about UTF-8.

Don't use UNIX_TIMESTAMP() or FROM_UNIXTIME(). Both overflow in 2038.

I hoped you were kidding me, but no:

    $ perl -wE 'say scalar localtime 2177449200'
    Sat Jan  1 00:00:00 2039
    
    > select FROM_UNIXTIME(2177449200);
    +---------------------------+
    | FROM_UNIXTIME(2177449200) |
    +---------------------------+
    | NULL                      |
    +---------------------------+
    1 row in set (0.000 sec)

I work on a code base where the word UNIX_TIMESTAMP occurs 400 times :(

I wanted to come back and ask the same thing, only to guess there would be some snarky replies. Sure enough, there are, but sometimes we have to make the best of what we do have. I can't switch to PostgreSQL because some posters on Hacker News think or say MySQL is terrible or shouldn't be used for technical reasons. There are many highly successful profitable companies, small businesses, and start ups that have built their backend using MySQL. I'm not saying MySQL is better either.

To the topic of the post, if anyone knows about succinct list similar to this for MySQL that would be great. I tried to search for something after reading this, but wasn't having much success.

Don't use --password for the CLI

When to Use MySQL?

Never.

Reply on news.ycombinator.com