undefined | Better HN

0 pointsamunicio8y ago0 comments

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).

0 comments

2 comments · 2 top-level

heyoni8y ago

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.

diaz8y ago

Also can exist indices inside the jsonb values and you can join tables on a field of the json. Which is imo very cool.

j / k navigate · click thread line to collapse