Ask HN: Posgresql JSON or MongoDB?

Re:Ask HN: Posgresql JSON or MongoDB? by angersock on Tuesday May 09, 2017 @08:59PM (#14305147)

Postgres JSONB is strictly better performing on a single node than MongoDB. You can also create triggers and things to properly validate your data and do other cool stuff you can't with Mongo.

There is literally no reason to ever use Mongo for a small-medium project anymore.

If you need tooling, check out the new pgAdmin 4: https://www.pgadmin.org/

[ Parent | on HN ]

Re:Ask HN: Posgresql JSON or MongoDB? by maerF0x0 on Tuesday May 09, 2017 @10:16PM (#14305465)

what about High Availability?

[ Parent | on HN ]

Re:Ask HN: Posgresql JSON or MongoDB? by tracker1 on Tuesday May 09, 2017 @11:30PM (#14305724)

Depending on your needs, MongoDB (also look at RethinkDB) are more mature in terms of administration of clustered/replica nodes... PostgreSQL has more of this working its' way into the box, but imho not there yet... Also, write scaling will do much better with MongoDB sharding or RethinkDB clustering.

[ Parent | on HN ]

Re:Ask HN: Posgresql JSON or MongoDB? by angersock on Wednesday May 10, 2017 @11:52AM (#14309157)

Just use Amazon RDS and let them deal with it.

None of the theoretical scaling benefits of Mongo outweigh the clusterfuck of maintenance, data inconsistency, and other general problems that shitty, shitty piece of software has.

[ Parent | on HN ]

Re:Ask HN: Posgresql JSON or MongoDB? by maerF0x0 on Friday May 12, 2017 @12:35AM (#14321471)

name checks out.

I didnt mind mongo in a couple of my previous jobs. We never noticed data issues and we did some crazy things like generating mongologs on one machine and moving them to another manually .

[ Parent | on HN ]

Re:Ask HN: Posgresql JSON or MongoDB? by memracom on Wednesday May 10, 2017 @03:32AM (#14306489)

PostgreSQL is not just a tool, it is now an ecosystem as well. There are numerous add-ons to provide various types of high availability. Some are plugins to PostgreSQL and some not. Also, some of these have commercial support if you need it.

And PostgreSQL 10 which is out in September will have logical replication added, which is rather useful in engineering a high-availability database.

[ Parent | on HN ]

Re:Ask HN: Posgresql JSON or MongoDB? by weishan on Thursday May 11, 2017 @04:33PM (#14319247)

MongoDB has HA built-in (replica sets). You will need to meddle with pacemaker/coroync or repmgr for HA in PostgreSQL.

[ Parent | on HN ]