News for hackers. Stuff that matters.
Re:Why some NoSQL DBs only let you perform transactions on a... by zurn on Friday October 30, 2015 @08:25AM (#10477377)
PostgreSQL + JSON gets you working transactions and schemaless.
Re:Why some NoSQL DBs only let you perform transactions on a... by radicalbyte on Friday October 30, 2015 @08:40AM (#10477416)
Plus it scales well and doesn't randomly lose data. Oh, and the project leaders are professionals who are honest and transparent about the capabilities of their product.
Re:Why some NoSQL DBs only let you perform transactions on a... by Rezo on Friday October 30, 2015 @08:59AM (#10477492)
It scales, to a point. In my opinion however, any type of sharding/clustering is still a total mess in PostgreSQL. Most projects will however probably never need to.
Re:Why some NoSQL DBs only let you perform transactions on a... by Roboprog on Friday October 30, 2015 @12:07PM (#10478637)
How DARE you, sir, imply that we are not the next "Amazon"!

Kidding aside, I suspect with a little discipline, one could design a PG DB that could be ported to Oracle (Exadata???) should the need, and budget ($$$$$), for that sort of scaling arise. Cheap and safe now, Expensive and safe later (if needed)

Re:Why some NoSQL DBs only let you perform transactions on a... by Roboprog on Friday October 30, 2015 @12:10PM (#10478653)
Also, I seem to recall that PG scales up on multiprocessor hardware fairly well (vs say MySQL), so one can explore exhausting that limit first before more drastic measures are taken.
Re:Why some NoSQL DBs only let you perform transactions on a... by s_kilk on Friday October 30, 2015 @11:46AM (#10478504)
Shameless plug here, but my side-project (http://bedquiltdb.github.io) aims to provide a nice mongo-a-like programmatic API on top of PostgreSQL and JSONB.

In theory there's no reason why we shouldn't be able to support a nice transactions API in the client drivers too, I just haven't gotten around to it yet.