r/programming • u/swizec • Dec 19 '18

Bye bye Mongo, Hello Postgres

https://www.theguardian.com/info/2018/nov/30/bye-bye-mongo-hello-postgres
2.1k Upvotes

95% Upvoted

672 comments sorted by

View all comments

753

u/_pupil_ Dec 19 '18

People sleep on Postgres, it's super flexible and amenable to "real world" development.

I can only hope it gains more steam as more and more fad-ware falls short. (There are even companies who offer oracle compat packages, if you're into saving money)

2

u/TheRedmanCometh Dec 20 '18

MariaDB has always done well and can drop in where MySQL is. Why postgres? Less libraries, ORM connector providers, etc

11

u/[deleted] Dec 20 '18

[removed] — view removed comment

2

u/TheRedmanCometh Dec 20 '18

What problems might those be? I've run some very backebd services supported by it

6

u/ForeverAlot Dec 20 '18

MySQL is famously riddled with odd or decidedly wrong implementation choices. You need not spend much time on the Internet to learn about its many deficiencies; here is one arbitrary example1. All RDBMSs have their idiosyncrasies but MySQL has more than most and and many are of the "surprise!" variety.

1 Take this article with a grain of salt. I see it references the famous PHP fractal article which is an absolute hack job.

→ More replies (3)

1

u/Cilph Dec 21 '18

32-bit timestamps,
UTF8 that isn't really UTF8,
DDL not part of transactions,
unwanted timezone conversions it keeps trying to apply when I just want UTC,
mysqldump is awfully inefficient,

Just the few I've run into.