5 ms·

As someone who chose MySQL and provides direction to developers who really like Postgres, and who also uses Postgres for fun, I do find myself having to both de

As someone who chose MySQL and provides direction to developers who really like Postgres, and who also uses Postgres for fun, I do find myself having to both defend MySQL as a prudent option and convince them that I know anything at all about Postgres or computer science. :)

ForHackernews 6y ago
I've heard MySQL (well, MariaDB, really) has improved a lot in recent years, but I still can't imagine why I'd ever choose it over Postgres for a professional project. Is there any reason? It used to be that bargain basement shared-hosting providers would only give you a LAMP stack, so it was MySQL or nothing. But if you're on RDS, Postgres every time for my money.
- VWWHFSfQ 6y ago
  mysql's admin tools are still far superior than what's available for postgres
  - cyral 6y ago
    What tools are these? Curious as a Postgres user
    - larrik 6y ago
      MySQL Workbench is actually pretty damn good.
    - philliphaydon 6y ago
      As a PostgreSQL user. Pgadmin 4 is the worst.
      - OOPMan 6y ago
        PgAdmin3 was much better, but then they decided to turn it into a web application and we got PgAdmin4 Very annoying.
        philliphaydon 6y ago
        I used to use PgAdmin 3, but after... I donno how many years now, the PgAdmin4 is still a buggy mess. It's really sad because all the contributors to Postgres have made an AMAZING database that's such a joy to work with. And then there's PgAdmin4 where its almost like they just don't care... I don't feel I'm smart enough to contribute anything to PgAdmin4 to try make it better. So I stick to DataGrip and DBeaver.
    - lucassen 6y ago
      I spent a little time in it and I really like DBeaver. Free tier works great.
    - 101011 6y ago
      I've probably tried a dozen or so. For MySQL, I haven't found anything that beats SequelPro. For Postgres, I haven't found anything that comes close to parity, but my favorite is Postico. I know people that swear by IntelliJ for their db stuff, it just never hit home for me personally though.
      - pnwhyc 6y ago
        TablePlus is fantastic and supports all the most popular DB’s, including Postgres & MySQL. https://tableplus.com/ https://tableplus.com/ It’s the only DB client that doesn’t look like it was built in the 90’s. Slick UX & UI. Nice balance between developer tool & admin tool
      - AlfeG 6y ago
        For PG - DBeaver do a damn good job for me.
        scaryclam 6y ago
        DBeaver is certainly underhyped. Moved over to using it from MySQL Workbench and so far it's been a big improvement. I can't compare against SequelPro as I don't have a Mac, but DBeaver's worth a try for anyone looking for a cross platform DB editor
gav 6y ago
I tend to find people who argue with me against MySQL bring up things that haven't been true in a long time such as Unicode or NULL handling. I'd probably choose Postgres over MySQL for a new project just to have the improved JSON support, but there's upsides to MySQL too: - Per-thread vs per-process connection handling - Ease of getting replication running - Ability to use alternate engines such as MyRocks
- johannes1234321 6y ago
  MySQL also has great JSON features (json data type, virtual indexes onnit, multi-value (array) indexes, json_table, ....)
  - twic 6y ago
    I'd be impressed if these were better than PostgreSQL's JSON features. Do you know how they compare?
    - namibj 6y ago
      2 years ago, they were worse, from what I recall.
- ascom 6y ago
  MyRocks is a little bit janky in my experience - it doesn't support some transaction isolation levels, fails to handle some workloads that rely on locking (such as a job queue), has failed to upgrade MariaDB minor versions [0], has very sparse documentation, and overall has given me some amount of unexpected behavior. Though I'm willing to put up with it due to its incredible compression capabilities... [0]: https://jira.mariadb.org/browse/MDEV-22609 https://jira.mariadb.org/browse/MDEV-22609
- OOPMan 6y ago
  MySQL has definitely improved a lot since 5.0 but it still had a few warts.
- stickfigure 6y ago

ForHackernews 6y ago

I've heard MySQL (well, MariaDB, really) has improved a lot in recent years, but I still can't imagine why I'd ever choose it over Postgres for a professional project. Is there any reason? It used to be that bargain basement shared-hosting providers would only give you a LAMP stack, so it was MySQL or nothing. But if you're on RDS, Postgres every time for my money.

VWWHFSfQ 6y ago
mysql's admin tools are still far superior than what's available for postgres
- cyral 6y ago
  What tools are these? Curious as a Postgres user
  - larrik 6y ago
    MySQL Workbench is actually pretty damn good.
  - philliphaydon 6y ago
    As a PostgreSQL user. Pgadmin 4 is the worst.
    - OOPMan 6y ago
      PgAdmin3 was much better, but then they decided to turn it into a web application and we got PgAdmin4 Very annoying.
      - philliphaydon 6y ago
        I used to use PgAdmin 3, but after... I donno how many years now, the PgAdmin4 is still a buggy mess. It's really sad because all the contributors to Postgres have made an AMAZING database that's such a joy to work with. And then there's PgAdmin4 where its almost like they just don't care... I don't feel I'm smart enough to contribute anything to PgAdmin4 to try make it better. So I stick to DataGrip and DBeaver.
  - lucassen 6y ago
    I spent a little time in it and I really like DBeaver. Free tier works great.
  - 101011 6y ago
    I've probably tried a dozen or so. For MySQL, I haven't found anything that beats SequelPro. For Postgres, I haven't found anything that comes close to parity, but my favorite is Postico. I know people that swear by IntelliJ for their db stuff, it just never hit home for me personally though.
    - pnwhyc 6y ago
      TablePlus is fantastic and supports all the most popular DB’s, including Postgres & MySQL. https://tableplus.com/ https://tableplus.com/ It’s the only DB client that doesn’t look like it was built in the 90’s. Slick UX & UI. Nice balance between developer tool & admin tool
    - AlfeG 6y ago
      For PG - DBeaver do a damn good job for me.
      - scaryclam 6y ago
        DBeaver is certainly underhyped. Moved over to using it from MySQL Workbench and so far it's been a big improvement. I can't compare against SequelPro as I don't have a Mac, but DBeaver's worth a try for anyone looking for a cross platform DB editor

gav 6y ago

I tend to find people who argue with me against MySQL bring up things that haven't been true in a long time such as Unicode or NULL handling. I'd probably choose Postgres over MySQL for a new project just to have the improved JSON support, but there's upsides to MySQL too: - Per-thread vs per-process connection handling - Ease of getting replication running - Ability to use alternate engines such as MyRocks

johannes1234321 6y ago
MySQL also has great JSON features (json data type, virtual indexes onnit, multi-value (array) indexes, json_table, ....)
- twic 6y ago
  I'd be impressed if these were better than PostgreSQL's JSON features. Do you know how they compare?
  - namibj 6y ago
    2 years ago, they were worse, from what I recall.
ascom 6y ago
MyRocks is a little bit janky in my experience - it doesn't support some transaction isolation levels, fails to handle some workloads that rely on locking (such as a job queue), has failed to upgrade MariaDB minor versions [0], has very sparse documentation, and overall has given me some amount of unexpected behavior. Though I'm willing to put up with it due to its incredible compression capabilities... [0]: https://jira.mariadb.org/browse/MDEV-22609 https://jira.mariadb.org/browse/MDEV-22609
OOPMan 6y ago
MySQL has definitely improved a lot since 5.0 but it still had a few warts.
stickfigure 6y ago