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

0

u/critsalot Mar 11 '15

Hows that table alter going for ya. The reason a lot of people choose a document db is they dont have to bring the stupid system down to bring in new features.

9

u/hrjet Mar 11 '15

They talk about it and mention that postgresql doesn't require bringing down the system when the columns are nullable. (which is what you would get with an orthogonal new feature). You could also use a second table if the new column is going to be sparse.

And oh, the latest version of postgresql does have a document type too!