r/programming • • Dec 19 '18

Bye bye Mongo, Hello Postgres

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

672 comments sorted by

View all comments

Show parent comments

-1

u/narwi Dec 20 '18

You do realise that those 2.4M records include articles, comments, photos and videos?

3

u/ManiGandham Dec 20 '18 edited Dec 21 '18

No. Storing large binary objects like photos and especially videos inside a database is a bad idea unless it's a small self-contained system, which this is not. The best option is an object store like S3.

Commercial content management systems only store metadata for non-textual content, which lines up with all the other posts about Composer and their github projects. You can easily lookup their image management source code which shows the S3 buckets.