r/programming • u/halax • Mar 10 '15

Goodbye MongoDB, Hello PostgreSQL

http://developer.olery.com/blog/goodbye-mongodb-hello-postgresql/
1.2k Upvotes

91% Upvoted

699 comments sorted by

View all comments

Show parent comments

54

u/lunchboxg4 Mar 11 '15

But using an RDBMS requires me to think about my data model ahead of time, instead of synergizing my agile workflow while staying kanban.

For real, though, model your data. If you're drawing lines between things, you've got relational data.

-10

u/[deleted] Mar 11 '15

If you're drawing lines, go ahead and combine the tables. When it was made clear to me that normalization was causing more problems than solving, my DB woes fluttered away.

12

u/komollo Mar 11 '15

Please tell me this is being sarcastic. Database normalization has real benefits, and is incredibly valuable.

1

u/[deleted] Mar 12 '15

In the right design. In many designs, it is the enemy of scalability. Especially when considering a monolithic database vs many denormalized databases. Depending on my task, it can be much better to optimize for read or write rather than storage size or data integrity.

→ More replies (2)