4 ms·
PostgreSQL + JSON gets you working transactions and schemaless.
by zurn 11y ago
PostgreSQL + JSON gets you working transactions and schemaless.
- radicalbyte 11y agoPlus 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.
- Rezo 11y agoIt 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.
- Roboprog 11y agoHow 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)
- Roboprog 11y agoAlso, 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.
- s_kilk 11y agoShameless plug here, but my side-project (http://bedquiltdb.github.io 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.