Re:Showdown: MySQL 8 vs. PostgreSQL 10
by amunicio on Wednesday May 23, 2018 @02:02PM
(#17136427)
Warning: I haven't used MongoDB in several years, so this info can be outdated!
The main advantage of using JSONB on Postgres over MongoDB is that you can create tables that mix regular fields (varchar, number, date, etc...) with JSONB fields.
Then you can do joins of your table with other tables (no need to map/reduce or other insane processing for a simple join).
Re:Showdown: MySQL 8 vs. PostgreSQL 10
by heyoni on Wednesday May 23, 2018 @02:38PM
(#17136785)
That actually sounds really cool. Honestly, even if Mongodb has all those features, I would much rather do everything on postgres seeing as I'm a hundred times more familiar with it than mongo.
The main advantage of using JSONB on Postgres over MongoDB is that you can create tables that mix regular fields (varchar, number, date, etc...) with JSONB fields. Then you can do joins of your table with other tables (no need to map/reduce or other insane processing for a simple join).