News for hackers. Stuff that matters.
Re:“Fashion Is Hard. PostgreSQL Is Easy” [video] by sandGorgon on Thursday June 18, 2015 @12:05PM (#9739477)
do take a look if you can leverage jsonb datastructure of postgres - you get 80% of the power of mongo and all the advantages of postgres.

https://www.compose.io/articles/is-postgresql-your-next-json...

Re:“Fashion Is Hard. PostgreSQL Is Easy” [video] by emilburzo on Friday June 19, 2015 @01:59AM (#9743226)
Maybe I wasn't clear, I love everything about PostgreSQL.

But I would love it even more if it were easier to distribute (see replica sets in mongodb, with auto-failover and other goodies).

Re:“Fashion Is Hard. PostgreSQL Is Easy” [video] by ma2rten on Thursday June 18, 2015 @12:49PM (#9739899)
Actually the article you posted makes the case that postgres is not a good json database, because it can not modify json documents in place.
Re:“Fashion Is Hard. PostgreSQL Is Easy” [video] by neilc on Thursday June 18, 2015 @02:47PM (#9740771)
PG 9.5 will improve this situation somewhat, e.g., builtin functions like jsonb_set(), and overloading the '-' operator for jsonb values:

http://www.postgresql.org/docs/devel/static/functions-json.h...

That said, if you're doing a lot of mutation of large JSON documents stored in a single Postgres row value, the storage/concurrency control behavior still won't be ideal.

Re:“Fashion Is Hard. PostgreSQL Is Easy” [video] by valgog on Thursday June 18, 2015 @03:50PM (#9741187)
Actually if you really need to update large JSON documents efficiently, probably the only really efficient technology would be ToroDB http://www.8kdata.com/torodb/
Re:“Fashion Is Hard. PostgreSQL Is Easy” [video] by themartorana on Thursday June 18, 2015 @10:52PM (#9742769)
I would love to hear more - this is the first I'm hearing of Toro - it never comes up in NoSQL talks or conversations. Any decent success stories?
Re:“Fashion Is Hard. PostgreSQL Is Easy” [video] by valgog on Thursday June 18, 2015 @03:46PM (#9741165)
Actually without providing some benchmark results, the statement, that PostgreSQL has performance problems because of on-copy updating of JSONB, is groundless.